Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, April 23, 2015

Oracle Financials List Of Standard Report Details

Application
Report Name
Description
Assets
@Tax Preference Report
Use this report to compare the year-to-date depreciation between your federal and corporate books for a range of asset accounts. The report shows the difference in year-to-date depreciation between the tax book you specify and its associated corporate book through the period you select. If the corporate book year-to-date depreciation is greater than that of the tax book, the report prints zero in the Difference column.
Assets
Account Drill Down Report
The Account Drill Down Report gives you detailed information on the asset transactions represented by a journal entry line. The report is sorted by account (from the lowest balancing segment value to the highest), journal entry batch name, journal entry category, journal entry line number, and asset number.
Assets
Account Reconciliation Reserve Ledger Report
Use this report to review how much depreciation Oracle Assets charged to a depreciation reserve account in an accounting period. The report is sorted by, and prints totals for each balancing segment, asset account, reserve account, and cost center. It is not necessary to close the period before running the report. You can run this report for the current open period, as long as you have run depreciation before running the report.
Assets
Additions By Source Report
This report shows all assets added during an accounting period range and the invoice lines associated with that asset. The report groups the assets by source: Mass Additions or Manual Transactions
Assets
Annual Additions Report
This report shows all assets placed in service in the date range you specify. The report is sorted by balancing segment, asset account, and asset number, and prints totals for each asset account and balancing segment. You must enter the Book and From/To Date range when you request this report.
Assets
Asset Additions By Cost Center Report
Use this report to review the assets you added to Oracle Assets or capitalized duringany depreciation period. The report is sorted by, and prints totals for each balancingsegment, asset type, cost center, asset account, and expense account.
Assets
Asset Additions Report
Use this report to reconcile asset cost to your general ledger asset accounts. The report lists all the assets you added to Oracle Assets or capitalized during the specified accounting periods. The report is sorted by, and prints totals for each balancing segment, asset type, asset account, cost center, and reserve account.
Assets
Asset Additions Responsibility Report
This report shows assets that you added to your cost centers through
additions, capitalizations, and transfers in the accounting period you specify. The report shows the owner and location of each unit. The report is sorted by balancing segment, cost center, owner, location, and asset number. It prints totals for each cost center and balancing segment.
Assets
Asset Category Listing
Use this listing to review all your asset categories. This report prints the following
default information for each category:
• Asset, reserve, and expense accounts
• Depreciation method and life (or adjusted rate plus the bonus rate for flat-rate
methods)
• Prorate convention
• Price index name, if any
You must enter a Book when you request this report.
Assets
Asset Description Listing
Use this listing to review the descriptions assigned to your assets. This helps you standardize your asset descriptions by helping you ensure that similar assets have similar descriptions.
Assets
Asset Disposals Responsibility Report
This report shows assets that you removed from your cost centers through retirements and transfers. It also shows the location of each unit. The report is sorted by, and prints totals for each balancing segment, cost center, and owner. You must enter a Book and Period when you request this report.
Assets
Asset Inventory Report
Use this report to ensure an accurate asset inventory. You can send it to each of your managers periodically to show them the assets under their control. Your managers can use the report as a turnaround document to inform your fixed asset manager of additions, transfers, retirements, and other changes. You can have your managers sign the report to provide you and your auditors with confirmation that your asset
inventory is accurate.
Assets
Asset Maintenance Report
Use this listing to view assets’ maintenance schedules, warranty information, and cost and supplier information.
Assets
Asset Reclassification Reconciliation Report
Use this report to reconcile Oracle Assets to your general ledger asset accounts. The report is sorted by, and prints totals for each balancing segment, asset type, asset account, and cost center.
Assets
Asset Reclassification Report
Use this report to reconcile Oracle Assets to your general ledger asset accounts. The report is sorted by, and prints totals for each balancing segment, asset type, asset account, and cost center.
Assets
Asset Register Report
Use this report to get a snapshot of any asset. The report shows a line with asset information for the corporate book you specify and for each associated tax book. It provides information that is current as of the day you request the report. It does not provide historical information. The report is sorted by asset number.
Assets
Asset Retirements By Cost Center Report
This report shows the asset retirements for each of your cost centers for the Book and during the Period you select. Optionally enter a Cost Center range to limit report output. The report is sorted by balancing segment, cost center, employee name, location, asset account, and asset number. It prints totals for each owner, cost center, and balancing segment.
Assets
Asset Retirements Report
Use this report to review the assets you retired for the Book and accounting Period range you choose. The report is sorted by balancing segment, asset type, asset account, cost center, and asset number. It prints totals for each cost center, account, asset type, and balancing segment.
Assets
Asset Tag Listing
Use this listing to review the tag numbers assigned to your assets.
Assets
Asset Transfer Reconciliation Report
Run this report to view the transfer transactions for a corporate book. This report shows the transfers you made during an accounting period that affect a general ledger account. It shows the transfers for the Book and From/To Period range you choose. Transfers between employees and transfers between locations do not appear on this report since the general ledger number does not change. Oracle Assets sorts this
report by balancing segment, asset type, asset account, and cost center. It prints the total cost for each cost center, asset account, asset type, and balancing segment.
Assets
Asset Transfers Report
Use this report to review asset transfers for the Book and Period you choose. For each transaction Oracle Assets lists the expense account, balancing segment, cost center, and location of the asset before and after the transfer. Oracle Assets sorts the report by
asset number.
Assets
Assets By Category Report
Use the Assets by Category Report to find and review all the assets in an asset category. The assets are sorted by balancing segment and category in this report. The report prints the total cost for each category and balancing segment.
Assets
Assets Not Assigned To Any Books Listing
Use the Assets Not Assigned To Any Books Listing to find assets that you have not assigned to any depreciation books. The listing is sorted by asset number.
Assets
Assets Not Assigned To Any Cost Centers Listing
Use the Assets Not Assigned To Any Cost Centers Listing to find assets that you did not assign to any cost centers. The listing is sorted by book and asset number.
Assets
Bonus Depreciation Rule Listing
Use this listing to review the bonus rules you have set up. Bonus rules specify additional depreciation to take in the early years of an asset’s life.
Assets
Budget Report
Use the budget reports to review your capital budgets.
Assets
Budget-to-Actual Report
This report shows the difference between your budgeted purchases and actual asset purchases. It also separately lists categories to which you have added assets during the period, but for which you have not allocated a budget amount.
Assets
CIP Assets Report
This report shows all the invoice line items and manually entered source line items for your CIP assets. Use this report to review your CIP assets at the end of each accounting period.
Assets
CIP Capitalization Report
This report shows the CIP assets that you capitalized during a range of accounting periods. The report is sorted by balancing segment, CIP cost account, cost center, and asset cost account. It prints totals for asset cost account, cost center, CIP cost account, and balancing segment.
Assets
Calendar Listing
Use this listing to review your calendar periods by fiscal year. You must enter a Fiscal Year Name and Fiscal Year when you request this report.
Assets
Cost Adjustments Report
This report provides an audit trail of the cost adjustments that you made to your assets in the Book and during the accounting Period range you choose. It includes changes you made to the asset itself and changes you made to source lines. Oracle Assets sorts this report by balancing segment, asset type, asset cost account, cost center, and asset number. It prints totals for each cost center, account, asset type, and balancing segment. This report can include member asset amounts.
Assets
Cost Adjustments by Source Report
This report shows all the cost adjustments you made in the Book and during an accounting Period range you choose. It groups them by asset type and source: Mass Additions or Manual Transactions.

