3Accounts Payable Balances
This chapter contains the following:
Review Reports
Oracle Fusion Payables Predefined Reports
Oracle Fusion Payables provides predefined reports that cover the following areas:
-
Invoices
-
Payments
-
Payables to Ledger Reconciliation
-
Period Close
-
Prepayments
-
Income Tax and Withholding
-
Netting
You can schedule and run reports from the Scheduled Processes work area. In some cases, you can access and open reports in the Reports and Analytics work area.
The following tables list the predefined reports.
Invoices
Name | Description |
---|---|
Import Payables Invoices Report |
Report from the process that creates Payables invoices from invoice data in the open interface tables. |
Payables Credit Memo Matching Report |
Lists credit memos and debit memos for suppliers along with the invoices to which the credit memos and debit memos are matched. |
Payables Invoice Aging Report |
Lists unpaid invoices according to the specified aging periods. |
Supplier Balance Aging Report |
List the unpaid supplier invoices according to the specified aging periods. |
Payables Invoice Audit by Voucher Number Listing |
Lists invoices with assigned sequential voucher numbers. |
Payables Invoice Audit Listing |
Lists invoices for review and audit based on a specified amount for a given supplier and range of invoice creation dates. |
Payables Invoice Register |
Provides detailed information about invoices. |
Payables Key Indicators Report |
Generates reports with transaction activity and the current number of suppliers, invoices, payments, and matching holds. |
Payables Matched and Modified Receipts Report |
Identifies receipts that were modified after invoice matching. |
Payables Matching Detail Report |
Provides details of how an invoice, purchase order, or receipt was matched. |
Payables Matching Hold Detail Report |
Provides detailed payables and purchasing information for invoices with matching holds and matching hold releases. |
Payables Negative Supplier Balance Report |
Lists suppliers with negative balances along with the invoices and credit or debit memo transactions for the balance. |
Payments
Name | Description |
---|---|
Payables Cash Requirement Report |
Forecasts immediate cash needs for invoice payments. |
Payables Payment Requests Import Report |
List the payment requests for invoices that are imported or rejected with rejection reasons for payments. |
Payables Discounts Taken and Lost Report |
Identifies payments where a discount was taken and payments where a discount was available, but not taken. |
Payables Payment Register |
Provides detailed information about payments. |
Payables Selected Installments Report |
Lists all invoice installments selected in a payment process request to help determine how well the selection criteria is selecting the correct invoices to pay. |
Payment Audit by Voucher Number Report |
Lists payments with assigned sequential voucher numbers. |
Update Matured Bills Payable Status |
Report from the process that updates the status of matured bills payable from issued to negotiable. |
Payables to Ledger Reconciliation
Name | Description |
---|---|
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 Payables and Oracle Fusion Subledger Accounting. |
Period Close
Name | Description |
---|---|
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. |
Payables Period Close Exceptions Report |
Lists exceptions that prevent the Payables accounting period from closing. |
Payables Posted Invoice Register |
Lists accounting lines for invoices that have been transferred to the general ledger. |
Payables Posted Payment Register |
Lists accounting lines for payments that have been transferred to the general ledger. |
Payables Trial Balance Report |
Lists and subtotals by supplier and liability account, all unpaid and partially paid invoices that Payables transferred to the general ledger. |
Payables Unaccounted Transactions and Sweep Report |
Lists invoices and payments that weren't accounted for a period or date range. |
Prepayments
Name | Description |
---|---|
Prepayment Remittance Notice |
Lists prepayments that were applied to supplier invoices. |
Income Tax and Withholding
Name | Description |
---|---|
Payables Withholding Tax by Tax Authority Report |
Lists withholding for tax codes assigned to a tax authority. |
Payables Withholding Tax Letter |
Creates a withholding tax letter to mail to a supplier on a periodic basis. The letter contains a list of withholding made for a supplier summarized either by tax type and tax rate, or by supplier site. |
Payables Withholding Tax Report |
Lists withholding 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. |
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. |
US 1096 Report |
Summarizes each United States1099 form type that's transmitted on paper, as required by the United States Internal Revenue Service. Generates the summary on a preformatted Internal Revenue Service form. |
US 1099 Electronic Media Report |
Generates summarized United States1099 information in electronic format, as required by the United States Internal Revenue Service. |
US 1099 Forms - Comma Delimited Format |
Reports the total United States 1099 miscellaneous tax type payments for 1099 suppliers in a comma delimited format. |
US 1099 Invoice Exceptions Report |
Lists paid invoice distributions with inaccurate or missing United States 1099 income tax information. |
US 1099 Payments Report |
Lists payments made to United States 1099 suppliers. |
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. |
US 1099 Supplier Exceptions Report |
Lists suppliers with inaccurate or incomplete United States 1099 income tax information. |
Netting
Name | Description |
---|---|
Netting Settlement Letter |
Prints a letter that detail Receivables and Payables transactions in a netting settlement. |
Netting Reversal Letter |
Prints a letter that detail Receivables and Payables transactions reversed in a netting settlement. |
Netting Settlement Report |
Lists the transactions netted for a specific netting settlement in the PDF format. |
Netting Settlement Listing |
Lists the transactions netted for a specific netting settlement in the spreadsheet format. |
Payables Subject Areas, Folders, and Attributes
To create real-time analyses for Oracle Fusion Payables, you should be familiar with subject areas, folders, and attributes.
Subject Areas
To create an analysis, you begin by selecting a subject area from which you select columns of information to include in the analysis. For example, to create an analysis of invoice installments, you begin by selecting the Payables Invoices - Installments Real Time subject area. Subject areas are based around a business object or fact. In this example, the subject area is based on columns in the invoice installments tables.
Payables has the following subject areas:
-
Payables Invoices - Holds Real Time
-
Payables Invoices - Installments Real Time
-
Payables Invoices - Prepayment Applications Real Time
-
Payables Invoices - Transactions Real Time
-
Payables Invoices - Trial Balance Real Time
-
Payables Invoices - Withholding Real Time
-
Payables Payments - Disbursements Real Time
-
Payables Payments - Payment History Real Time
Folders
Each subject area has one fact folder and a number of dimension folders. Fact folders contain attributes that can be measured, meaning that they're numeric values like available discount and unpaid amount. Dimension folders contain attribute and hierarchical columns like bank account number and due date.
Some folders appear in more than one subject area, such as the Time folder. These folders are referred to as common folders or common dimensions.
Each folder within a subject area may have a different level of granularity. For example:
-
Invoices Installment Details has installment information.
-
Invoice Details has subfolders and details within the subfolders.
Attributes
Finally, each dimension folder contains attributes (columns), such as invoice date and invoice accounting date. This figure illustrates the structure of subject areas, folders, and facts.

The preceding figure shows the following components:
-
Subject Area: Payables Invoices - Installments Real Time
-
Dimension - Presentation Folder: Invoices Installments Details
-
Dimension - Attributes: Bank Account Number, Bank Charge Bearer, Check Digits
-
Fact - Presentation Folder: Invoices Installment Amounts
-
Fact - Measures: Discount Available, Gross Amount, Second Discount Available, Third Discount Available, Unpaid Amount
Submit Invoice Reports
Payables Negative Supplier Balance Report: Explained
This topic includes details about the Payables Negative Supplier Balance Report.
Overview
The Payables Negative Supplier Balance Report lists suppliers with negative balances, and the invoices and credit or debit memo transactions, for the balance.
The following figure is an example of the summary page from the report.

The following figure is an example of the details page from the report.

Key Insights
The report helps identify the list of suppliers with negative balances.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Negative Supplier Balance Report.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices. |
Who uses this report? |
|
When do I use this report? |
Periodically to identify the list of suppliers with a negative closing balance. |
What can I do with this report? |
|
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
The summary section of the report uses the Payables Invoices - Trial Balance Real Time subject area. The detailed section of the report uses the Payables Invoices - Transactions Real Time subject area.
Payables Negative Supplier Balance Report
View negative supplier balances for a business unit.
You can run this report from the Reports and Analytics work area.
- Business Unit
-
Specify a business unit.
- As-of Accounting Date
-
Enter an accounting date.
- Include Write Offs
-
Select whether to show outstanding balances that are the result of write-off accounting.
- Supplier
-
Specify one or more suppliers.
- Liability Account
-
Specify one or more liability accounts.
Parameters
Report Output
You can manage the section headers and columns on the report. For example, change the column sorting, or make a section header a column or parameter.
Payables Invoice Aging Report
This topic includes details about the Payables Invoice Aging Report.
Overview
The Payables Invoice Aging Report lists unpaid invoices according to specified aging periods.
The following figure is an example of the report.

Key Insights
The report provides the break down of the accounts payable balance across aging buckets that you can configure. Before running this report, create aging periods on the Create Aging Periods page and run the Apply Missing Conversion Rates process to provide missing conversion rate information.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Invoice Aging Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Run the report to review the outstanding amounts due to a supplier, and for how long the invoice installments have been due. |
What can I do with this report? |
You can run this report for a business unit, supplier, invoice type, and aging period. You also have various sorting options and can specify whether to include invoice and supplier site details. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Invoice Aging Report
Use the aging report to view unpaid invoices. The report provides information about invoices due within the four time periods defined on the Create Aging Periods page. If you use multiple currencies, the report converts the invoice amounts to the ledger currency.
You can run this report from the Manage Scheduled Processes page.
Before running this report, create invoice aging periods on the Create Aging Periods page and run the Apply Missing Conversion Rates process. If the report includes foreign currency invoices that are missing conversion rates, amounts won't appear on the report.
- Business Unit
-
Specify the name of a business unit.
- Sort Invoices By
-
-
Invoice type
-
Trading partner
-
- Include Invoice Detail
-
-
Yes: Lists invoice detail when showing invoice payments due to a supplier
-
No: Summarizes the total invoice payments due to a supplier without listing each invoice
-
- Include Supplier Site Detail
-
-
Yes: Lists supplier site detail
-
No: Lists the name of each supplier
-
- Minimum Amount Due
-
Specify the minimum invoice amount that should appear on the report.
- Maximum Amount Due
-
Specify the maximum invoice amount that should appear on the report.
- Invoice Type
-
Select an invoice type, such as Standard or Credit memo, or leave blank to run the report for all invoice types.
- Supplier or Party
-
Specify the name of a supplier or party.
- Aging Period
-
Specify the name of an aging period that was defined on the Create Aging Periods page.
Parameters
Supplier Balance Aging Report: Explained
This topic includes details about the Supplier Balance Aging Report.
Overview
The Supplier Balance Aging Report list the supplier invoices according to specified aging periods. The report provides the breakdown of the accounts payable balance across aging buckets that you configure in the aging periods. If you use multiple currencies, the report converts the invoice amounts to the ledger currency using the conversion rate provided on the invoice.
The following image is an example of the report:

