Oracle EBS Payables Reports

31 ready-to-run SQL reports for Oracle E-Business Suite Payables, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Payables tables in these reports are ap_invoices_all, gl_ledgers, ap_suppliers, ap_supplier_sites_all, hr_all_organization_units_vl, gl_code_combinations_kfv.

Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.

Payables SQL Reports

Report Description
AP 1099 Payments 1099 Payments report showing payments made to 1099 reportable suppliers. This is the Blitz Report equivalent of the Oracle standard 1099 Payments Report…
AP Accounted Invoice Aging Application: Payables Report: Accounts Payable Accounted Invoice Aging Report Pre-requisite: XLATRIALBALANCES should be populated before running this report…
AP Cash Requirement Detail cash requirement report showing all unpaid or partially paid amounts, where the invoice is neither on hold nor cancelled, including invoice currency…
AP Distribution Set Listing Payables distribution sets and their lines with account, percentage, income tax type, tax classification and project details, one row per distribution set…
AP Expense Policy Violations Expense report policy violations showing violation type, allowable amount, exceeded amount and expense line details for each violation. Based on Oracle…
AP Expenses Detail AP expense report listing corresponding AP invoices with status, line details, expense type and expense justification. Including projects task related…
AP Intercompany Invoice Details AP Intercompany Invoice Details When India Localization is installed, the following GST columns are also included: CGST Amount, SGST Amount, IGST Amount…
AP Invoice Approval Status Imported from Concurrent Program Application: Payables Source: Invoice Approval Status Short Name: APXAPRST When India Localization is installed, the following…
AP Invoice Audit Listing Imported Oracle standard ‘Invoice Audit Listing’ report Application: Payables Source: Invoice Audit Listing Short Name: APXINLST When India Localization is…
AP Invoice Payments Supplier invoice payment details. There can be multiple payments per invoice and one document/check can be used to pay different payments and invoices. To…
AP Invoice Payments 11g 11g-compatible version of AP Invoice Payments. Supplier invoice payment details. There can be multiple payments per invoice and one document/check can be used…
AP Invoice and Payment Audit by Voucher Number Lists every voucher number of the Payables invoice and payment document sequences with its status: Entered, Deleted (the number was issued, but the invoice or…
AP Invoice on Hold Based on Oracle standard Invoice on Hold report Source: Invoice on Hold Report (XML) Short Name: APXINROHXML When India Localization is installed, the…
AP Invoices and Lines Detail Invoice Aging report with line item details and amounts Parameter explanation: - Invoice on Hold (LOV: Yes/No) Default Value = Null (Hold Status not…
AP Invoices and Lines 11i Detail Invoice Aging report with line item details and amounts. The Approval Status column and parameter show and filter the status of the invoice in the…
AP Invoices with PO, Intercompany and SLA Details AP Invoices with PO, Intercompany and SLA Details When India Localization is installed, the following GST columns are also included: GST Registration No, GST…
AP Matched and Modified Receipts Imported from BI Publisher Description: Matched and Modified Receipts Report Application: Payables Source: Matched and Modified Receipts Report (XML) - Not…
AP Negative Supplier Balance Application: Payables Source: Accounts Payable Negative Supplier Balance Short Name: APXNVBAL DB package: XLATBAPREPORTPVT
AP Open Balances Revaluation Description: AP Open Balances Revaluation Report This report is in the same format as the AP Open Balances Revaluation Report which is no longer supported and…
AP Open Items Revaluation Imported from BI Publisher Description: Open Items Revaluation Report Application: Payables Source: Open Items Revaluation Report (XML) Short Name: APOPITRN DB…
AP Period Close Exceptions Based on Oracle standard Period Close Exceptions Report Source: Period Close Exceptions Report (XML) Short Name: APXPCER DB package: apperiodclosepkg
AP Posted Invoice Register Application: Payables Description: Payables Posted Invoice Register This report provides equivalent functionality to the Oracle standard Payables Posted…
AP Posted Payment Register Application: Payables Description: Payables Posted Payment Register This report provides equivalent functionality to the Oracle standard Payables Posted…
AP Prepayments Status Prepayments with an unapplied amount and the open, that is unpaid or partially paid, invoices, credit and debit memos of the suppliers holding such a…
AP Supplier Statement Application: Payables Source: Supplier Statement Short Name: APTPSTMT DB package: APTPSTMTPKG When India Localization is installed, the following GST columns…
AP Suppliers AP suppliers (po vendors) including supplier sites, contact and bank account information on vendor and site level When India Localization is installed, the…
AP Suppliers 11i AP suppliers (po vendors) including supplier sites and contact information Duplicate Match restricts the output to suppliers sharing a match key with at least…
AP Suppliers Revenue Summary AP suppliers (po vendors) revenue summary across different operating units
AP Suppliers Revenue by Period AP invoice amount per supplier and invoice currency, with one column per GL period from Period From to Period To. An invoice is counted in the period of its…
AP Trial Balance Application: Payables Source: Accounts Payable Trial Balance Short Name: APTBRPT DB package: XLATBAPREPORTPVT For scheduling the report to run periodically…
AP Trial Balance Report Definitions Accounts Payable Trial Balance Report Definitions

← All Oracle EBS modules

© Enginatics GmbH