The report is sorted by source, balancing segment, asset type, asset account, cost center, and asset number. For assets with multiple source lines, the report sorts by supplier number, invoice number, and invoice line number. The report prints totals for each asset if the asset has multiple source lines, and for each cost center, asset account, asset type, balancing segment, and source.
Assets
Cost Clearing Reconciliation Report
This report shows all assets you created or adjusted during an accounting period for which Oracle Assets creates journal entries to asset clearing accounts. Use this report to reconcile your clearing accounts between your general ledger and Oracle Assets.
Assets
Cost Detail Report
Use this report to reconcile your standalone and member asset cost
accounts to your general ledger.
You must enter a Book and From/To Period range when you request these reports. This report can include member asset amounts.
Assets
Delete Mass Additions Preview Report
Use this report to review mass additions with a status of DELETE only and verify that you will delete the correct mass additions before you submit the Mass Additions Delete program. The report is sorted by, and prints the total cost for each book, source system, and supplier.
Assets
Depreciation Projection Report
Use this report to review projected depreciation expense for your assets for each book you request. The report is sorted by, and prints the total depreciation for each balancing segment, cost center, and expense account. You can request report detail at the Cost Center and/or Asset level.
Assets
Depreciation Rate Listing
Use this listing to review the rates for your life-based depreciation methods. This listing only includes depreciation methods which have 12 prorate periods. Notice that, for methods that use a calculation basis of Cost, the sum of each column must equal one. The listing is sorted by depreciation method and prints the total for each period.
Assets
Drill Down Report
The Drill Down Report lists all journal entry lines and gives detailed information on the asset transactions for a particular journal entry batch. It is sorted by journal entry batch name, journal entry category, account (from the lowest balancing segment value to the highest), journal entry line number, and asset number.
Assets
Expensed Property Report
Use this report to find all your expensed assets. When you added these assets to Oracle Assets, you classified the assets under non-capitalized asset categories. The report is sorted by balancing segment, asset category, and asset number. It prints the current total
cost for each category and balancing segment.
Assets
Financial Adjustments Report
Use this report to find all the adjustments you made to the financial information for your assets for the Book and Period you choose. The report is sorted by asset number and by when the transaction was effective.
Assets
Fully Reserved Assets Report
Use this report to find the assets that became fully depreciated in a range of accounting periods. The report is sorted by period, balancing segment, asset account, and asset number. It prints totals for each asset account, balancing segment, and period.
Assets
Hypothetical What If report
Use the Hypothetical What-if Report to display and analyze the results of hypothetical what-if depreciation analysis. This report contains depreciation projection data based on depreciation parameters for hypothetical assets.
Assets
Journal Entry Reserve Ledger Report
Use this report to find out how much depreciation expense Oracle Assets charged to a depreciation expense account for any accounting period. The report lists all active (not yet retired) capitalized assets, as well as any assets that you have retired in the period’s fiscal year. The report is sorted by balancing segment, expense and reserve accounts, and cost center. It prints totals for each cost center, account, and balancing segment.
Assets
Leased Assets Report
Use this report to find all your leased assets. This report is sorted by balancing segment, asset category, and lease number. It prints totals for each category and balancing segment.
Assets
Mass Additions Create Report
Use this report to review mass additions created from invoice distribution lines in Oracle Payables for the Book you choose. The report provides you with a complete audit trail of the mass additions created by Oracle Payables. Oracle Assets sorts the report by, and prints the total cost in both the functional and foreign currency for each
currency, company, asset account, and cost center.
Assets
Mass Additions Delete Report
This report provides an audit trail of the deleted mass additions.
Assets
Mass Additions Invoice Merge Report
Use the Mass Additions Invoice Merge Report to review mass additions that you merged into a single asset.
Assets
Mass Additions Invoice Split Report
Use the Mass Additions Invoice Split Report to review mass additions that you created by splitting multi-unit mass additions.
Assets
Mass Additions Posting Report
For the Book you choose, this report gives you an audit trail of the assets that Oracle Assets created from your mass additions. The report sorts by transaction type and asset number.