Key Insights
This report allows user to generate the Supplier Balance Aging Report for any specific date. The aging report considers only those supplier invoices that are accounted and transferred to the General Ledger and as a result the balances in this report match up with the trial balance report.
-
This report has a column Unallocated Amount. Invoice amounts are displayed in this column based on specific data scenarios listed in the following: The amount isn't within the range of the defined aging buckets for payment due.
-
The outstanding amount for the invoice and the installment don't match. This can happen when one of the amounts is displayed as a positive amount and the other as a negative amount.
-
The payment amount is greater than the invoice amount. This can happen when the invoice distributions have different accounting dates and the invoice or installment has been paid in between the accounting dates.
Frequently Asked Questions
The following table lists frequently asked questions about the Supplier Balance Aging Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Run the report to review the outstanding amounts due to a supplier, and for how long the invoice installments have been due. |
What can I do with this report? |
You can run this report for a business unit, supplier, invoice type, and aging period. You also have various sorting options and can specify whether to include invoice and supplier site details. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Supplier Balance Aging Report
Use the aging report to view the supplier balances according to specified aging periods. The report provides the breakdown of the Payables supplier balance across aging buckets that you configure in the aging periods. If you use multiple currencies, the report converts the invoice amounts to the ledger currency using the conversion rate provided on the invoice.
You can run this report from the Manage Scheduled Processes page.
Before running this report, create the invoice aging periods on the Create Aging Periods page and run the Create Accounting process with the option to transfer the balances to General Ledger
- Ledger (Required)
-
Specify the name of the ledger.
- Business Unit
-
Specify the business unit.
- Include Invoice Detail
-
-
Yes: Lists invoice detail when showing invoice payments due to a supplier
-
No: Summarizes the total invoice payments due to a supplier without listing each invoice.
-
- Include Supplier Site Detail
-
-
Yes: Lists supplier site detail.
-
No: List the name of the supplier.
-
- Invoice Type
-
Select an invoice type, such as Standard or Credit Memo, or leave blank to run the report for all invoice types.
- Party Name
-
Specify the name of a supplier or party.
- Aging Period (Required)
-
Specify the name of an aging period that was defined on the Create Aging Periods page.
- Balance As-of Date (Required)
-
Enter the balance effective date for the supplier invoice status you want to analyze.
- Account Range
-
Enter the supplier liability accounts that you want to be considered for the report.
Parameters
Payables Key Indicators Report
This topic includes details about the Payables Key Indicators Report.
Overview
The Payables Key Indicators Report generates reports with transaction activity, and the current number of suppliers, invoices, payments, and matching holds.
The following figure is an example of the report.

Key Insights
The report provides summary information for key indicators, such as the number of invoices and payments entered, and the modifications made for those transactions during a period.
Frequently Asked Questions
The following table list frequently asked questions about the Payables Key Indicators Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Periodically to get activity details for a period, such as the number of invoices created and percentage of invoices modified. You can also review exceptions for invoices, payments, and reconciliation. |
What can I do with this report? |
|
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Key Indicators Report
Generate the Payables Key Indicators report to review payables transaction activity and the current number of invoices, payments, and matching holds.
The report is composed of the following sections:
-
Current Activity: Compares payables activity for the period that you specify and the previous period. You might want to report on key indicators weekly or monthly to review short-term productivity, and quarterly to review longer-term productivity.
-
State of the Application: Provides a payables snapshot at the end of the specified key indicator period.
-
Invoice Activity: Compares the invoice entry activity for each accounts payable user for the specified period and for the previous period.
You can run the report from the Manage Scheduled Processes page.
Before running this report, you must define a General Purpose calendar using the Manage Payables Calendars task.
- Business Unit
-
Specify the business unit.
- Period Name
-
Select the name of the calendar period to report.
- Include Invoice Details
-
Select whether to generate the key indicators for invoice activity.
- Invoice Entered By
-
Select a user name to limit the key indicators for the Invoice Activity section to a specific user.
Parameters
Workflow Rules Report
This topic includes details about the Workflow Rules Report.
Overview
You can now use the Workflow Rules Report to view the workflow rules configured in Oracle Business Process Management (BPM) for Payables Invoice Approval, General Ledger Journal Approval, and Expense Report Approval workflows. You can view the report output in both spreadsheet and XML format.
Key Insights
You can use this report to obtain details of the stage, participant, rule status, rule conditions, and approval routing for each rule.
Report Parameters
Parameter | Description |
---|---|
Workflow |
You can select the workflow for which you want to review the workflow rules. |
Frequently Asked Questions
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Workflow Rules Administrator |
When do I use this report? |
Use this report to review existing workflow rules defined in BPM. |
What type of a report is this? |
Spreadsheet, XML |
Approval Groups Report
This topic includes details about the Approval Groups Report.
Overview
You can now use the Approvals Group Report to view the approval groups defined in Oracle Business Process Management (BPM). You can view the report output in both spreadsheet and XML format.
Key Insights
You can obtain the details of the group name, the approvers, and the sequence in which the approvers appear in the approval group.
Report Parameters
There are no parameters that you need to select for this report.
Frequently Asked Questions
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Workflow Rules Administrator |
When do I use this report? |
Use this report to review approval groups defined in BPM. |
What type of a report is this? |
Spreadsheet, XML |
Payables Matched and Modified Receipts Report
This topic includes details about the Payables Matched and Modified Receipts Report.
Overview
The Payables Matched and Modified Receipts Report identifies the receipts that were modified after invoice matching.
The following figure is an example of the report.

Key Insights
The report lists the receipts that were modified after an invoice was created. Information in this report helps you take further action, such as creating a debit memo if you returned some quantity of the receipt to the supplier.
Frequently Asked Questions
The following table list frequently asked questions about the Payables Matched and Modified Receipts Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Periodically for details of receipt numbers that were modified after an invoice was created. |
What can I do with this report? |
Run the report for a business unit and receipt date range. You can also run the report for a supplier and supplier site. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Matched and Modified Receipts Report
You can use the Payables Matched and Modified Receipts report to identify receipts that were changed after being matched to an invoice. A receipt might be changed for example, to correct the received quantity or record the return of a defective product.
The report displays receipts that were matched to an invoice, credit memo, or debit memo, and modified within the specified dates. If you match multiple invoices to a receipt before the modification date, the report lists all of the matched distributions. If you match one invoice to a receipt and:
-
No distributions were matched after the receipt line was modified, then all matched distributions are listed.
-
Any distributions were matched after the receipt line was modified, then none of the matched distributions are listed. The modified receipt quantities were seen when later matches were performed and tolerances were checked during the invoice validation process.
You can run this report from the Scheduled Processes work area.
- Business Unit
-
Specify the business unit.
- Supplier Name
-
Enter a supplier to limit the report to receipts for a particular supplier.
- Supplier Site
-
Enter a supplier site to limit the report to invoices and receipts entered to a particular site.
- Invoice Status
-
Select one of the following invoice statuses or leave the parameter blank:
-
Needs revalidation
-
Never validated
-
Paid
-
Validated
-
- From Receipt Modification Date, To Receipt Modification Date
-
Enter one or both modification dates to limit the report to receipts that were modified during a particular date range.
Parameters
Payables Matching Detail Report
This topic includes details about the Payables Matching Detail Report.
Overview
The Payables Matching Detail Report provides details of how an invoice, purchase order, or receipt, was matched.
The following figure is an example of the report.

Key Insights
The report provides details of transactions that were created against an invoice and its related documents, such as a purchase order or receipt. For example, you can get the list of all the invoices that were matched against a purchase order, or similarly the list of all the purchase orders against which an invoice was matched.
Frequently Asked Questions
The following table list frequently asked questions about the Payables Matching Detail Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
When you want to review details of how an invoice, or its related purchase orders or receipts, was created. |
What can I do with this report? |
|
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Matching Detail Report
Use the Payables Matching Detail report to review details of how an invoice, purchase order, receipt, or consumption advice was matched. This report is helpful when an invoice is on hold and you're trying to determine why the hold was placed. Data entry errors can occur during matching, and the information in this report can help with your research.
You can run this report from the Scheduled Processes work area.
- Business Unit
-
Specify a business unit.
- Invoice Number
-
Specify an invoice number.
- Purchase Order Number
-
Specify a purchase order number. For this report, only Standard is a valid type of purchase order.
- Receipt Number
-
Specify a receipt number that you want to see matching detail for. Don't include any unordered or internal receipts because they can't be matched to invoices.
- Consumption Advice Number
-
Specify a consumption advice number.
Parameters
Payables Matching Hold Detail Report: Explained
This topic includes details about the Payables Matching Hold Detail Report.
Overview
The Payables Matching Hold Detail Report provides detailed payables and purchasing information for invoices with matching holds and matching hold releases.
The following figure is an example of the report.

Key Insights
The report lists the matching holds that were placed on an invoice, along with corresponding hold release details. The report helps identify the list of suppliers who often send invoices outside the tolerance percentage, resulting in matching holds. You can streamline your processes by contacting these suppliers and resolving the issues that cause the matching holds.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Matching Hold Detail Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Run the report when you want to review the reasons that matched invoices went on hold. |
What can I do with this report? |
Use the report to identify suppliers that frequently have invoices on matching hold. You can run this report for a supplier and for a data range. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Matching Hold Detail Report
Review detailed payables and purchasing information for invoices with matching holds and for invoices released from matching holds. This report can help identify suppliers with frequent matching holds. You can also use this report to answer supplier questions on delayed payments.
You can run this report from the Scheduled Processes work area.
- Business Unit
-
Specify a business unit.
- Matching Hold Status
-
Select to report on holds or hold releases:
-
Hold: Report invoices with matching holds.
-
Release: Report invoices released from matching holds.
Leave the parameter blank to report on both matching holds and releases.
Note: If you select Release or leave this parameter blank, the report also includes matched invoices that are canceled. -
- Supplier Name
-
Specify the name of a supplier to limit the report to invoices for that supplier.
- From Hold or Release Date, To Hold or Release Date
-
Specify a date range to report matching holds that were placed or released.
- Report Type
-
Select a report type.
-
All validations: Prints details of all types of holds placed and released.
-
Audit report: Prints details of only system-placed holds.
-
Parameters
Payables Invoice Audit Listing
This topic includes details about the Payables Invoice Audit Listing.
Overview
The Payables Invoice Audit Listing lists invoices based on a specified amount, for a given supplier and range of invoice creation dates.
The following figures provide an example of one page from the report.


Key Insights
The report helps identify invoices that may have been entered in the application more than once.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Invoice Audit Listing.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices. |
Who uses this report? |
|
When do I use this report? |
Periodically to check that duplicate invoices weren't entered for the same supplier. |
What can I do with this report? |
|
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Invoices - Transactions Real Time subject area.
Payables Invoice Audit Listing
You can run the Payables Invoice Audit Listing periodically to audit invoices for duplicates.
Run the report from the Reports and Analytics work area.
- Business Unit
-
Specify a business unit.
- Invoice Type
-
Select a type of invoice or leave blank to print invoices with all types.
- Begin Invoice Date
-
Specify an invoice date after which to report invoices.
- Minimum Invoice Amount
-
Specify the minimum invoice amount to include on the report. The report lists invoices with an amount equal to or greater than the amount that you specify.
Parameters
Report Output
You can manage the section headers and columns on the report. For example, change the column sorting, or make a section header a column or parameter.
Payables Invoice Audit by Voucher Number Listing
This topic includes details about the Payables Invoice Audit by Voucher Number Listing.
Overview
The Payables Invoice Audit by Voucher Number Listing lists invoices with assigned sequential voucher numbers.
The following figures provide an example of one page from the report.


Key Insights
The report lists the invoices created for a document sequence and the missing voucher numbers for a particular sequence.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Invoice Audit by Voucher Number Listing.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices. |
Who uses this report? |
|
When do I use this report? |
Use the report to audit the invoices that were entered for a document sequence. |
What can I do with this report? |
You can run the report for a sequence with a specified range of voucher numbers. |
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Invoices - Transactions Real Time subject area.
Payables Invoice Audit by Voucher Number Listing
Review invoices with assigned sequential voucher numbers.
You can run this report from the Reports and Analytics work area.
- Business Unit
-
Specify a business unit.
- Sequence
-
Select the name of a sequence.
- Voucher Number
-
Specify a voucher number range.
Parameters
Report Output
You can manage the section headers and columns on the report. For example, change the column sorting, or make a section header a column or parameter.
Payables Invoice Register
This topic includes details about the Payables Invoice Register.
Overview
The Payables Invoice Register provides detailed information about invoices.
The following figures are an example of one page of the report from the Reports and Analytics pane.


The following figure is an example of the report from the Scheduled Processes work area.

