AP: Predefined Reports in oracle Fusion Cloud Payables

 

Predefined Reports in oracle Fusion Cloud Payables
Invoices Reports
SNO	Report	Description
1	Payables Invoice Aging Report	Lists unpaid Invoices according to the specified aging periods
2	Payables Invoice Register	Provides detailed information about invoices
3	Payables Key Indicators Report	Generates reports with transaction activity and the current number of suppliers, invoices, payments, and matching holds
4	Payables Matched and Modified Receipts Report	Identifies receipts that were modified after invoice matching
5	Payables Matching Detail Report	Provides Details of how an invoice is matched to Purchase Order (PO) or receipt
6	Payables Matching Hold Detailed Report	Provides detailed Payables and purchasing information for invoices with matching holds and matching hold releases
7	Import Payables Invoices	Creates Oracle Payables Invoices from invoice data in the open interface tables
8	Validate Payables Invoices	Report for the process that checks the matching, tax, period status, conversion rate and distribution information for invoices. The validation process also checks the tolerance templates to determine if the invoice fall within the defined tolerances and automatically applies hold for expections
9	Supplier balance aging report	Report to generate a supplier aging balances based on a specified date, considering only accounted invoices in payables and transferred to GL.
Payment Reports
SNO	Report	Description
1	Payables Cash Requirement Report	Forecasts immediate cash needs for invoice payments
2	Payables Discounts Taken and Lost Report	Identifies Payments where discount was taken and payments where a discount was available, but not taken
3	Payables Payment Register	Provides detailed information about payables
4	Payables selected installments report	Lists all invoices installments selected in a payment process request to help determine how well the selection criteria is selecting the right invoices to pay
5	Payment Audit by Voucher number	Lists Payments with assigned sequential voucher numbers
6	Update Matured Bills Payable Status	Updates the status of matured bills payable from issued to negotiable
Period close Reports
SNO	Report	Description
1	Payables Open Items Revaluation Report	Lists Changes in the value of open items, such as unpaid invoices and credit memos, due to conversion rate fluctuations
2	Payables Period Close exceptions report	Lists Exceptions that prevent the oracle payables accounting period from closing
3	Payables Trial Balance Report	Lists and subtotals by supplier and liability account, all unpaid and partially paid invoices that oracle payables transferred to the general ledger
4	Payables unaccounted Transactions and sweep Report	Lists invoices and payments that were not accounted for a period or date range
5	Prepayment Remittance Notice	Lists prepayments that were applied to supplier invoices
Income Tax and Withholding Reports
SNO	Report	Description
1	US 1096 Report	Summarizes each United States 1099 form type that is transmitted on paper, as required by united states internal revenue service form
2	US 1099 Electronic Media Report	Generates Summarized united states 1099 information in electronic format as required by united states internal revenue service
3	US 1099 Forms - Comma Delimited Format	Reports the total United States 1099 Miscellaneous tax type payments for 1099 suppliers in a comma delimited format
4	US 1099 Invoice Exceptions Report	Lists unpaid invoice distributions with inaccurate or missing United States 1099 income tax information
5	US 1099 Payments Report	Lists Payments made to United States 1099 reportable suppliers
6	US 1099 Report	Reports the total United States 1099 miscellaneous payments for a particular 1099 supplier and generates 1099 forms for each tax reporting entity in an organization
7	US 1099 Suppliers Exceptions Report	Lists Suppliers with inaccurate or incomplete United States 1099 income tax information
8	Update and Report Income Tax Details	Report from the process that updates or reports income tax type or income tax region fields on invoice distributions that are used for United States 1099 reporting
9	Payables Withholding Tax letter	Creates a withholding tax letter to mail to a supplier on a periodic basis. The letter contains a list of withholdings made for a supplier summarized either by tax type and tax rate, or supplier site
OTBI Predefined Reports
SNO	Report	Description
1	Payables credit memo matching report	Lists Credit memos and debit memos for suppliers, along with invoices to which the credit memos and debit memos are matched
2	Payables invoice audit by voucher number listing	Lists invoices with assigned sequential voucher numbers
3	Payables invoice audit listing	Lists invoices for review and audit based on specific amount for a given supplier and range of invoice creation dates
4	Payables invoice register	Provides detailed information about invoices
5	Payables negative supplier balance report	Lists suppliers with negative balances, along with the invoices and credit or debit memo transactions for the balance
6	Payables discount taken and lost report	Identifies payments where a discount was taken and payments where discount was available, but not taken
7	Payables payment register	Provides detailed information about payments
8	Payables to Ledger Reconciliation Report	Lists the journals posted to the general ledger for open payables balances to facilitate the reconciliation of accounting and transactional data recorded in oracle payables and oracle subledger accounting
9	Payables posted invoice register	Lists accounting lines for invoices that have been transferred to general ledger
10	Payables posted payment register	Lists accounting lines for payments that have been transferred to general ledger
11	Payables withholding Tax by Tax authority report	Lists withholdings for tax codes assigned to a tax authority
12	Payables withholding tax report	Lists withholdings for a supplier. The invoice view is used to review detailed withholding tax information by invoice. The supplier view is used to review the withholding information for a range of suppliers
Payables OTBI Subject Areas
SNO	Subject Area	Description
1	Payables Invoices - Holds real time	Real-time information on holds applied to an invoice
2	Payables Invoices - Installments real time	Real-time information on invoice payment installments
3	Payables Invoices - Prepayment Applications Real time	Real time distribution information for prepayments applied to standard invoices
4	Payables Invoices - Transactional Real time	Real time information on Invoices
5	Payables Invoices - Trial Balance Real time	Real time information on posted invoices and payments for reconciling the payables balance with General Ledger balance
6	Payables Invoices - Withholding real time	Real time information on summarized tax amounts withheld at supplier site level
7	Payables payments - Disbursements real time	Real time information on installments including installments gross amount, amount paid, amount remaining, and discount
8	Payables payments - Payment History real time	Real- time information on clearing and unclearing history of payments
Payments Subject Areas
SNO	Subject Area	Description
1	Payables Payments - Disbursements Real time	Real-time information on amount spent or expensed
2	Payables Payments - Payment History Real time	Real-time information on clearing and unclearing history of payments
Subledger Accounting BI publisher Reports
The following benefits have been added to the account analysis and the journal entries report
·       Report extracts include reconciliation information for clearing accounts
·       BIP templates can be customized to list the clearing account reconciliation details
SNO	Report	Description
1	Account Analysis Report	Provides drill down information about the movement on a particular account for a period range of periods for posted journal entries
2	Accounting Event Analysis Report	Shows the transaction data used in accounting. The data is collected when the profile option SLA: Enable diagnostics is set and the create accounting process run
3	Journal Entries	Displays Detailed information for subledger and general ledger journal entries; groups report by ledger, journal source, journal category, and event class at submission
4	Subledger period close exceptions report	Lists all accounting events and journal entries that fail period close validation. Reasons for failure include incomplete transactions, unprocessed accounting events, invalid journal entries, and journal entries that have not been transferred. Groups report by ledger, period, journal source, journal category, and event class at submission
5	Third-party balances report	Displays subledger balance and account activity information for suppliers and customers
6	Subledger Accounting Method Setups report	Displays the accounting setups for a subledger application and accounting method
7	Create Accounting Execution Report	When you submit the Create accounting process, the create accounting execution report is submitted automatically if the create accounting process completes with a success or warning status. The create accounting process output contains a error message with the create accounting execution report request identifier. Use this request identifier to retrieve the execution report output
8	Multiperiod Accounting Execution Report	When you submit the create multiperiod accounting process, the create multiperiod accounting execution report is submitted automatically if the create multiperiod accounting process completes with a success or warning status. The report displays entries created by the create accounting process
Subledger Accounting Subject Areas
·       Subledger Accounting has no predefined OTBI reports. You can use one of the two subject areas to create your own custom reports
·       Dimension folders are added for sequences and supporting reference to report supporting documents and supporting reference balances.
SNO	Subject Area	Description
1	Subledger Accounting - Journals Real time	Real-time information on accounting detail journals
2	Subledger accounting - supporting References Real time	Real time information on subledger transaction supporting reference details