The report divides your mass additions by transaction type: Additions are mass additions that became assets; Adjustments are mass additions that you added to existing assets. Oracle Assets prints the total cost for each transaction type. It also prints the total number of mass addition lines posted in the batch.
Assets
Mass Additions Purge Report
This report provides a list of the purged mass additions. The report is sorted by mass addition number.
Assets
Mass Additions Status Report
Use this report to review your mass additions by status (queue name). This report is sorted by asset account, accounts payable batch name, and invoice number. It prints the total cost for each asset account.
Assets
Mass Change Preview Report
This Mass Change Preview Report shows you the effect the mass change criteria you specified will have on your assets. You must run this report to preview a mass change before you perform it.
Assets
Mass Change Review Report
If you modify the Mass Change definition, you must rerun the
preview report. Use the Mass Change Review Report to review the effect of mass changes on your assets after Oracle Assets performs them.
Assets
Mass Depreciation Adjustment Preview Report
The Mass Depreciation Adjustment Preview Report shows you the effect the adjustment you specified will have on the year-to-date depreciation for assets in your adjusted tax book. You must submit this report to preview the effect of a mass depreciation adjustment before you can perform it. If you modify the adjustment definition, you must rerun the preview report before you perform the mass depreciation adjustment.
Assets
Mass Depreciation Adjustment Review Report
Submit the Mass Depreciation Adjustment Review Report to review the
effect of a mass depreciation adjustment after you run it.
Assets
Mass Reclassification Preview Report
The Mass Reclassification Preview Report shows you the effect the mass reclassification criteria you specified will have on your assets. You must run this report to preview a mass reclassification before you perform it. If you modify the Mass Reclassification definition, you must rerun the preview report.
Assets
Mass Reclassification Review Report
Use the Mass Reclassification Review Report to review the effect of mass reclassifications on your assets after Oracle Assets performs them. Both reports are sorted by asset number.
Assets
Mass Retirements Exception Report
Use the Mass Retirements Exception Report to identify exception assets that were not retired as part of the mass retirement transaction. Oracle Assets does not retire assets added in the current period or assets that have transactions dated after the retirement date you enter. Oracle Assets also does not retire assets that are assigned to multiple
general ledger numbers, locations, or employees, where one or more of the values do not meet the selection criteria you entered for the mass retirement transaction. This report prints each exception asset, including its multiple distributions.
Assets
Mass Retirements Report
Use the Mass Retirements Report to review the effect of a mass retirement before you process it. If necessary, you can delete or make adjustments to an individual retirement transaction in the Retirements window before you calculate gains and losses. You can
also reinstate the mass retirement transaction in the Mass Retirements window. This report sorts by balancing segment, asset type, and asset account.
Assets
Mass Transfers Preview Report
Use this report to preview the effect of your mass transfer definition before you perform it. It shows you the general ledger number, location, and employee your assets are assigned to before and after the Mass Transfer. This report is sorted by asset number, general ledger number, location, and employee number.
Assets
Parent Asset Report
Use the Parent Asset Report to review the parent-subcomponent relationships among your assets. You associate a parent with a subcomponent in the Asset Details window by entering a parent asset number for the subcomponent asset. Oracle Assets sorts the report by parent asset number.
Assets
Parent Asset Transactions Report
Use this report to review transactions on parent assets for the Book and Period you choose. The report is sorted by transaction type and transaction number.
Assets
Prorate Convention Listing Report
Use this listing to review the prorate and retirement conventions you have set up. You must enter the Fiscal Year Name and Fiscal Year when you request this report.
Assets
Reserve Adjustments Report
This report provides an audit trail of the adjustments you make to depreciation reserve. The report is sorted by, and prints the total reserve adjustment for each balancing segment, fiscal year, and reserve account.
Assets
Reserve Detail Report
Use the Reserve Detail and Summary reports to reconcile your reserve accounts to your
general ledger. The detail report is sorted by balancing segment, depreciation reserve
account, cost center, and asset number. It prints totals for cost center, account, and
balancing segment. The summary report is sorted by, and prints totals for each balancing
segment and depreciation reserve account.
Assets
Reserve Summary Report
Assets
Responsibility Reserve Ledger Report
Use this report to find out how much depreciation expense Oracle Assets charged to a cost center in any depreciation period. The report is sorted by balancing segment, cost center, asset account, and asset number. It prints totals for each asset account, cost center, and balancing segment.
Assets
Tax Additions Report
This report shows your asset additions and capitalizations for the period range you select. The report is sorted by balancing segment, fiscal year added, asset account, and asset number. It prints totals for asset account, fiscal year, and balancing segment.
Assets
Tax Preference Report
Use this report to compare the year-to-date depreciation between your federal and corporate books for a range of asset accounts. The report shows the difference in year-to-date depreciation between the tax book you specify and its associated corporate book through the period you select. If the corporate book year-to-date depreciation is greater than that of the tax book, the report prints zero in the Difference column.
Assets
Tax Reserve Ledger Report
This report shows how much depreciation expense Oracle Assets calculated for the period you select. The report is sorted by balancing segment, fiscal year placed in service, asset account, and asset number. The report prints totals for asset account, year, and balancing segment.
Assets
Tax Retirements Report
This report shows gain or loss and any ITC recapture for your asset retirements. The report is sorted by balancing segment, fiscal year placed in service, asset account, and asset number. The report prints totals for each year and balancing segment.
Assets
Transaction History Report
Use this report to review all the transactions that you performed on your assets for the Book and Asset Number range you choose. To get additional detail about any of the transactions, use the appropriate transaction reports. The report is sorted by asset number
Assets
Unplanned Depreciation
Use the Unplanned Depreciation report to print details of the unplanned depreciation you enter in the Unplanned Depreciation Entry window. This report lists all unplanned depreciation entries for a specific depreciation book, unplanned depreciation type, and depreciation period.
Assets
Unposted Mass Additions Report
Use this report to review mass additions that you have not yet posted. An unposted mass addition appears under the date that the invoice distribution line was posted to the general ledger. Oracle Assets sorts this report by period, asset account, and status. It prints the total cost for each asset account and period.
Assets
What-If Depreciation Report
Use the What-if Depreciation Report to display and analyze the results of what-if depreciation analysis. This report contains depreciation data based on depreciation parameters you entered for analysis purposes. The report also lists depreciation projections for your current depreciation parameters so that you can use the report to compare your current depreciation projections with the what-if depreciation projections.
Cash Management
Archive/Purge Bank Statements
Use this report to view a list of bank statements that were archived or purged from Cash Management. This report lists only the number of headers and lines archived or purged from the bank statement interface table and does not list reconciliations or errors, since they are not applicable to interface tables.
Cash Management
AutoReconciliation Execution Report
This report shows import and reconciliation errors that occurred when running the AutoReconciliation program. Cash Management automatically produces this report during the automatic reconciliation process. You may also request it as needed from the Submit Request window.
Cash Management
Bank Purging Execution Report
This report displays the Oracle Payables and Oracle Payroll banks, bank branches, internal bank accounts and employee bank accounts that are processed by the Bank Purging program. Cash Management automatically submits the Bank Purging Execution report when the Bank Purging program is run.
Cash Management
Bank Statement Detail Report
This report shows statement and transaction information for a specific bank account statement, including bank statement header information, statement line detail, and reconciled transaction detail. This report lists any unreconciled transactions separately with their current status, and the statement totals for each type of transaction, including the amount entered, reconciled, unreconciled and over-reconciled.
Cash Management
Bank Statement Loader Execution Report
This report shows errors and warnings that occur when the Bank Statement Loader program transfers data from the intermediate table to the Bank Statement Open Interface tables. Cash Management automatically produces this report when you run the Bank Statement Loader program.
Cash Management
Bank Statement Summary Report
This report shows summary bank statement information for a bank account.
Cash Management
Bank Statements by Document Number Report
This report lists bank statements in document number order, to help you identify missing and deleted statements.
Cash Management
Bank Transaction Codes Listing
Use this listing to review the transaction codes that you defined for a specific bank
account.
Cash Management
Batches Available for Reconciliation
This report shows any batches available for reconciliation for a specific bank account. It lists detailed transaction information for your Payment and Remittance Batches that are available for reconciliation. Detailed information includes the Batch Name, Remit/Payment Date, Deposit Number/Reference, Currency, and Amount.
Cash Management
Cash Forecast Execution Report
This report includes information on any errors that the Submit Forecast program produced when you submitted a cash forecast to be generated.
Cash Management
Cash Forecast Report
The Cash Forecast Report lets you view the cash forecast data that you can see in the Cash Forecast Results page online.
Cash Management
Cash In Transit Report
This report lists, for a specific bank account, all transactions that have been remitted to the bank but have not been cleared. This report excludes all voided transactions. The report also excludes all reversed transactions which have a reversal date on or prior to the As of Date.
Cash Management
Cleared Transactions Report
This report shows transactions that were cleared or reconciled both manually and automatically.