Key Insights
Use this report to cross-check invoices entered in the application with the physical invoices that were used to enter those invoices.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Invoice Register.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu, or from the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices. |
Who uses this report? |
|
When do I use this report? |
Daily to cross check invoice data entry in the application against the invoice on which the entry was made. |
What can I do with this report? |
Run the report for a specific invoice group, date range, accounting period. You can also specify an invoice status, such as validated or canceled. |
What type of report is this? |
Oracle Business Intelligence Publisher and Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Invoices - Transactions Real Time subject area.
Payables Invoice Register
You can use the Payables Invoice Register to review detailed information about invoices.
This report is available through Oracle Transactional Business Intelligence and Oracle Business Intelligence (BI) Publisher. Run the Oracle BI Publisher report from the Scheduled Processes work area. Run the Oracle Transactional Business Intelligence report from the Reports and Analytics work area.
- Business Unit
-
Specify a business unit.
- Supplier
-
Select the name of a supplier.
- Entered By
-
Select a user name to limit the report to invoices entered by a particular person. Leave blank to include all invoices, regardless of who entered them.
- Invoice Group
-
Specify the name of an invoice group.
- Invoice Type
-
Select a type of invoice.
- Canceled Invoices Only
-
Select whether to report only on canceled invoices.
- Unvalidated Invoices Only
-
Select whether to report only invoices that haven't been validated.
Parameters for both Oracle Transactional Business Intelligence and Oracle BI Publisher
- Supplier Type
-
Select a type of supplier.
- Supplier Number
-
Select the number of a supplier.
- Invoice Number
-
Enter a range of invoice numbers.
- Entered Date
-
Enter a range of invoice entry dates.
- Accounting Date
-
Enter a range of accounting dates.
- Currency
-
Select a currency.
- Original Amount
-
Enter a range of amounts.
- Purchase Order
-
Enter a range of purchase order numbers.
- Report View
-
Select a report view of Exclude Distributions or Include Distributions.
Parameters for Oracle Transactional Business Intelligence Report Only
- From Entered Date, To Entered Date
-
Specify an invoice entry date range.
- Accounting Period
-
Select an accounting period.
Parameters for Oracle BI Publisher Report Only
Report Output
You can manage the section headers and columns on the Oracle Transactional Business Intelligence report. For example, change the column sorting, or make a section header a column or parameter.
Prepayment Remittance Notice
This topic includes details about the Prepayment Remittance Notice.
Overview
The Prepayment Remittance Notice lists prepayments that were applied to supplier invoices.
The following figure is an example of the report.

Key Insights
Identify the list of open prepayments per supplier and the amount remaining to be applied.
Frequently Asked Questions
The following table lists frequently asked questions about the Prepayment Remittance Notice.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Periodically to get the list of prepayments that are already paid but for which there is no supplier invoice, or the prepayment hasn't been applied to any standard invoice yet. |
What can I do with this report? |
Send it to the supplier as a reminder to send you any outstanding invoices that may be due against the advance payments. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Prepayment Remittance Notice
You can print a notice to inform your suppliers about prepayments that were applied to their invoices. As a result of prepayment application, a future payment may be reduced or not sent.
The notice includes the following information:
-
Prepayment number
-
Date the prepayment was applied
-
Amount that was applied
-
Number of the invoice that the prepayment was applied to
-
Remaining invoice amount, which is zero if the applied amount was equal to the invoice amount
You can submit the notice from the Scheduled Processes work area.
- Business Unit
-
Specify a business unit.
- Supplier Name
-
Specify the name of a supplier.
- Invoice Number
-
Specify an invoice number.
- Prepayment Number
-
Specify a prepayment number.
- From Date, To Date
-
Specify an inclusive invoice date range.
- Sender Name
-
Enter the name of the person sending the notice.
- Sender Title
-
Enter the title of the person sending the notice.
- Sender Phone
-
Enter the phone of the person sending the notice.
Parameters
You should enter a value in one or more parameters to limit the number of notices that print. If you don't enter any parameters, a notice is printed for every prepayment.
Payables Credit Memo Matching Report
This topic includes details about the Payables Credit Memo Matching Report.
Overview
The Payables Credit Memo Matching Report lists credit memos and debit memos for suppliers and the invoices to which the credit memos and debit memos are matched.
The following figures provide an example of one page from the report.


Key Insights
The report lists credit memo and debit memo details at the invoice distribution level, and amounts in both the entered and ledger currencies.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Credit Memo Matching Report.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane navigate to Shared Folders > Financials > Payables > Invoices. |
Who uses this report? |
|
When do I use this report? |
Periodically to check the credit memos and debit memos that were created for a supplier or group of suppliers. |
What can I do with this report? |
Review credit memo and debit memo line information. |
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Invoices - Transactions Real Time subject area.
Payables Credit Memo Matching Report
Review credit memo and debit memo line information, such as line amount and the invoice that the credit or debit memo is matched to.
You can run this report from the Reports and Analytics work area.
- Business Unit
-
Specify the business unit.
- Supplier Type
-
Select the type of supplier.
- Supplier
-
Select one or more supplier names.
- Supplier Number
-
Select one or more supplier numbers.
- Currency
-
Select a currency.
- Invoice Amount Between
-
Specify an inclusive invoice amount range.
- Accounting Date Between
-
Specify an inclusive accounting date range.
- Credit Memo Date Between
-
Specify an inclusive credit memo date range.
Parameters
Import Payables Invoices Report
This topic includes details about the Import Payables Invoices Report.
Overview
The Import Payables Invoices Report provides information from the Import Payables Invoices process, which creates invoices from invoice data in the open interface tables.
The following figure is an example of the report.

Key Insights
The report provides the results of the import process with the list of invoices that imported successfully along with the reasons that invoices may have failed to import.
Frequently Asked Questions
The following table lists frequently asked questions about the Import Payables Invoices Report.
FAQ | Answer |
---|---|
How do I find this report? |
The report is automatically generated by the Import Payables Invoices process, but you can also schedule and run it from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Specialist |
When do I use this report? |
When you run the Import Payables Invoices process and want to review the results of the process. |
What can I do with this report? |
Review the report for invoices that couldn't be imported. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Submit Payments Reports
Payables Cash Requirement Report
This topic includes details about the Payables Cash Requirement Report.
Overview
The Payables Cash Requirement Report forecasts immediate cash needs for invoice payments.
The following figure is an example of the report.

Key Insights
The report identifies the cash required for making a payment in a payment batch.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Cash Requirement Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Before every payment process request to determine cash requirements for that request. |
What can I do with this report? |
|
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Cash Requirement Report
Use this report to forecast immediate cash needs for invoice payments. You can run the Payables Cash Requirement report before submitting every payment process request to determine cash requirements for that request. You can also submit this report for the next two or three payment process requests to forecast future cash requirements.
The report produces output based on the definition of the payment process request template and the payment business units that you're allowed to access.
Run the report from the Reports and Analytics work area or from the following pages:
-
Manage Scheduled Processes
-
Manage Payment Process Requests
-
Create or Edit Payment Process Request Template
- Payment Business Unit
-
Specify a payment business unit, which is a business unit with the Payables Payment business function that's responsible for processing payment transactions.
- Template
-
Select the payment process request template to forecast cash requirements for.
- Pay Through Date
-
Enter a date to determine which invoices to select for payment.
- Payment Date
-
Enter a date to determine discounts and interest calculations.
Note: The report might include invoices that you plan to pay with a bill payable, if the payment date is before the expected maturity date. - Summary Option
-
Select the level of invoice information to report.
-
No: Lists unpaid or partially paid invoices for a currency, by payment date and supplier name, starting with invoices with the earliest due or discount date.
-
Yes: Lists the payment amount due, but doesn't provide individual invoice information.
-
- Include Unvalidated Invoices
-
Select whether to include invoices that aren't validated.
Note: When you include unvalidated invoices, the invoice amount might change before the invoice is paid. For example, invoice validation hasn't completed certain tax calculations, or the invoice may be on hold for an amount-related issue. - Include Unapproved Invoices
-
Select whether to include invoices that aren't approved.
- Included Selected Invoices
-
Select whether to include invoices that have been selected by other payment process requests.
Tip: Consider excluding unvalidated, unapproved, and selected invoices because these invoices are excluded from payment process request processing.
Parameters
Import Payables Payment Requests Report
This topic includes details about the Import Payables Payment Requests Report.
Overview
Use this report to view the payment requests imported or rejected with rejection reasons. When you run the Import Payables Payment Request process this report is generated automatically. The report can be submitted in both summary and detail versions.
The following image is an example of the report:

Key Insights
The report is divided into the following sections:
Payables Payment Requests Audit Report
-
List all imported payment request.
Payables Payment Request Rejections Report
-
Party Rejections
-
Address Rejections
-
Bank Rejections
-
Payment Requests Rejections
Frequently Asked Questions
The following table lists frequently asked questions about the Import Payables Payment Requests Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Run the report to review the request for payment. |
What can I do with this report? |
Review the payment request and rejections for payment. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Payment Requests Import Report
Use this report to view the payment requests imported or rejected with reasons. When you run the Import Payables Payment Requests process. This report automatically is generated. The report can be viewed in either summary or detail.
- Process ID
-
Required field with no default.
Parameters
Payables Discounts Taken and Lost Report
This topic includes details about the Payables Discounts Taken and Lost Report.
Overview
The Payables Discounts Taken and Lost Report identifies payments where a discount was taken and payments where a discount was available, but not taken.
The following figures provide an example of one page of the report from the Reports and Analytics pane.


The following figure is an example of the report from the Scheduled Processes work area.

Key Insights
View a summary of each payment line for a supplier site.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Invoice Register.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu, or from the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Payments. |
Who uses this report? |
|
When do I use this report? |
Periodically to check for available discounts and discounts that were lost. |
What can I do with this report? |
Use the information to identify invoices with lost discounts and decide whether you can benefit from taking these discounts. |
What type of report is this? |
Oracle Business Intelligence Publisher and Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the following subject areas:
-
Payables Invoices - Transactions Real Time
-
Payables Payments - Disbursements Real Time
Payables Discounts Taken and Lost Report
Identify payments for which you could have taken a discount, but didn't. If you're losing discounts, you can change your payables and supplier setup and modify selection criteria for payment process requests to take all valid discounts.
This report is available through Oracle Transactional Business Intelligence and Oracle Business Intelligence (BI) Publisher. Run the Oracle BI Publisher report from the Scheduled Processes work area. Run the Oracle Transactional Business Intelligence report from the Reports and Analytics work area.
- Business Unit
-
Specify the business unit.
- Supplier Type
-
Select the type of supplier.
- Supplier
-
Select the name of the supplier.
Parameters Used in Both Oracle Transactional Business Intelligence and Oracle BI Publisher
- Payment Date Between
-
Specify an inclusive payment date range.
- Accounting Date Between
-
Specify an inclusive accounting date range.
- Payment Amount Between
-
Specify an inclusive payment amount range.
- Supplier Number
-
Select the number of a supplier.
- Currency
-
Select a currency.
- View Selector
-
Select to view Discount Taken and Lost by Invoice or Summarize Invoices by Site.
Parameters in Oracle Transactional Business Intelligence Report Only
- From Payment Date, To Payment Date
-
Specify an inclusive payment date range.
- Summarize Invoices by Supplier Site
-
-
Yes: Summarizes each invoice payment line.
-
No: Lists details of each invoice payment line.
-
Parameters in Oracle BI Publisher Report Only
Payables Payment Register: Explained
This topic includes details about the Payables Payment Register.
Overview
The Payables Payment Register provides detailed information about payments.
The following figure is an example of one page of the report from the Reports and Analytics pane.


The following figure is an example of the report from the Scheduled Processes work area.

