Oracle Fusion ERP · AP
Payables reports
Every Payables report — logic, source tables, parameterized SQL, the data dictionary, a star-schema data model, and extraction patterns. 59 reports.
Payables data model
The module's conformed star — the fact every Payables report rolls up to, surrounded by the dimensions shared across the module. See the full Payables data model → — all star schemas, the model dictionary, use cases, and every bicc View Object this module exposes.
●— fact → dimension join
Reports
AP
Oracle Fusion AP Aging Report
How much the company owes suppliers, how overdue each balance is, and which suppliers and invoices drive the p…
AP
AP Invoice Detail Report with Tax Details
Invoice-level Payables detail with the tax and withholding breakdown on each line — recoverable and non-recove…
AP
AP Disbursements Report
Every payment Payables disbursed in a period — check, EFT, and wire — by supplier, payment method, and bank ac…
AP
AP Invoice Detail Report
Invoice-level detail for Payables — header and distribution lines, the account each line hit, holds, and match…
AP
AP Vendor Financing Batch Creation Inquiry Report
An inquiry into vendor-financing (supply-chain finance) batches — which approved invoices were offered for ear…
AP
Active Employee Details Report
Active employee detail — each employee's organization, supervisor, work email, and default expense account — t…
AP
India Creditors Ledger Report
The India statutory creditors ledger — every transaction with each supplier (invoices, payments, debit and cre…
AP
India eTDS Data Report
The India eTDS data set — tax deducted at source by section, deductee, and challan, formatted for the quarterl…
AP
Input Goods and Services Tax Declaration Vietnam
Vietnam's input VAT declaration — recoverable input GST/VAT on purchases by supplier, invoice, and rate, forma…
AP
Key Indicators Payment Report
Payables payment activity summarized into operating indicators — payment count and value, average days to pay,…
AP
SLA Payables Account Analysis Report
An account analysis for Payables built from Subledger Accounting — every AP accounting line behind each GL acc…
AP
Supplier Balance by Account Report
The open Payables balance owed to each supplier, broken out by the liability account it sits in, as of a date …
AP
Supplier Detail Report
The supplier master in detail — sites, bank accounts, payment methods, tax registration, and active status — s…
AP
Supplier Site Inactivation Report
Supplier sites that are candidates for inactivation — no transactions in a defined period, or already inactive…
AP
Supplier Subledger Balance by Account Report
The Payables subledger balance owed to each supplier, reconciled to the GL liability account it posts to — sup…
AP
Vietnam Payment Voucher Report
The Vietnamese statutory payment voucher (Phiếu chi) — each payment in the local voucher format with payee, ac…
AP
Withholding Tax by Supplier Report
Withholding tax calculated and deducted per supplier — the taxable base, rate, and amount withheld by tax type…
AP
Payables to Ledger Reconciliation Report
Does the AP subledger tie to the GL liability account, and if not, which documents explain the gap?…
AP
Payables Invoice Aging Report
How much supplier liability is open, how is it aged, and which suppliers concentrate the risk?…
AP
Payables Invoice Register
Provides detailed information about invoices entered in Payables.…
AP
Payables Invoice Audit Listing
Lists invoices for review and audit based on a specified amount for a given supplier and range of invoice crea…
AP
Payables Invoice Audit by Voucher Number Listing
Lists invoices with assigned sequential voucher numbers for audit.…
AP
Payables Credit Memo Matching Report
Lists credit and debit memos for suppliers along with the invoices to which they are matched.…
AP
Payables Key Indicators Report
Generates transaction activity with the current number of suppliers, invoices, payments, and matching holds.…
AP
Payables Matched and Modified Receipts Report
Identifies receipts that were modified after invoice matching.…
AP
Payables Matching Detail Report
Provides details of how an invoice, purchase order, or receipt was matched.…
AP
Payables Matching Hold Detail Report
Provides payables and purchasing detail for invoices with matching holds and matching hold releases.…
AP
Payables Negative Supplier Balance Report
Lists suppliers with negative balances along with the invoices and credit or debit memo transactions that make…
AP
Supplier Balance Aging Report
Lists unpaid supplier invoices according to specified aging periods.…
AP
Import Payables Invoices Report
Reports the results of the process that creates Payables invoices from data in the open interface tables.…
AP
Payables Cash Requirement Report
Forecasts immediate cash needs for invoice payments.…
AP
Payables Payment Register
Provides detailed information about payments made in Payables.…
AP
Payables Discounts Taken and Lost Report
Identifies payments where a discount was taken and payments where a discount was available but not taken.…
AP
Payables Selected Installments Report
Lists invoice installments selected in a payment process request, to assess how well the selection criteria pi…
AP
Payment Audit by Voucher Number Report
Lists payments with assigned sequential voucher numbers for audit.…
AP
Payables Payment Requests Import Report
Lists payment requests for invoices that are imported, or rejected with rejection reasons.…
AP
Escheated Payments Listing Report
Lists escheated payments along with the suppliers' details.…
AP
Payables Open Items Revaluation Report
Lists changes in the value of open items such as unpaid invoices and credit memos due to conversion-rate fluct…
AP
Payables Period Close Exceptions Report
Lists exceptions that prevent the Payables accounting period from closing.…
AP
Payables Posted Invoice Register
Lists accounting lines for invoices transferred to the general ledger.…
AP
Payables Posted Payment Register
Lists accounting lines for payments transferred to the general ledger.…
AP
Payables Trial Balance Report
Lists and subtotals by supplier and liability account all unpaid and partially paid invoices that Payables tra…
AP
Payables Unaccounted Transactions and Sweep Report
Lists invoices and payments that weren't accounted for a period or date range.…
AP
Prepayment Remittance Notice
Lists prepayments that were applied to supplier invoices.…
AP
Payables Withholding Tax Report
Lists withholding for a supplier; the invoice view reviews detailed withholding by invoice and the supplier vi…
AP
Payables Withholding Tax by Tax Authority Report
Lists withholding for tax codes assigned to a tax authority.…
AP
Payables Withholding Tax Letter
Creates a periodic withholding tax letter to mail to a supplier, summarizing withholding by tax type and rate …
AP
US 1099 Report
Reports total US 1099 miscellaneous payments for a 1099 supplier and generates 1099 forms for each tax reporti…
AP
US 1099 Payments Report
Lists payments made to US 1099 suppliers.…
AP
US 1099 Invoice Exceptions Report
Lists paid invoice distributions with inaccurate or missing US 1099 income tax information.…
AP
US 1099 Supplier Exceptions Report
Lists suppliers with inaccurate or incomplete US 1099 income tax information.…
AP
US 1096 Report
Summarizes each US 1099 form type transmitted on paper, on a preformatted IRS form, as required by the IRS.…
AP
US 1099 Electronic Media Report
Generates summarized US 1099 information in the electronic format required by the IRS.…
AP
Update and Report Income Tax Details
Updates or reports income tax type and income tax region on invoice distributions used for US 1099 reporting.…
AP
Netting Settlement Report
Lists the transactions netted for a specific netting settlement, in PDF format.…
AP
Netting Settlement Listing
Lists the transactions netted for a specific netting settlement, in spreadsheet format.…
AP
Netting Settlement Letter
Prints a letter detailing the Receivables and Payables transactions in a netting settlement.…
AP
Netting Reversal Letter
Prints a letter detailing the Receivables and Payables transactions reversed in a netting settlement.…
AP
Update Matured Bills Payable Status
Reports the results of the process that updates the status of matured bills payable from issued to negotiable.…