The cleared receipts section shows the customer name, remittance date, maturity date, payment method, receipt number, currency, amount, account amount, cleared date, and cleared amount.

The cleared payments section shows the supplier name, payment date, payroll payments, maturity date, payment method, payment number, currency, amount, account amount, cleared date, and cleared amount
Cash Management
General Ledger Reconciliation Report
Use this report to reconcile the General Ledger cash account balance to the bank statement closing balance and to identify any discrepancies in your cash position. The General Ledger cash account should pertain to only one bank account. This report is available in Summary and in Detail format.
Cash Management
Purge Cash Forecasts
The Purge Cash Forecast Report lets you view which forecasts have been purged. Cash Management automatically generates this report when you submit the Purge Cash Forecasts program using the Submit Request window.
Cash Management
Transactions Available for Reconciliation Report
This report shows all transactions available for reconciliation for a specific bank account. It lists detailed transaction information for your Available Receipts, Available Payments, and Available Journal Entries for reconciliation. Detailed information includes the Customer, Supplier, Transaction Date, Payment Method, Transaction Number, Currency, and Amount. It also lists detailed information for statement lines that are available for reconciliation against other statement lines.
General Ledger
Account Analysis - (132 Char)
Provides COA Segment wise(Account/Cost Centre etc.) balances based on parameters provided and supports 132 Characters
General Ledger
Account Analysis - (180 Char)
Provides COA Segment wise(Account/Cost Centre etc.) balances based on parameters provided and supports 180 Characters
General Ledger
Account Analysis - Payables Detail(132 Char)
The report prints the beginning balance, journal entry lines, and ending balance of the accounts you request. For each journal entry line, the report prints the batch name, journal entry name, account, line description, vendor name, invoice number, and the debit or credit amount and limits the output to 132 characters.
General Ledger
Account Analysis - Payables Detail(180 Char)
The report prints the beginning balance, journal entry lines, and ending balance of the accounts you request. For each journal entry line, the report prints the batch name, journal entry name, account, line description, vendor name, invoice number, and the debit or credit amount and limits the output to 180 characters.
General Ledger
Account Analysis - Subledger Detail (132 char)
This report prints the journal entry lines and beginning and ending balances of the accounts you request. For each journal entry line, the report prints the accounting date, category, journal batch name, header, sequence, number, line, description, and amount. For each journal entry line, the report also prints subledger details, including the vendor or customer name, transaction number, associated transaction, sequence, number, line, and transaction type and limitis the output to 132 characters.
General Ledger
Account Analysis - Subledger Detail (180 char)
This report prints the journal entry lines and beginning and ending balances of the accounts you request. For each journal entry line, the report prints the accounting date, category, journal batch name, header, sequence, number, line, description, and amount. For each journal entry line, the report also prints subledger details, including the vendor or customer name, transaction number, associated transaction, sequence, number, line, and transaction type and limitis the output to 180 characters.
General Ledger
Budget - Frozen Budgets Accounts Listing
Review frozen budget components, including budgets, budget organizations, and account ranges. This listing prints only budgets which are partially or completely frozen.
General Ledger
Budget - Funds Available Analysis
Use the Funds Available Analysis Report to measure budgets against expenditures and encumbrances to determine the balance of funds available for your future expenditures.