Key Insights
The report lists all of the payments made for a date range.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Payment Register.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu, or from the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Payments. |
Who uses this report? |
|
When do I use this report? |
Daily to cross reference the created payment checks with the report. |
What can I do with this report? |
Run the report for a specific supplier, date range, bank account, and payment currency. |
What type of report is this? |
Oracle Business Intelligence Publisher and Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Payments - Disbursements Real Time subject area.
Payables Payment Register
You can use the Payables Payment Register to review payments created for each bank account that you use.
This report is available through Oracle Transactional Business Intelligence and Oracle Business Intelligence (BI) Publisher. Run the Oracle BI Publisher report from the Scheduled Processes work area. Run the Oracle Transactional Business Intelligence report from the Reports and Analytics work area.
- Business Unit
-
Specify a business unit.
- Payment Type
-
Select a type of payment.
Parameters Used in Oracle Transactional Business Intelligence and Oracle BI Publisher Reports
- Payment Date Between
-
Specify an inclusive payment date range.
- Supplier Type
-
Select a type of a supplier.
- Supplier
-
Enter the name of a supplier.
- Supplier Number
-
Select the number of a supplier.
- Bank
-
Select the name of a bank.
- Bank Branch
-
Select a bank branch.
- Bank Account
-
Select a bank account.
- Payment Currency
-
Select a payment currency.
- Payment Amount Between
-
Specify an inclusive payment amount range.
Parameters in Oracle Transactional Business Intelligence Report Only
- Business Unit Context
-
Select the context for the payment amount. If you select Invoice and centralize payment processing using the service provider model, the report displays the payment amount for the specified invoice business unit.
- From Date, To Date
-
Specify an inclusive payment date range.
- Display Payee Address
-
Select to include the payee address.
Parameters in Oracle BI Publisher Report Only
Report Output
You can manage the section headers and columns on the Oracle Transactional Business Intelligence report. For example, change the column sorting, or make a section header a column or parameter.
Payment Audit by Voucher Number Report: Explained
The Payment Audit by Voucher Number Report lists payments by sequential voucher numbers.
The following figure is an example of the report.

Key Insights
The report helps identify the payments created for a document sequence and any missing voucher numbers for a particular sequence.
Frequently Asked Questions
The following table lists frequently asked questions about the Payment Audit by Voucher Number Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
When you want to audit the payments that were entered for a document sequence. |
What can I do with this report? |
Run the report for a sequential range of voucher numbers. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payment Audit by Voucher Number Report
Review payments with assigned sequential voucher numbers. You can also use this report to review assigned, available, and deleted voucher numbers for the sequence that you specify.
You can run this report from the Reports and Analytics work area or the Manage Scheduled Processes page.
- Business Unit
-
Specify a business unit.
- Document Sequence Name
-
Specify the name of a sequence.
- From Voucher Number, To Voucher Number
-
Specify an inclusive voucher number range.
Parameters
Payables Selected Installments Report: Explained
This topic includes details about the Payables Selected Installments Report.
Overview
The Payables Selected Installments Report lists all the invoice installments that are selected in a payment process request.
The following figure is an example of the report.

Key Insights
The report provides a total payment amount for each currency.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Selected Installments Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Whenever you submit a payment process request. |
What can I do with this report? |
Use the report to help determine how well the selection criteria is identifying the correct invoices to pay. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Update Matured Bills Payables Status Report: Explained
This topic includes details about the Update Matured Bills Payables Status Report.
Overview
The Update Matured Bills Payables Status Report provides information about the Update Matured Bills Payable process, which updates the status of matured bills payables from issued to negotiable.
The following figure is an example of the report.

Key Insights
The report lists the payments that were issued along with the maturity date of each payment.
Frequently Asked Questions
The following table lists frequently asked questions about the Update Matured Bills Payables Status Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
|
When do I use this report? |
Periodically for information on payments that haven't matured yet. |
What can I do with this report? |
You can run this report for a bank account or supplier to determine the list of payments that were issued and not negotiable. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Submit Withholding Tax Reports
Payables Withholding Tax Report: Explained
This topic includes details about the Payables Withholding Tax Report.
Overview
The Payables Withholding Tax Report lists the withholdings for a supplier. The report has an invoice view and a supplier view. The invoice view is used to review detailed withholding tax information by invoice. The supplier view is used to review withholding information for a range of suppliers.
The following figures provide an example of one page from the report.


Key Insights
The report lists the invoices that have withholding deductions.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Withholding Tax Report.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Income Tax and Withholding. |
Who uses this report? |
|
When do I use this report? |
Periodically to get details of the withholdings that were deducted an invoice. |
What can I do with this report? |
|
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Invoices - Transactions Real Time subject area.
Payables Withholding Tax Report
Review detailed invoice withholding tax information for a supplier. Use the information in this report to satisfy management, supplier, and tax authority reporting requirements.
Run the report from the Reports and Analytics work area.
- Business Unit
-
Specify a business unit.
- Currency
-
Select whether to review invoices in the entered currency or the ledger currency.
- Invoice Date
-
Enter an invoice date range.
- Invoice Group
-
Specify the name of an invoice group.
- Invoice Type
-
Select the type of invoice.
- Supplier
-
Select one or more suppliers.
- Supplier Number
-
Select one or more supplier numbers.
Parameters
- Withholding Tax by Invoice Report
-
Select this view to review detailed invoice withholding tax information, including invoice number, amount subject to withholding, and withholding tax amounts. Use this view if the Apply Withholding Tax option is set to At invoice validation on the Manage Tax Reporting and Withholding Tax Options page.
- Withholding Tax by Supplier Report
-
Select this view to review detailed withholding tax information, including invoice number, payment number, and withholding tax amounts, regardless of when withholding occurred.
Report View
Report Output
You can manage section headers and columns on the report. For example, you can change column sorting, or change a section header to a column or parameter.
Payables Withholding Tax by Tax Authority Report: Explained
This topic includes details about the Payables Withholding Tax by Tax Authority Report.
Overview
The Payables Withholding Tax by Tax Authority Report lists withholdings for tax codes assigned to a tax authority.
The following figure is an example of the report.


Key Insights
The report lists withholding tax information for withholding tax codes that have amounts withheld.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Withholding Tax by Tax Authority Report.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Income Tax and Withholding. |
Who uses this report? |
|
When do I use this report? |
Periodically, to determine withholding amounts for each withholding authority. |
What can I do with this report? |
|
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Invoices - Transactions Real Time subject area.
Payables Withholding Tax by Tax Authority Report
Review detailed withholding tax information for withholding tax codes assigned to a Tax Authority type supplier. Use the information in this report to satisfy management, supplier, and tax authority reporting requirements.
You can run this report from the Reports and Analytics work area.
- Business Unit
-
Specify a business unit.
- Currency
-
Select whether to list invoices in the entered or ledger currency.
- Invoice Date
-
Specify an invoice date range.
- Invoice Group
-
Select an invoice group.
- Invoice Type
-
Select a type of invoice.
- Supplier
-
Select the name of a supplier.
- Supplier Number
-
Select the number of a supplier.
- Tax Authority Name
-
Select the name of a supplier with a type of Tax Authority.
- Tax Authority Site
-
Select a site for the tax authority supplier.
- Withholding Tax Name
-
Select a withholding tax code. Leave this parameter blank to review withholding tax information for all withholding tax codes assigned to the specified tax authority.
Parameters
Report Output
You can manage section headers and columns on the report. For example, you can change column sorting, or change a section header to a column or parameter.
Payables Withholding Tax Letter: Explained
This topic includes details about the Payables Withholding Tax Letter.
Overview
The Payables Withholding Tax Letter is a letter that you can mail to a supplier periodically. The letter contains a list of withholdings made for the supplier summarized either by tax type and tax rate, or by supplier site
The following figure is an example of the report.

Key Insights
The letter provides details of the withholding amounts for various withholding codes that were deducted for a period.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Withholding Tax Letter.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Periodically to send suppliers details of withholdings that were deducted for a period. |
What can I do with this report? |
You can run this report for an individual supplier, all suppliers, or for a supplier type. You can also specify a date range for the withholding information. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Withholding Tax Letter
You can create a withholding tax letter with a list of withheld taxes to mail to your suppliers periodically.
You can run this report from the Scheduled Processes work area.
Before running the report, ensure withholding tax was calculated on all invoices subject to withholding for the period covered by the letter.
- Business Unit
-
Specify the business unit.
- From Date, To Date
-
Specify the date range for which withholding tax was created.
- From Supplier, To Supplier
-
Specify an inclusive supplier name range.
- Supplier Type
-
Select the type of supplier.
- Name of Sender
-
Enter the name of the person sending the letter.
- Title of Sender
-
Enter the title of the person sending the letter.
Parameters
Submit US 1096 and 1099 Reports
US 1096 Report: Explained
This topic includes details about the United States (US) 1096 Report.
Overview
The US 1096 Report summarizes each US 1099 form type that's transmitted on paper, as required by the US Internal Revenue Service, and generates the summary on a preformatted Internal Revenue Service form.
The following figure is an example of the report.

Key Insights
Before running this report, you must run the US 1099 Report.
Frequently Asked Questions
The following table lists frequently asked questions about the US 1096 Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Annually for US 1099 reporting. |
What can I do with this report? |
Send the report to the Internal Revenue Service. |
What type of report is this? |
Oracle Business Intelligence Publisher |
US 1096 Report
Generate a US 1096 form for each tax reporting entity on a preformatted Internal Revenue Service form. The form provides totals of the Forms 1099-MISC and 1099–NEC an employer submits for independent contractors and other nonemployees that the employer paid during the previous year.
You can run this report from the Scheduled Processes work area.
Before running this report, you must:
-
Run the US 1099 Report.
-
Insert and align the US 1096 forms in your printer.
-
The US 1096 Report generates two reports providing the totals for Forms 1099-MISC and 1099-NEC. After the process is completed, click on Republish. You can then select and print the Form 1096 for 1099-MISC and 1099-NEC returns separately.
- Business Unit
-
Specify a business unit.
- Tax Reporting Entity
-
Specify the name of the reporting entity.
- Payer Name Source
-
Select the source from which to obtain the payer name.
-
Address: Address line 1 on the Create Location page in Oracle Fusion Global Human Resources.
-
Location: Location name on the Create Location page.
-
Tax entity: Entity name on the Create Reporting Entity page.
-
Parameters
Report Output
The following table describes the information provided on the US 1096 Form.
Form Field | Description |
---|---|
Filer's name, street address, city or town, state or province, country, and postal code |
Name and address of your tax reporting entity. |
Employer identification number |
Tax identification number of the tax reporting entity. |
Total number of forms |
Total number of 1099-MISC forms that you created for US 1099 suppliers. |
Federal income tax withheld |
Total federal income tax withheld for all US 1099 suppliers. The amount is the sum of all paid distributions for US 1099 suppliers with an income tax type of MISC4. |
Total amount reported with this Form 1096 |
Total 1099-MISC payments. |
1099-MISC |
The type of form being filed. The application prints an X in the 1099-MISC box. |
US 1099 Invoice Exceptions Report: Explained
This topic includes details about the United States (US) 1099 Invoice Exceptions Report.
Overview
The US 1099 Invoice Exceptions Report lists paid invoice distributions with inaccurate or missing US 1099 income tax information.
The following figure is an example of the report.

Key Insights
Before running this report, account for the invoices.
Frequently Asked Questions
The following table lists frequently asked questions about the US 1099 Invoice Exceptions Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Before submitting the US 1099 Report. |
What can I do with this report? |
Identify invoice distributions that are exceptions to the US 1099 reports. |
What type of report is this? |
Oracle Business Intelligence Publisher |
US 1099 Invoice Exceptions Report
Review paid invoice distributions with inaccurate or missing US 1099 income tax information.
Before you run US 1099 reports, you should run this report for each tax entity to identify any exception invoice distributions. You can use the Update and Report Income Tax Details process to fix incorrect or missing income tax types or income tax regions. If the US 1099 status on a supplier is incorrect, you can correct it in on the Manage Suppliers page.
You can run this report from the Scheduled Processes work area.
Before running this report you must account for the invoices.
- Business Unit
-
Specify a business unit.
- Reporting Entity
-
Specify a reporting entity.
- Balancing Segment Source
-
Specify the account that determines the balancing segment for the invoice.
-
Invoices: Charge account on the invoice distribution.
-
Payments: Bank cash account used for the invoice payment.
-
- From Accounting Date, To Accounting Date
-
Specify an inclusive accounting date range.
Parameters
Report Results
The report is divided into the following sections:
-
Invoice Distribution Lines for 1099 Suppliers with No Income Tax Type
-
Invoice Distribution Lines for Non-1099 Suppliers with an Income Tax Type
-
Invoice Distribution Lines Missing Income Tax Type or with Invalid Income Tax Type: This section prints if combined filing is enabled.
-
1099 Suppliers with a Negative Income Tax Type Total: This section doesn't apply to withholding tax distributions with an income tax type of MISC4.
-
1099 Suppliers with Withholding Exceptions: This section shows suppliers with positive totals for income tax type MISC4.
US 1099 Supplier Exceptions Report: Explained
This topic includes details about the United States (US) 1099 Supplier Exceptions Report.
Overview
The US 1099 Supplier Exceptions Report lists suppliers with inaccurate or incomplete US 1099 income tax information.
The following figure is an example of the report.

Key Insights
Before running this report, account for the invoices.
Frequently Asked Questions
The following table lists frequently asked questions about the US 1099 Supplier Exceptions Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Before submitting the US 1099 Report. |
What can I do with this report? |
Review suppliers with inaccurate or incomplete US 1099 income tax information and correct them before generating the US 1099 forms. |
What type of report is this? |
Oracle Business Intelligence Publisher |
US 1099 Supplier Exceptions Report
Review suppliers with inaccurate or incomplete United States (US) 1099 income tax information. You can correct supplier exceptions on the Income Tax tab on the Manage Suppliers page.
Run the report from the Scheduled Processes work area.
Before running this report you must account for the invoices.
- Business Unit
-
Specify a business unit.
- Tax Reporting Entity
-
Specify the name of a tax reporting entity.
- From Accounting Date
-
You can limit the report to suppliers that received payments from the accounting date that you specify. This can be useful to ensure that your supplier information is accurate for a specific tax reporting year. If you don't enter a date, the report lists all suppliers with US 1099 exceptions, even if no payments were made to those suppliers.
- Balancing Segment Source
-
Specify the account to use to determine the balancing segment associated with the invoice.
-
Invoices: Charge account on the invoice distribution.
-
Payments: Bank cash account used for the invoice payment.
-
Parameters
US 1099 Report: Explained
This topic includes details about the United States (US) 1099 Report.
Overview
The US 1099 Report provides the total US 1099 miscellaneous payments for a US 1099 supplier and generates US 1099 forms for each tax reporting entity in an organization.
The following figure is an example of the report.

Key Insights
The report includes payments for invoice distributions that have one of the following 1099 MISC types in the Income Tax Type field: MISC types 1 through 14, except for MISC9, MISC11, and MISC12.
Frequently Asked Questions
The following table lists frequently asked questions about the US 1099 Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Annually for US 1099 reporting. |
What can I do with this report? |
|
What type of report is this? |
Oracle Business Intelligence Publisher |
US 1099 Report
Report on the total 1099-MISC payments for a particular United States (US) 1099 supplier. Generate US 1099 forms on preformatted forms from the Internal Revenue Service for each tax reporting entity in your organization.
In accordance with Internal Revenue Service rules, a 1099 form isn't generated unless you paid a supplier at least 600 USD for a calendar year. However, a US 1099 form is generated for a supplier if you do any of the following:
-
Pay a US 1099 supplier at least 10 USD in Royalties (Box 2)
-
Pay any fishing boat proceeds (Box 5)
-
Substitute payments in lieu of dividends or interest (Box 8)
-
Pay excess golden parachute payments (Box 13)
-
Pay gross proceeds to an attorney for legal services (Box 14)
A payment is reported only if the payment pays a distribution with one of the following 1099 MISC types in the Income Tax Type field: MISC types 1 through 14, except for MISC9, MISC11, and MISC12.
The report stops and reports an error if any of the following exceptions occur:
-
Nonstandard tax identification number (TIN)
-
Null Address Element
-
Null Foreign Address
-
Null State
-
Null TIN
You can run this report from the Manage Scheduled Processes page.
Before running the report:
-
Account for the invoices.
-
Submit the US 1099 Invoice Exceptions and the US 1099 Supplier Exceptions reports. Review the reports and make any necessary corrections.
-
Insert and align the US 1099 forms in your printer.
- Business Unit
-
Specify a business unit.
- From Accounting Date, To Accounting Date
-
Specify an inclusive accounting date range.
- Tax Reporting Entity
-
Specify the name of a tax reporting entity.
- Payer Phone
-
Enter the phone for the person in your organization who the payee should call for questions about the US 1099 form.
- Supplier Name
-
Enter a supplier name or leave blank to report all suppliers.
- Balancing Segment Source
-
Specify the account to use to determine the balancing segment associated with the invoice.
-
Invoices. Uses the charge account on the invoice distribution.
-
Payments. Uses the bank cash account from the invoice payment.
-
- Federal Reporting Limit
-
The minimum amount to report US 1099 payments to your suppliers.
- Order By
-
Select whether to order the report alphabetically by state code or by the reporting name of the supplier.
Parameters
US 1099 Forms (Comma Delimited Format): Explained
This topic includes details about the United States (US) 1099 Forms (Comma Delimited Format).
Overview
The US 1099 Forms (Comma Delimited Format) lists the total US 1099 miscellaneous tax type payments for US 1099 suppliers in a comma delimited format.
The following figure is an example of the report.

Key Insights
Before running the report, account for the invoices.
Frequently Asked Questions
The following table lists frequently asked questions about the US 1099 Forms (Comma Delimited Format).
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Annually for US 1099 reporting. |
What can I do with this report? |
Report on the total US 1099 miscellaneous payments for US 1099 suppliers. |
What type of report is this? |
Oracle Business Intelligence Publisher |
US 1099 Electronic Media Report: Explained
This topic includes details about the United States (US) 1099 Electronic Media Report.
Overview
The US 1099 Electronic Media Report generates summarized US 1099 information in electronic format, as required by the United States Internal Revenue Service.
The following figure is an example of the report.

Key Insights
Before running the report, account for the invoices.
Frequently Asked Questions
The following table lists frequently asked questions about the US 1099 Electronic Media Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Annually for US 1099 reporting. |
What can I do with this report? |
Send the output to the Internal Revenue Service. |
What type of report is this? |
Oracle Business Intelligence Publisher |
US 1099 Electronic Media Report
Generate summarized US 1099 information in electronic format as required by the Internal Revenue Service (IRS). The IRS requires electronic filing if you submit 250 or more records for your US 1099 reporting. You must report US 1099 information for each tax reporting entity that you define for your organization. The 250 record requirement is applicable to each tax reporting entity.
If you enable combined filing, the report produces K records for tax regions or states participating in the Combined Filing Program that have qualifying payments. The report also produces B records for suppliers with US 1099 payment amounts which equal or exceed the tax region's reporting limit in qualifying states.
You can run this report from the Manage Scheduled Processes page.
Before running this report:
-
Account for the invoices.
-
Ensure the tax reporting entity has a nine-digit tax identification number. Assign the taxpayer ID to the tax entity on the Create Reporting Entity page.
-
Submit and review the US 1099 Invoice Exceptions and US 1099 Supplier Exceptions reports. Make any necessary corrections.
- Business Unit
-
Specify a business unit.
- From Accounting Date, To Accounting Date
-
Specify an inclusive accounting date range.
- Tax Reporting Entity
-
Enter the name of a tax reporting entity.
- Payer Name Source
-
Specify the source from which to obtain the payer name for the US 1099 payments.
-
Address: Address line 1 for the address entered on the Create Location page in Oracle Fusion Global Human Resources.
-
Location: Location name entered on the Create Location page.
-
Tax entity: Entity name entered on the Create Reporting Entity page.
-
- Control Name
-
Enter your Payer Name Control. You can obtain the four-character Payer Name Control from the mailing label on the 1099 package most payers on record receive each December. The Payer Name Control is typically the first four characters of your tax reporting entity name.
- Control Code
-
Enter your five-digit Transmitter Control Code (TCC). You can file Form 4419 to receive a control code from the Internal Revenue Service.
- Test Submission
-
Select Yes if you're submitting a test US 1099 Electronic Media Report to the IRS.
- Media Type
-
-
Diskette: Formats your US 1099 data so that you can record it on a diskette.
-
Electronic file: Formats your US 1099 data so that you can transmit an electronic file to the IRS.
-
Magnetic tape: Formats your US 1099 data so that you can record it on magnetic tape.
-
- Last Year Filing
-
Select Yes if due to a merger, bankruptcy, and so on, this is the last year the tax reporting entity is filing.
- Foreign Corporation
-
Select Yes if your organization is a foreign tax reporting entity as recognized by the IRS.
- Balancing Segment Source
-
Specify the account to use to determine the balancing segment for the invoice.
-
Invoices: Charge account on the invoice distribution.
-
Payments: Bank cash account used for the invoice payment.
-
- File Indicator
-
Select a file indicator to include in the report:
-
Correction
-
Original
-
Replacement
-
- Original File
-
If you're submitting a replacement file, select one of the following options:
-
Electronic
-
Magnetic media
-
- Replacement Alphanumeric Character
-
Enter a value if the IRS Enterprise Computing Center returned your file due to processing problems and you're generating a replacement file. Enter the alphanumeric character that appears immediately following the TCC number on the Media Tracking Slip Form 9267 that was sent with your returned media.
You must enter a value if your File Indicator is Replacement and if the Original File and Media Type aren't both Electronic.
- Contact Name
-
Enter the name of the contact to include in the report.
- Contact Phone
-
Enter the phone of the contact to include in the report.
- Contact E-Mail
-
Enter the complete e-mail of the person in your enterprise to contact regarding electronic or magnetic files sent to the IRS. The e-mail is included in the report.
- Electronic File Name
-
If this is a replacement file, enter the file name provided by the IRS electronic Filing Information Return Electronically (FIRE) application, for example, 12345p01.DAT. If this is an original or correction file, leave this parameter blank.
- Federal Reporting Limit
-
Specify the minimum US 1099 payment amount to report.
Parameters
Report Results
If the report encounters a negative miscellaneous income tax type total, it stops and reports this in the log file.
If the report encounters any of the following exceptions, it stops and reports the error in the output.
Exception | Description |
---|---|
Nonstandard TIN |
The tax identification number is more or less than nine digits in length. |
No address element |
The US 1099 supplier has a tax reporting site that doesn't have an address, city, or postal code. |
No foreign address |
The foreign supplier has a tax reporting site that doesn't have an address or country. |
No state |
The supplier doesn't have a state abbreviation for its tax reporting site. |
No TIN |
The supplier doesn't have a tax identification number. |
US 1099 Payments Report: Explained
This topic includes details about the United States (US) 1099 Payments Report.
Overview
The US 1099 Payments Report lists payments made to US 1099 reportable suppliers.
The following figure is an example of the report.