Funds Available Analysis calculates the difference between the amount you are authorized to spend and the amount of your expenditures plus commitments depending upon account type.
This report includes only the effect of approved budgetary control transaction. The report does not include the effect of pending transactions that have not yet reserved funds.

For example, if you attempt to reserve funds for a purchase order online and you run a Funds Available Analysis Report, the effect of your purchase order will not be included in available funds unless two criteria are met. First, your online process must be completed successfully, and second, the system must have successfully reserved funds for your purchase order.
General Ledger
Budget - Hierarchy Listing
Review all master budgets and their associated detail budgets for your current set of books.
General Ledger
Budget - Journals by Flexfield
This report prints the status, period, batch name, journal entry name, journal entry line number, description, entered debit or credit amount, and statistical amount for each account you request.
General Ledger
Budget - Master/Detail
Review the available funds for all detail budgets controlled by a specific master budget. View budget balances entered in your functional currency, a foreign currency or statistical amounts. General Ledger marks accounts whose detail budget amounts exceed the master budget with an asterisk.
General Ledger
Budget - Organization Listing
This listing prints the start and end dates for the organization, the accounts you assigned to the organization, descriptions of these accounts as well as their budget entry methods.

If budgetary control is enabled for your set of books, this report also prints the budgetary control options assigned to each account range, including funds check level, amount type and boundary.
General Ledger
Budget - Organization Range Listing
Review the details of the account ranges assigned to a specific budget organization. The listing prints the budget entry type and currency assigned to each account range, and indicates whether automatic encumbrancing is enabled.