Key Insights
Before running the report, account for the invoices.
Frequently Asked Questions
The following table lists frequently asked questions about the US 1099 Payments Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Annually for US 1099 reporting. |
What can I do with this report? |
Reconcile the report to the US 1099 forms or prepare additional reporting. |
What type of report is this? |
Oracle Business Intelligence Publisher |
US 1099 Payments Report
Review payments made to United States (US) 1099 reportable suppliers. Use the US 1099 Payment report to reconcile to your US 1099 forms, or to prepare additional reporting. For example, you can get information for states that don't participate in the combined filing program.
Run the report from the Scheduled Processes work area.
- Business Unit
-
Specify a business unit.
- Group By
-
Select a sorting method.
-
Income Tax Region: Sorts by income tax type within each region and displays the total paid for all income tax regions.
-
Income Tax Type: Sorts by income tax type and displays the total paid for all income tax types.
-
Supplier: Sorts by supplier name when run in summary. Sorts by tax reporting name when run in detail. Since the US 1099 Forms display tax reporting names, this setting can be useful for reconciling US 1099 reporting.
-
- Reporting Method
-
Select a reporting method.
-
Detail: Displays the invoice details that comprise the totals.
-
Summary: Displays the sum of the US 1099 payments.
-
- From Accounting Date, To Accounting Date
-
Specify the inclusive accounting date range.
- Supplier Name
-
Specify a supplier name if you selected to group by supplier. This can be useful if you have to provide supplier detail for the paid invoices on the US 1099 Form.
- Income Tax Region
-
Specify a tax region or leave the parameter blank to submit the report for all income tax regions.
- Tax Reporting Entity
-
Specify a tax reporting entity.
- Balancing Segment Source
-
Select the account to use to determine the balancing segment for the invoice.
-
Invoices: Uses the charge account on the invoice distribution.
-
Payments: Uses the bank cash account from the invoice payment.
-
- Federal Reportable Only
-
-
Yes: Includes suppliers designated as federally reportable only.
-
No: Doesn't restrict the report to only federally reportable suppliers.
-
- Meeting Minimum Levels Only
-
-
Yes: Includes US 1099 payment information only if payments meet federally reportable requirements and state requirements as defined on the Manage Tax Regions page.
-
No: Includes all US 1099 payment information.
-
How Income Tax Detail Updates Are Processed
The Income Tax Type and Income Tax Region fields are required for all invoice distributions of United States (US) federally reported suppliers for 1099 reporting. You can update or report on these fields by submitting the Update and Report Income Tax Details process on the Scheduled Processes page.
Submit the process to:
-
Correct inaccurate or missing values in the Income Tax Type or Income Tax Region fields on invoice distributions for US 1099 suppliers.
-
Correct invoice distributions for non-US 1099 suppliers that have income tax types assigned.
-
If a supplier isn't a US 1099 supplier, but has invoice distributions with income tax types, ensure that the supplier isn't federally reported. Also ensure that the Federal Income Tax Type field is blank on the Edit Supplier page. Then submit the process to correct the invoice distributions.
-
If a supplier isn't currently designated as a US 1099 supplier but should be, change the supplier to federally reported. In this case, the invoice distributions are accurate, so you don't have to submit the process. The US 1099 reports include invoices for the supplier.
-
Settings That Affect Income Tax Detail Updates
The following settings affect how the Update and Report Income Tax Details process updates income tax types and income tax regions on invoice distributions:
-
Supplier setup
-
Tax reporting options
-
Process parameters
This table describes the parameters for the Update and Report Income Tax Details process.
Parameter | Description |
---|---|
Business Unit |
Name of a business unit. |
Supplier Name |
Name of a supplier. Leave blank if the process is submitted for all US 1099 suppliers. |
From Accounting Date, To Accounting Date |
Inclusive accounting date range. |
Income Tax Type Action |
Action to perform on the Income Tax Type field of invoice distributions for the suppliers that you specify.
|
Income Tax Region Action |
Action to perform on the Income Tax Region field of invoice distributions for the suppliers that you specify.
|
Update Income Tax Region To |
Value to set for the Income Tax Region field for invoice distributions with incorrect or missing income tax regions. |
How Income Tax Detail Updates Are Processed
If you run the process in report mode, the Update Income Tax Details report lists the number of invoice distributions that require correction. These invoice distributions are updated when you run the process in update mode. Update mode also lists the number of invoice distributions that the process updates.
The following table describes the sections of the Update Income Tax Details report.
Section | Description |
---|---|
Income Tax Type |
Lists the supplier name and number of invoice distributions that don't have income tax types for US 1099 suppliers. Lists the invoice distributions that have income tax types for suppliers that aren't defined as US 1099 suppliers. |
Income Tax Region |
Lists the supplier name and number of invoice distributions with incorrect or missing income tax regions. |
Update and Report Income Tax Details
This topic includes details about the Update and Report Income Tax Details report.
Overview
The report updates or reports on income tax type or income tax region fields on invoice distributions for United States (US) 1099 reporting.
The following figure is an example of the report.

Key Insights
The report updates existing invoice distributions with income tax type and income tax region information from the supplier setup.
Frequently Asked Questions
The following table lists frequently asked questions about the Update and Report Income Tax Details report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Periodically to update the income tax details on invoice distributions that are used for US 1099 reporting. |
What can I do with this report? |
You can run this report to update income tax details using the supplier setup for US 1099 reporting. Income tax details might not be available when an invoice is created so you can use this report to update the data. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Close Payables Period
Considerations for Closing a Payables Period
You can close an Oracle Fusion Payables period after accounting entries are created for period transactions and you transferred the accounting entries to general ledger.
Consider performing the following closing activities:
-
Complete and approve all transactions and payment files.
-
Reconcile payments to bank statement activity.
-
Transfer all approved invoices and payments to the general ledger.
-
Submit the Unaccounted Transactions Sweep process.
-
Close the current Payables period.
-
Reconcile Payables activity for the period.
-
Open the next Payables period, run interface processes, and run reports.
Complete and Approve All Transactions and Payment Files
Ensure that all transactions are completed for the period you're closing.
-
Run the Import Payables Invoice process to process all interface records. If the import process rejects any records, review the import corrections spreadsheet and resubmit the import.
-
If invoice approval is enabled, approve all unapproved invoices. Depending on how your invoice options are set, validation or accounting may be required before you can approve the invoices.
-
Resolve holds on invoices.
-
Validate the invoices.
-
Optionally submit a payment process request.
-
Complete all payment files.
-
Submit the Invoice and Payment Registers.
-
Run the Update Matured Bills Payable Status process.
-
Run the Apply Missing Conversion Rates process.
Reconcile Payments to Bank Statement Activity
Reconcile payments to bank statement activity for the period in Oracle Fusion Cash Management. Ensure that payments are cleared if you account for payments at clearing.
Transfer All Approved Invoices and Payments to the General Ledger
Transfer approved invoices and payments to the general ledger.
-
To account and transfer any unaccounted transactions to General Ledger, run create accounting with the Transfer to General Ledger option set to Yes.
-
Run the Post Journal Entries to General Ledger process to transfer to General Ledger transactions accounted in final mode, but that weren't transferred.
-
Review the output generated by the Create Accounting and Post Journal Entries to General Ledger processes.
Submit the Unaccounted Transactions Sweep Process
Run the Payables Unaccounted Transactions Sweep process to transfer unaccounted transactions from one accounting period to another. If your accounting practices permit it, use this process to change the accounting date of the transactions to the next open period.
For example, you have invoices for which you can't resolve holds before the close. Your accounting practices allow you to change invoice distribution accounting dates. You can submit the process to change invoice distribution accounting dates to the first day of the next open period. You can then close the current period.
The Unaccounted Transactions Sweep process doesn't roll forward accounted transactions, or accounted transactions with errors. To create successful accounting entries for accounted transactions with errors, correct any accounting errors and resubmit the Create Accounting Process. The process transfers unaccounted transactions to the period you specify by updating the accounting dates to the first day of the new period. You can then close the current accounting period in Payables.
Close the Current Payables Period
Close the current Payables period and review the Payables Period Close Exceptions report.
Reconcile Payables Activity for the Period
Reconcile Payables activity using the following reports:
-
Payables Trial Balance report
-
Payables Posted Invoice Register
-
Payables Posted Payment Register
-
Payables to General Ledger Reconciliation report
-
Payables Open Items Revaluation report
Open the Next Payables Period, Run Interface Processes, and Run Reports
Open the next Payables period. Run Payables interface processes, including Create Mass Additions and Transfer Costs to Cost Management, to transfer information to other products.
Run the following transaction tax, withholding tax, and key indicators reports:
-
Tax Reconciliation by Taxable Account
-
Tax Audit Trial report
-
Use Tax Liability report
-
Financial Tax Register
-
Payables Tax by Ledger Extract report
-
Withholding Tax reports
-
Withholding Tax by Tax Authority report
-
Withholding Tax Letter
-
Key Indicators report
Considerations For Setting Up for Payables to General Ledger Reconciliation
Periodically you reconcile the transactions in your accounts payable application, both before and after you post to the general ledger. The Payables to General Ledger Reconciliation preparation process and report help simplify reconciliation and reduce the amount of manual reconciling activity required.
The automated activities in the reconciliation process function according to your Oracle Fusion Financials setup. A review of some of these setups can help improve the overall reconciliation process.
Consider these points when setting up the Oracle Fusion Payables to general ledger reconciliation.
-
Reconciling by Business Unit or Ledger
-
Assigning the Financial Category
-
Setting the Reconciliation Data Purge Frequency Profile Option
-
Configuring User Security
Reconciling by Business Unit or Ledger
If you implicitly map primary balancing segment values to business units, you can reconcile based on business unit. Reconciling by business unit allows employees from different business units to balance their respective accounting activity.
If you don't implicitly map primary balancing segment values to business units, you must reconcile based on ledger. In this case, you must have access to all business units associated with the ledger to perform a thorough reconciliation. You must also reconcile by ledger if you centralize payment processing using the service provider model.
Assigning the Financial Category
You must assign the financial category of Accounts Payable to all of your liability natural account values. You perform this task on the Manage Values page for the value set associated with the natural account segment of your chart of accounts.
After you assign the category, you can leave the Account parameter blank when you run the Prepare Payables to General Ledger Reconciliation process. The process includes all accounts that have a financial category of Accounts Payable in the ledger. You can alternatively enter specific natural account values to limit the report to reconciling only a subset of the payables accounts in the ledger.
Setting the Reconciliation Data Purge Frequency Profile Option
Use the Reconciliation Data Purge Frequencyprofile option to specify the number of days to keep reconciliation data. You may want to keep the data for comparison purposes.
When you run the Prepare Payables to General Ledger Reconciliation process, the process refers to the value of the Reconciliation Data Purge Frequency profile option. Any reconciliation data requests older than the number of days specified in the profile option are purged from the tables.
For example, you set the profile to 30 days and submit the preparation process on January 1. If you submit the process again on January 29, the data isn't purged. However, the data is purged if you submit the process on February 1.
Configuring User Security
Typically General Ledger users are secured by data access sets. Data access sets use primary balancing segment values to secure access to ledgers, ledger sets, and portions of ledgers. Payables users are secured by business units.
For the Payables to General Ledger Reconciliation report:
-
General Ledger users can see general ledger data for the balancing segment values in their data access set. General Ledger users can also see the Payables or Oracle Fusion Subledger Accounting data for all business units linked to the ledger.
-
Payables users can see the Payables and Subledger Accounting data for business units in their security definition. Payables users can also see general ledger data for all balancing segment values in the ledger.
The data roles for the General Ledger or Payables job roles can affect the reconciliation report. If data roles grant access to specific business units for General Ledger users or specific data access sets for Payables users, the report only includes:
-
For General Ledger users, the Payables or Subledger Accounting data for those business units in the ledger to which the user has access.
-
For Payables users, general ledger data for those balancing segment values included in the data access set to which the user has access.
If business units and balancing segment values are implicitly mapped, the report should work properly. Users can filter the report for the balancing segment values that are mapped to the business units to which they have access.
If business units and balancing segment values aren't intentionally or implicitly mapped, the Payables to General Ledger Reconciliation report could display the following unintended results:
-
For General Ledger users, the report includes general ledger data for all balancing segment values in the data access set. Payables and Subledger Accounting data is limited to the business units to which a user is granted access.
-
For Payables users, one possible outcome is that the report doesn't include any general ledger data. Another outcome is that the report includes general ledger data that isn't properly mapped to the Payables or Subledger Accounting data for the business unit.
You can resolve this issue. Remove the access granted to specific business units for the General Ledger job roles, and the specific data access sets for the Payables job roles.
Prepare Payables to General Ledger Reconciliation
Run the Prepare Payables to General Ledger Reconciliation process to select data for the Summary section of the Payables to General Ledger Reconciliation Report. The process must run successfully for the most current summary information and before you can run the Payables to General Ledger Reconciliation Report.
- Request Name
-
Enter a descriptive name. Consider a name that indicates the accounting period, date, and time, especially if you're planning to run multiple processes.
- Ledger
-
The ledgers available for selection are based on your assigned security.
- Business Unit
-
Use this parameter to reconcile by a specific organization.
Note:-
You must explicitly map business units to balancing segment values. If not, you must reconcile by ledger.
-
Don't specify a business unit if you implemented centralized payment processing using the service provider model. The output from the process may be incomplete for the purposes of reconciliation.
-
- Accounting Period
-
You can select either open or closed accounting periods.
- Account
-
If you have multiple payables accounts, you can limit the process to specific accounts. The natural account segment values for the accounts must have a Financial Category of Accounts Payable to be included in the reconciliation report. If the Financial Category isn't assigned to any natural account values in the chart of accounts, the process fails.
- Include Intercompany Transactions
-
You can include or exclude intercompany transactions. To reconcile only intercompany transactions, you can restrict the account range to include only intercompany accounts.
- Include Bills Payable
-
If you select Yes, include the bills payable accounts in the Account parameter if they differ from the accounts payable accounts. You must select Yes if the bills payable liability account is the same as the regular liability account.
Note: You may want to exclude bills payable if the bills payable account isn't a liability account.
Prepare Payables to General Ledger Reconciliation Parameters
Payables to Ledger Reconciliation Report: Explained
This topic includes details about the Payables to Ledger Reconciliation Report.
Overview
The Payables to Ledger Reconciliation Report lists the journals posted to the general ledger for open balances. The report facilitates the reconciliation of accounting and transactional data recorded in Payables and Oracle Fusion Subledger Accounting.
The following figure is an example of the report.

Key Insights
The interactive reporting capability of the Payables to Ledger Reconciliation Report provides both summarized and detailed reconciling data for review. The Summary report lets you view payables and accounting beginning and ending balances, summarized activity for the period, and how the activity was accounted.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables to Ledger Reconciliation Report.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Payables to Ledger Reconciliation. |
What are the pre-requisites for running this report? |
Run the Prepare Payables to General Ledger Reconciliation process from the Scheduled Processes work area. This generates the data that is used for the Payables to Ledger Reconciliation report. |
Who uses this report? |
Financial Manager |
When do I use this report? |
During the Payables period close process. |
What can I do with this report? |
You can reconcile payables data to the general ledger. |
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Subledger Accounting - Payables Summary Reconciliation Real Time subject area.
Considerations For Payables to General Ledger Reconciliation Report
Use the Payables to General Ledger Reconciliation report to facilitate the reconciliation of payables data to the general ledger. The interactive reporting capability of the Payables to General Ledger Reconciliation report provides both summarized and detailed reconciling data for review.
The summary shows payables and accounting beginning and ending balances, summarized activity for the period, and how the activity was accounted. You can drill down on any amount in the summary Difference column to see the Differences Detail report for that item. The Differences Detail report displays the real-time details that make up the summary balance and indicates potential causes for differences between actual and reconciling amounts.
To view the report, you must select a ledger and request name, which is the name from the Prepare Payables to General Ledger Reconciliation process.
Consider these points when using the Payables to General Ledger Reconciliation report.
-
Differences Between Transactional and Accounted Amounts
-
Differences Between Summary and Detail Amounts
-
Differences Between the Reconciliation Report and Other Payables Reports
-
Differences Due to Rounding
-
Variances Due to Transactions not Validated
Differences Between Transactional and Accounted Amounts
Ideally the payables transactional amounts and the accounted amounts on the report summary should be the same. The Payables Begin Balance accounting amount should agree with the Payables Trial Balance report for the last day of the previous period. The Payables End Balance accounting amount should agree with the Payables Trial Balance report for the last day of the period being reconciled.
Any differences that you find require further investigation and correction. Common reasons for differences between transactional amounts and accounted amounts include:
-
Transactions that aren't accounted.
-
Transactions with subledger accounts that fall outside the account range of the report.
-
Transaction amounts that don't agree with the subledger journal line amounts.
-
Journals posted to the subledger or general ledger that didn't come from Payables.
-
Subledger journals that aren't transferred or posted to general ledger.
After finding and correcting discrepancies, you must rerun the Prepare Payables to General Ledger Reconciliation process and review the reconciliation report summary.
Differences Between Summary and Detail Amounts
The Non-Payables Begin Balance on the report summary is that portion of the general ledger liability account beginning balance that didn't originate from Payables transactions. You can drill down from the beginning balance amount to the general ledger journal lines. The accounting date for the journal lines falls within the current fiscal year, but prior to the period for the reconciliation report.
The source for these journal lines is typically not Payables. However, you may see manual subledger journal entries with the Payables source entered directly in the subledger, but not necessarily linked to a Payables transaction. Most of these entries represent adjustments.
Manual subledger journals created during the current reconciling period display on the report summary in the Other Accounting amount. These journals become part of the Non-Payables Begin Balance amount in subsequent periods. Manual general ledger journals that may affect payables accounts and are created directly in the general ledger display in the Non-Payables Activity amount.
Summary amounts might not reflect totals on detail pages for one of the following reasons:
-
Data was modified after the Prepare Payables to General Ledger Reconciliation process was run for a given accounting period. For example, transactions or accounting was created between the time the process was run and the moment you drill down from summary to detail.
-
Security rules in your setup may restrict you from viewing data from certain business units or segment values. Oracle recommends that appropriate security be given to users for all business units and accounting flexfield segment values that each user is responsible for reconciling.
-
If you're downloading a large amount of data and plan to perform a number of data manipulations, use the CSV format. If you're downloading data for reference purposes only, use the Excel format.
Differences Between the Reconciliation Report and Other Payables Reports
Data on the Payables to General Ledger Reconciliation report might differ from the following Payables reports:
-
Payables Aging Report, Payables Invoice Register, Payables Payment Register: You can't exclude intercompany transactions from the aging report or the registers. If you run the reconciliation report and exclude intercompany transactions, or show only intercompany transactions, then the reports display incompatible data.
-
Payables Aging Report: The reconciliation report displays payables balances for the first and last date of a period. You can run the aging report for the current date only.
Differences Due to Rounding
Fully paid invoices could have rounding differences. The sum of the entered amounts for the invoice distributions and the sum of the entered amounts for the invoice payment might not match.
The total accounted amounts of the invoice and payment liabilities for a fully paid invoice always match. Rounding differences between the original invoice liability amount and the sum of the payment liabilities are automatically written off. The write-off occurs when the final payment, or prepayment application, is accounted.
However, because the payables amounts are taken from the invoice distributions and invoice payments, rounding differences can appear on the report summary. These differences are included in the Payment Variance amount in the Payables Amount column on the report summary.
Variances Due to Transactions not Validated
On the report summary, the Payables Begin Balance and Payables End Balance amounts include validated transactions only. Unvalidated transactions are included in the Payables Variance amount. For the Invoice Approval and Invoice Account Coding in-application notifications, use the 'Edit Distributions' option in the Actions menu to edit the distributions.
For example, if the current period has 200 USD of unvalidated invoice transactions, the report displays the following:
-
Payables Begin Balance = 10,000 USD
-
Invoices = 1,200 USD
-
Payables Variance = 200 USD
-
Payables End Balance = 11,000 USD
Payables Trial Balance Report: Explained
This topic includes details about the Payables Trial Balance Report.
Overview
The Payables Trial Balance Report lists and subtotals, by supplier and liability account, all unpaid and partially paid invoices that Oracle Fusion Payables transferred to the general ledger.
The following figure is an example of the report.

Key Insights
The report identifies the accounts payable balance at period end and provides the invoice details that comprise that balance.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Trial Balance Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
During the period close process. |
What can I do with this report? |
Cross check the accounts payable liability balance with the accounts payable liability balance in the general ledger. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Trial Balance Report
Use the trial balance to verify that total accounts payable liabilities in Oracle Fusion Payables equal those that were transferred to the general ledger. Reconcile posted invoices and payments to ensure the net amount posted to the general ledger accurately reflects the change in the accounts payable balance.
To reconcile accounts payable activity:
-
Add the posted invoices for the current period (total invoice amount from the Payables Posted Invoice Register).
-
Subtract the posted payments for the current period (total cash plus discounts from the Payables Posted Payments Register) from the prior period trial balance.
This amount should equal the balance for the current period Payables Trial Balance report.
For example, you're closing the April accounting period and you posted the final invoice and payment batches to the general ledger. To reconcile accounts payable activity for April, perform the following calculation: March Payables Trial Balance + April Payables Posted Invoice Register - April Payables Posted Payment Register = April Payables Trial Balance.
You can run this report from the Scheduled Processes work area.
Before running this report:
-
When defining natural account values, assign the financial category of Payables to all accounts to include in the Payables Trial Balance. To report bills payable payments that were issued, but not yet negotiable, assign the financial category of Payables to the bills payable account as well.
-
Account and post invoice and payment activity to the general ledger.
- Ledger
-
Specify the ledger. You can select a primary or secondary ledger, or a reporting currency ledger.
Note: The original invoice amount is only provided when you run the report for the primary ledger. Base amounts for transactions are stored only in the currency of the primary ledger. - Business Unit
-
Specify the business unit or leave blank to include all business units.
- Liability Account As-of Date
-
Specify the date for the liability account.
- Party Name
-
Enter a party to limit the report to a single supplier or party.
- Account From
-
Select the accounts.
- Negative Balances Only
-
Select Yes to limit the report to suppliers with negative balances.
- Include Bills Payable
-
Select whether to include bills payable invoices on the report.
Parameters
Understanding the Report
The trial balance lists and subtotals, by supplier and liability account, all unpaid and partially paid invoices that were transferred to the general ledger. Credit liability amounts are reported as positive amounts because they represent outstanding balances. Debit liability amounts decrease the outstanding balance.
- Account
-
Lists all accounts included in the specified range that:
-
Have a financial category of Payables
-
Have an open balance on the liability account date
-
- Open Balance
-
Adds the credits to the liability account, such as invoices and refunds, and subtracts the debits, such as credit memos and payments. A positive number corresponds to an outstanding balance and a negative number represents an overpayment to the supplier.
You can select an open balance to drill down to the account detail.
Report Headings for Account Summary
- Party
-
Lists the suppliers with open balances.
- Open Balance
-
Adds the credits to the liability account, such as invoices and refunds, and subtracts the debits, such as credit memos and payments. A positive number corresponds to an outstanding balance and a negative number represents an overpayment to a supplier.
You can select an open balance to drill down to the party detail.
Selected Report Headings for Account Detail
- Transaction Type
-
Lists the type of transaction, such as Standard Invoice, Debit Memo, Credit Memo, Prepayment, Withholding Invoice, and Payment Request.
- Payment Status
-
Lists the payment status, such as Unpaid, Partially Paid, and Canceled.
Note: A canceled invoice is reported if the invoice was canceled after the specified liability account date, but still outstanding on that date. - Original Amount
-
If you submit the report for the primary ledger, lists the amount originally booked to the liability account when the invoice was entered. If you use automatic offsets, only the amount allocated to the referenced account combination displays on the report.
- Remaining Amount
-
Nets credits and debits booked to the liability account for the invoice, with an accounting date before or on the liability account date.
Selected Report Headings for Party Detail
Payables Posted Invoice Register: Explained
This topic includes details about the Payables Posted Invoice Register.
Overview
The Payables Posted Invoice Register lists accounting lines for invoices that have been transferred to the general ledger.
The following figures are an example of one page from the report.