If budgetary control is enabled for your set of books, this report also prints the budgetary control options assigned to each account range, including funds check level, amount type and boundary.
General Ledger
Budget - Summary/Detail
Review the detail accounts that roll up into a summary account for a specific budget and currency. This report shows the balance and journal information for each detail account for the period you specify.
General Ledger
Budget - Unbudgeted Master/Detail Accounts
Review the detail budget amounts for which there are no corresponding budgeted amounts in the master budget. Review transactions entered in your functional currency, a foreign currency or statistical amounts.
General Ledger
Budgetary Control Transactions
Review the details of your funds check or reservation requests. You must be using budgetary control for your current set of books to request this report.

You can request this report from the Budgetary Control Transactions window. Choose the Print All button to generate a report showing the details of all transactions included in your funds check or reservation request. Choose the Print Errors and Warnings button to generate a report showing the details of only those transactions that contain
failures and/or warning messages.
General Ledger
Chart of Accounts - Account Hierarchy
Review a list of the detail accounts that roll up into each summary account for all summary templates. General Ledger creates a new page for each summary template you have defined and displays the description of each account segment value for both your summary and detail accounts.
General Ledger
Chart of Accounts - Detail Listing
Review the chart of accounts for your current set of books, including detail and summary accounts.
General Ledger
Chart of Accounts - Inactive Accounts Listing
Review a list of disabled and expired accounts. You can specify a date of interest and an account range. Use this report to determine why particular accounts are no longer active.
General Ledger
Chart of Accounts - Rollup Detail Listing
Review all valid child segment values for each parent segment value for a specific account segment. This listing includes descriptions for both the parent and child segment values and the rollup group (if any) to which your parent segment value belongs.

General Ledger sorts this listing in ascending order by account parent segment value. Within each parent segment value, General Ledger sorts the child segment values in ascending order.
General Ledger
Chart of Accounts - Rollup Range Listing
Review a list of all parent segment values for an account segment. This listing includes information about each parent segment value, such as the rollup group to which each parent segment value belongs, whether each parent segment value is enabled and its range of child segment values.

General Ledger sorts this listing in ascending order by parent segment value.
General Ledger
Chart of Accounts - Segment Values Listing
Review all segment values for a specific account segment. This listing includes information about each segment value, such as whether your segment value is enabled, whether it is a parent, and whether posting and budgeting are allowed.

Run this listing for your account segment to verify that your accounts have been assigned the correct account type. General Ledger sorts this listing in ascending order by segment value.
General Ledger
Chart of Accounts - Suspense Accounts Listing
Review the suspense accounts for your set of books. This listing provides the suspense account for each journal entry source and category.
General Ledger
General Ledger - (132 Char)
Review journal information to trace each transaction back to its original source.

General Ledger prints a separate page for each balancing segment value. For each journal line, the report prints the account affected, the concatenated description, the journal line amount, and the beginning and ending account balance. Additionally, for each journal line, the report prints journal details including source, category, journal name, and effective date. The report lists accounts in ascending order by account segment value, and it prints a "CR" next to credit amounts.

The report limits the output displayed to 132 characters.
General Ledger
General Ledger - (180 Char)
Review journal information to trace each transaction back to its original source.

General Ledger prints a separate page for each balancing segment value. For each journal line, the report prints the account affected, the concatenated description, the journal line amount, and the beginning and ending account balance. Additionally, for each journal line, the report prints journal details including source, category, journal name, and effective date. The report lists accounts in ascending order by account segment value, and it prints a "CR" next to credit amounts.

The report limits the output displayed to 180 characters.
General Ledger
Journals - Batch Summary
Review your posted journal batches for a particular balancing segment, currency and
date range.

The report provides information on Actual balances for your journal batches, source, batch and posting dates, total entered debits and credits and sorts the information by journal batch within each journal entry category. In addition, totals are provided for each journal category and a grand total for each balancing segment included in your report. This report does not report on budget or encumbrance balances.
General Ledger
Journals - Document Number
Review detailed information for each journal associated with a specific document
sequence.

General Ledger prints the journals in ascending order by document number. For each journal, the report prints the creation date, batch name, journal name, category, posting status, posted date, currency, and journal amounts. The report also indicates which document numbers do not have an associated journal.
General Ledger
Journals - Entry
Review journal activity for a given period or range of periods, balancing segment value, currency, and range of account segment values.

The report prints the accounting date, category, journal name, reference, journal batch name, entered debit or credit amounts, net balance, and account total for each journal. In addition, a total is provided for each balancing segment included in your report and a
grand total is provided for all the activity included in your report.
General Ledger
Journals - General(132 Char)
The General Journals Report is available in three different formats. You can request a report of Posted Journals, Unposted Journals or Error Journals. Each are described below.

The output of this report is restricted to 132 characters.
General Ledger
Journals - General(180 Char)
The General Journals Report is available in three different formats. You can request a report of Posted Journals, Unposted Journals or Error Journals. Each are described below.

The output of this report is restricted to 180 characters.
General Ledger
Journals - Line
Review all of your journals, grouped by batch, for a particular journal category, currency and balancing segment value.