Key Insights
The reports lists the invoices that were accounted for a period and is used as a part of period close activities.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Posted Invoice Register.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Period Close. |
Who uses this report? |
Financial Manager |
When do I use this report? |
During the period close process. |
What can I do with this report? |
Use this report, along with the following reports, to reconcile balances between Oracle Fusion Payables and your general ledger:
|
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the following subject areas:
-
Payables Invoices - Transactions Real Time
-
Payables Invoices - Prepayment Applications Real Time
Payables Posted Invoice Register
Use the Payables Posted Invoice Register to review accounting lines for invoices that were transferred to the general ledger. You can also use this report and the following reports to reconcile balances between Oracle Fusion Payables and the general ledger:
-
Payables Posted Payment Register
-
Payables Trial Balance Report
-
Payables to General Ledger Reconciliation Report
To make the output easier to read, you can run each of these reports for a single liability account. For example, you're using automatic offsets and the liability for your invoices is allocated across multiple primary balancing segment values. You can use the Account parameter to limit your reports to a single balancing organization.
You can run this report from the Reports and Analytics work area.
Before running the report you must:
-
Transfer accounting entries to the general ledger.
-
Enable the Import Journal References option for the Payables source on the Manage Journal Sources page.
- Ledger
-
Specify the name of a ledger.
- Business Unit
-
Specify a business unit.
- Account
-
Specify a liability account or leave blank to submit the report for all liability accounts.
- Accounting Date
-
Specify an invoice accounting date range.
- Entered Distribution Amount
-
Specify an entered invoice distribution amount range.
- Include Zero Amount Lines
-
Select to include subledger journal entry lines with a zero amount.
Parameters
- Summary
-
Summarizes the report by account.
- Detail
-
Includes invoice details and displays invoices charged to liability accounts.
Report View
Report Output
You can manage the section headers and columns on the report. For example, change the column sorting, or make a section header a column or parameter.
Payables Posted Payment Register: Explained
This topic includes details about the Payables Posted Payment Register.
Overview
The Payables Posted Payments Register lists accounting lines for payments that have been transferred to the general ledger.
The following figures provide an example of one page from the report.


Key Insights
The reports lists the payments that were accounted for a period and is used as a part of period close activities.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Posted Payment Register.
FAQ | Answer |
---|---|
How do I find this report? |
From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Period Close. |
Who uses this report? |
Financial Manager |
When do I use this report? |
During the period close process. |
What can I do with this report? |
Use this report, along with the following reports, to reconcile balances between Oracle Fusion Payables and your general ledger:
|
What type of report is this? |
Oracle Transactional Business Intelligence |
Related Subject Areas
This report uses the Payables Payments - Disbursement Real Time subject area.
Payables Posted Payment Register
Use the Payables Posted Payment Register to review accounting lines for payments that were transferred to the general ledger. You can also use this report and the following reports to reconcile balances between Oracle Fusion Payables and the general ledger:
-
Payables Posted Invoice Register
-
Payables Trial Balance Report
-
Payables to General Ledger Reconciliation Report
To make the output easier to read, you can run each of these reports for a single liability account. For example, you're using automatic offsets and the liability for your invoices is allocated across multiple primary balancing segment values. You can use the Account parameter to limit your reports to a single balancing organization.
You can run this report from the Reports and Analytics work area.
Before running the report you must:
-
Transfer accounting entries to the general ledger.
-
Enable the Import Journal References option for the Payables source on the Manage Journal Sources page.
- Ledger
-
Specify the name of a ledger.
- Business Unit
-
Specify a business unit.
- Account
-
Select one or more liability accounts or leave blank to submit the report for all liability accounts.
- Include Zero Amount Lines
-
Select to include subledger journal entry lines with a zero amount.
- Accounting Date
-
Specify an accounting date range.
- Payment Amount
-
Specify a payment amount range.
- Bank Account
-
Select a bank account used for payments.
Parameters
- Summary
-
Lists totals for each account and excludes payment details.
- Detail
-
Includes payment details and displays the payments that relieve the specified liability accounts.
Report View
Report Output
You can manage the section headers and columns on the report. For example, change the column sorting, or make a section header a column or parameter.
Payables Period Close Exceptions Report: Explained
This topic includes details about the Payables Period Close Exceptions Report.
Overview
The Payables Period Close Exceptions Report lists exceptions that prevent the Payables accounting period from closing.
The following figure is an example of the report.

Key Insights
The report provides details of the transactions that prevent the Payables period from closing.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Period Close Exceptions Report.
FAQ | Answer |
---|---|
How do I find this report? |
The Payables Period Close process automatically generates this report. You can also run the report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
During the period close process. |
What can I do with this report? |
You can run this report to determine the list of transactions that prevent the period from closing. You also have the option of sweeping the transactions to the next period. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Period Close Exceptions Report
Use this report to review the list of exceptions that are preventing you from closing an Oracle Fusion Payables accounting period.
The Payables Period Close process automatically generates this report. You can also run the report from the Scheduled Processes work area.
- Ledger
-
Specify a ledger.
- From Accounting Date, To Accounting Date
-
Specify an inclusive accounting date range.
- Period Name
-
Enter the name of a period.
Parameters
Report Results
This table describes each section on the report.
Section | Description |
---|---|
Summary |
Summarizes the exceptions for each business unit within the ledger, and indicates whether you have access to that business unit. Business unit access can affect your ability to close the period or resolve exceptions. The types of exceptions reported are:
|
Details |
Provides details, such as supplier, invoice number, and accounting date, for each type of exception. |
Corrective actions |
Lists suggested actions to resolve each type of exception. |
Payables Open Items Revaluation Report: Explained
This topic includes details about the Payables Open Items Revaluation Report.
Overview
The 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.
The following figure is an example of the report.

Key Insights
The report identifies the list of open invoices that may have to be adjusted for currency conversion rate differences.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Open Items Revaluation Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
Before the period close. |
What can I do with this report? |
Use the report to revalue open item balances. |
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Open Items Revaluation Report
Use the Payables Open Items Revaluation report to revalue open items, accounting for changes in the value of liabilities due to foreign currency rate changes. Open items include invoices, prepayments, credit memos, and debit memos that are unpaid as of the last date of the revaluation period you specify.
The report determines the manual adjustment to your general ledger balance for the difference between the original and revalued balances. The report calculates the difference for each liability account with a total for each balancing segment. You should reverse the general ledger entry at the beginning of the next period to synchronize payables and general ledger balances.
To provide a complete listing of your liabilities, the report also includes open items in the ledger currency. Those items use a revaluation rate of 1.
You can run this report from the Scheduled Processes work area.
Before running the report, if you use a:
-
Period rate, define rates on the Currency Rates Manager page.
-
A daily rate, define daily rates for the rate type, whether the rate type is predefined or user-defined.
- Business Unit
-
Specify a business unit.
- Revaluation Period
-
Select a period to revalue. The report includes open items with dates up to the last date of this period.
- Rate Type
-
Select a type of revaluation rate.
-
Period: Uses the rate at the end of the revaluation period.
-
Daily: Uses the daily rate for the Daily Rate Type and Daily Rate Date parameters.
-
- Daily Rate Type
-
If you select a Rate Type of Daily, then select the daily rate type.
- Daily Rate Date
-
If you select a Rate Type of Daily, then select the daily rate date.
- From Balancing Segment, To Balancing Segment
-
Enter a balancing segment range to include in the report.
- Transferred to General Ledger Only
-
-
Yes: Includes only the transactions that are transferred to the general ledger.
-
No: Includes all transactions.
-
- Cleared Only
-
-
Yes: Includes only payments that are cleared when determining open balances.
-
No: Includes all payments when determining open balances.
-
Parameters
Understanding the Report
The report has sections for each unique combination of balancing segment and liability account. Within each section, the report lists the open items for each supplier.
This table describes the amounts on the report.
Amount | Description |
---|---|
Ledger Unpaid |
The value of open items before revaluation, which you can reconcile with your general ledger balances. |
Revalued |
The value for each open item revalued using the revaluation rate. Some countries, such as the United States, require that you report this total. |
Revalued Unpaid |
The higher of the two item values both before and after revaluation. Some countries require this total, such as Germany, where the higher market value of open items has to be determined. |
Payables Unaccounted Transactions and Sweep Report: Explained
This topic includes details about the Payables Unaccounted Transactions and Sweep Report.
Overview
The Payables Unaccounted Transactions and Sweep Report lists invoices and payments that weren't accounted for a period or date range.
The following figure is an example of the report.

Key Insights
The report provides the option of sweeping the unaccounted transactions to the next period.
Frequently Asked Questions
The following table lists frequently asked questions about the Payables Unaccounted Transactions and Sweep Report.
FAQ | Answer |
---|---|
How do I find this report? |
Schedule and run this report from the Scheduled Processes work area on the Navigator menu. |
Who uses this report? |
Financial Manager |
When do I use this report? |
During the period close process. |
What can I do with this report? |
|
What type of report is this? |
Oracle Business Intelligence Publisher |
Payables Unaccounted Transactions and Sweep Report
Identify and review all unaccounted invoice and payment transactions and the reasons why they can't be accounted. You can also specify to sweep unaccounted transactions to another period.
You can run this report from the Scheduled Processes work area.
Before running this report:
-
Validate invoices to reduce the number of unvalidated invoices on the report.
-
Create payables accounting entries. The report then shows only problem transactions that couldn't be accounted. You can correct the problems, and resubmit the create accounting process.
-
If you use bills payables, submit the Update Matured Bills Payable Status process. The process updates the status of any bills payable with a maturity date on or before today's date.
- Report Level
-
Select Ledger or Business unit.
- Report Context
-
The values for this parameter are based on the Report Level parameter.
-
If the Report Level is Business unit, select a business unit.
-
If the Report Level is Ledger, select a ledger.
-
- From Accounting Date, To Accounting Date
-
To run the report for a particular date range, enter both the first and last dates in the range.
- Period
-
To run the report for a single period, enter the period name.
- Sweep Now
-
Specify whether to sweep unaccounted transactions to another period.
-
Yes: Sweeps unaccounted transactions.
-
No: Only reports exceptions.
-
- Sweep to Period
-
If the Sweep Now parameter is set to Yes, specify an open or future period. The accounting date for unaccounted transactions is updated to the first date of the period that you specify.
Parameters
Report Results
All amounts are reported in the entered currency.
The report has the following sections:
-
Unaccounted Invoices: Lists the supplier, supplier number, invoice number, invoice date, entered currency, invoice amount, purchase order number (if an invoice has matching-related holds), and the exception.
-
Unaccounted Payments: Lists the supplier, supplier number, payment number, payment date, payment currency, payment amount, and exception.
This table describes some of the invoice and payment exceptions.
Exception | Description |
---|---|
Distribution combination invalid |
The distribution combination on the invoice isn't valid. |
Distribution variance |
The total of the invoice distributions doesn't equal the invoice amount. |
Other hold names |
The invoice has a hold that prevents accounting. |
No rate |
The payment doesn't have a conversion rate. |
Not validated |
The invoice or distribution line isn't validated. |
Unaccounted |
The invoice or distribution line is unaccounted. |
Withholding tax |
The invoice distribution has a withholding tax group and tax can't be withheld, so a withholding tax hold was applied to the invoice. Several conditions can cause this hold including the following:
|
FAQs for Close Payables Period
Why did the export download only some of the rows on the Payables to Ledger Reconciliation report drill-down page?
The export downloads only the rows that display on the page.
For example, if the Invoices drill-down page has 1,000 rows and the page displays 25 rows at a time, the export to Excel downloads 25 rows.
Oracle Business Intelligence Enterprise Edition has a setting that controls the number of rows that display on a page. For more information on manually configuring settings for data in views, see the Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
How can I report invoices for merged suppliers on the Payables to Ledger Reconciliation report?
Set the Third-Party Merge Accounting option to Replace third party on the Manage Subledger Accounting Options page. Otherwise, an accounting variance could appear on the Payables to Ledger Reconciliation report for journal lines that are attributed to merged suppliers.