For each journal line, the report prints the transaction date, account, reference, journal line description, entered amounts, and accounted amounts. Totals are provided for each journal and journal batch included in your report. In addition, totals are provided for each journal category and for each balancing segment, with a grand total for all of the
activity included in your report.
General Ledger
Trial Balance - Budget
Review your general ledger budget account balances and activity for a specific currency. You can run this report for balances and activity entered in your functional currency, a foreign currency or STAT, or translated to a foreign currency.

General Ledger prints a page for each balancing segment value and lists your accounts in ascending order by account segment value. General Ledger reports debits as positive amounts and credits as negative amounts.
General Ledger
Trial Balance - Detail
Review your general ledger actual account balances and activity in detail. You can run this report for balances and activity entered in your functional currency or STAT, or translated to a foreign currency.

The report prints a line for each of your accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity, and ending balance for the period you specify. General Ledger reports debits as positive amounts and credits as negative amounts.
General Ledger
Trial Balance - Summary 1
Review general ledger actual account balances and activity summarized by account segment value. You can run this report for balances and activity entered in your functional currency or STAT, or translated to a foreign currency.

The report prints a line for each account segment value and lists them in ascending order. For each account segment value, the report prints the value, description, beginning balance, net of all debit or credit transactions, and ending balance for the period you request.
When run in YTD mode, the Begin Balance column lists begin balances for accounts in the first period of the fiscal year irrespective of the period for which the report is run. When run in PTD mode, the Begin Balance column lists begin balances for accounts in the target period for which the report is run.
General Ledger
Trial Balance - Summary 2
Review general ledger account balances and activity for combinations of account segment values with the values of a secondary segment you specify. You also specify a range of values for a third segment, which are used to control report page breaks.

General Ledger prints a line for each combination and sorts the secondary segment values from the lowest to the highest. For each secondary segment value, General Ledger sorts the account segment values from the lowest to the highest. Totals are provided for both your secondary segment and your pagebreak segment.
You can run this report for actual, budget and encumbrance balances and activity in your functional currency, a foreign currency, or statistical units. When run in YTD mode, the Begin Balance column lists begin balances for accounts in the first period of the fiscal year irrespective of the period for which the report is run. When run in PTD mode, the Begin Balance column lists begin balances for accounts in the target period for which the report is run.
Payables
Accounts Payable Trial Balance
Use the Accounts Payable Trial Balance Report to verify that total
accounts payable liabilities in Payables equal those in the general
ledger. To reconcile these balances you can compare the cumulative
total liability provided by this report with the total liability provided by
your general ledger.
Payables
Bank Account Listing
Use this report to review information for each internal bank account
you use. Payables provides detail information about each bank, bank
branch, bank account, and payment document that you have defined.
Payables
Distribution Set Listing
Use the Distribution Set Listing to review a complete list of all the
Distribution Sets you have defined. Distribution Sets simplify and
speed invoice entry by automatically generating invoice distributions
for invoices which have assigned Distribution Sets.
Payables
Employee Listing
Use this report to create a list of employees that meet criteria you
specify.
Payables
Final Payment Register
Use the Final Payment Register to list each payment that was included
in a payment batch. The report lists each payment in a payment batch,
including setup, overflow, and subsequently voided payment
documents, in ascending order by payment number.
Payables
Invoice Aging Report
Use this report to view your unpaid invoices. This report provides
information about invoice payments due within four time periods you
specify in the Aging Periods window.
Payables
Invoice Approval Status
Use the Invoice Approval Status Report to monitor invoices that are in
the Invoice Approval Workflow process as of the date and time the
report is run. The report also shows invoices that have completed the
process because they were approved or rejected.
Payables
Invoice Audit Listing
Use the Invoice Audit Listing to audit invoices for duplicates. You
should audit invoices periodically to ensure control of invoice
payments.
Payables
Invoice Audit Report
Use the Invoice Audit Report to audit invoices for duplicates.
Payables
Invoice Audit by Voucher Number
Use this report to review your invoices with assigned sequential
voucher numbers. Either you or Payables can assign a unique,
sequential number to an invoice during invoice entry, if you enable the
Sequential Numbering profile option.
Payables
Invoice History Report
The Invoice History Report provides information to support the
balance due on an invoice. It helps you quickly identify and review a
detailed list of all payment activities pertaining to a specific invoice
such as gains, losses, and discounts.
All amounts on this report are shown in the payment currency.
Payables
Invoice Register
Use the Invoice Register to review detailed information about invoices
Payables
Invoice Validation
Use the Invoice Validation Report to review the total number of
matching and variance holds that Payables applies and releases after
you submit Invoice Validation. If you use budgetary control, Payables
also lists any funds control holds.
Payables
Invoice on Hold Report
Use the Invoice on Hold Report to identify invoices on hold. The
report provides you the total number and amount (in your functional
currency) of invoices on hold, which can be helpful for your accounts
payable metrics. Run the Invoice Validation process before submitting
this report to obtain the most up–to–date hold information.
Payables
Payables Account Analysis Report
Use this report to review and analyze accounting entries in Payables.
You can use the report parameters to limit the report to just the
accounting information you want to review.
Payables
Payables Accounting Process
This program emables accouting of all the transactions in Payables and subaequent Transfer and Import of journals into the General Ledger
Payables
Payables Transfer to General Ledger
This program enables transfer and Import of journals created for the Payables transactions into the General Ledger
Payables
Payment Audit by Voucher Number
Use the Payment Audit by Voucher Number Report to review
payments with assigned sequential voucher numbers. If you enable the
Sequential Numbering profile option, either you or Payables can assign
a unique, sequential number to each payment you create. You can also
use this report to review assigned and available voucher numbers for
the sequence name you specify, as well as sequential numbers that have
been deleted.
Payables
Payment Exceptions Report
Use this report to review exception payments in Payables. This report
provides you with a state–of–the–system listing of the exception
payments in Payables at any time.
Payables
Payment Register
The report lists each payment that has a payment date within the range
you specify, as well as the total payment amount and cleared amount of all payments. It sorts and subtotals by bank, bank branch, and bank
account. The report also displays the payment document and
disbursement type for each set of payments, and provides a subtotal
for each payment document. Voided checks will not be subtracted
from the report totals. If you want to review actual cash disbursed,
then you can run this report along with the Void Payment Register.
Payables
Payment Terms Listing
Use the Payment Terms Listing to review a complete list of the
payment terms you have defined in the Payment Terms window.
Payables
Period Close Exceptions Report
This report lists out all the payables transactions that are not transferred to the General Ledger due to which the period cannot be closed.
Payables
Preliminary Payment Register
Use the Preliminary Payment Register to review the payments Payables will create when you format payments for the invoices in a payment batch.
Payables
Recurring Invoices Report
Use this report to review recurring invoice templates you defined
during a specific time period. You can review this report to determine
the amount you have authorized for a recurring invoice template, how
much you have released, and the next amount you have scheduled.
The report also lists the number of periods remaining for a recurring
invoice and the next period you have scheduled.
Payables
Supplier Merge Program
This programs helps in merging duplicate suppliers and transferring outstanding invoices and PO's from a source supplier (duplicate) to the target supplier (actual).
Payables
Supplier Paid Invoice History
The report lists supplier payments alphabetically by supplier and site.
Payables separates invoice amounts paid in foreign currencies from
invoice amounts paid in your functional currency by printing a subtotal
of the paid invoices by currency.
Payables
Supplier Payment History
This report provides totals for the payments made to each supplier site,
each supplier, and all suppliers included in the report. If you choose to
include the invoice details, Payables displays the paid invoice’s invoice
number, date, invoice amount, and amount paid by the payment. This
report also displays the void payments for a supplier site, but does not
include the amount of the void payment in the payment total for that
supplier site.
Payables
Suppliers Report
Use the Suppliers Report to review detailed information about your
supplier records. You can use this report to verify the accuracy of your
current supplier information and to help manage your master listing of
supplier records. Payables provides detailed information for each
supplier, and optionally, supplier site, including the user who created
the supplier/site, creation date, pay group, payment terms, bank
information, and other supplier or site information.
Payables
Tax Names Listing
Use the Tax Codes Listing to review rate and account information for
tax codes you defined in the Tax Codes window.
Payables
Tax Recovery Rules Listing
Use the Tax Recovery Rules Listing to review all the tax recovery rules
and rates that you defined in the Tax Recovery Rules window. The
reports lists all of the rates for each tax rule.
Payables
Unaccounted Transactions Report
Use this report to identify and review all unaccounted invoice and
payment transactions and see the reason that Payables cannot account for a transaction.
Payables
Withholding Tax by Invoice Report
Use the Withholding Tax By Invoice Report to review detailed invoice
withholding tax information for a supplier, including invoice number,
amount subject to withholding, and tax amounts withheld. Submit this
report if your Apply Withholding Tax Payables option is At Invoice
Validation Time. This report lists withholding tax information only for
invoices that have amounts withheld.
Payables
Withholding Tax by Payment Report
Use the Withholding Tax By Payment Report to review detailed invoice
withholding tax information for a supplier, including invoice number,
amount subject to withholding, and tax amounts withheld. Submit this
report if your Apply Withholding Tax Payables option is At Payment
Time. This report lists withholding tax information only for invoices
that have amounts withheld.
Payables
Withholding Tax by Supplier Report
Use the Withholding Tax By Supplier Report to review detailed invoice
withholding tax information for a supplier, including invoice number,
amount subject to withholding, and tax amounts withheld. Submit this
report for a range of supplier names or supplier numbers.
Payables
Withholding Tax by Tax Authority Report
Use the Withholding Tax By Tax Authority Report to review detailed
withholding tax information for Withholding Tax type tax codes
assigned to a Tax Authority type supplier. This report only lists
withholding tax information for Withholding Tax type tax codes that
have amounts withheld.

2 comments:

simha.mailbox@gmail.com said...

Good Doc

Raju Chinthapatla said...

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 (https://t.me/apps88) in telegram.

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect