AP Posted Invoice Register – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Application: Payables Description: Payables Posted Invoice Register

This report provides equivalent functionality to the Oracle standard Payables Posted Invoice Register report.

For scheduling the report to run periodically, use the relative period from/to offset parameters. These are the relative period offsets to the current period, so when the current period changes, the included periods will also automatically be updated when the report is re-run.

Templates

Additional data fields are available. Run the report without a template to see full list available fields

Source: Payables Posted Invoice Register Short Name: APXPOINV DB package: XLA_JELINES_RPT_PKG

Also requires custom package XXEN_XLA package to be installed to initialize the hidden parameters removed from the report to simplify scheduling of the report.

Report Parameters

Operating Unit, Ledger/Ledger Set, Period From, Period To, Journal Source, Include Zero Amount Lines, Account Flexfield From, Account Flexfield To, GL Batch Name, Include Manual Entries from GL, Relative Period From, Relative Period To

Oracle EBS Tables Used

ap_holds_all, &lp_template_table, xla_ae_headers, xla_transaction_entities, xla_events, ap_invoices_all

Report Categories

Enginatics, R12 only

AP Invoice on Hold 11i, AP Invoice on Hold, AP Invoices and Lines

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output None
Blitz Report™ XML Import AP_Posted_Invoice_Register.xml
Full SQL on Enginatics www.enginatics.com/reports/ap-posted-invoice-register/

Case Study & Technical Analysis: AP Posted Invoice Register

1. Executive Summary

Business Problem

The “Posting” process (transferring data from Payables to the General Ledger) is the final step in the AP cycle. Finance teams need to verify that all approved invoices have been successfully transferred to the GL to ensure month-end completeness. Standard Oracle reports for this are often rigid, making it hard to reconcile specific GL batches back to the individual invoices that comprise them.

Solution Overview

The AP Posted Invoice Register is a flexible, high-performance alternative to the standard APXPOINV report. It lists all AP invoices that have been posted to the General Ledger within a specific period. Crucially, it includes the GL Batch Name and Header ID, allowing users to seamlessly cross-reference a line in a GL Journal back to the specific AP Invoice Number and Supplier.

Key Benefits

2. Technical Analysis

Core Tables and Views

This report is heavily anchored in the Subledger Accounting (SLA) schema:

SQL Logic and Data Flow

The query starts from the “Accounted” perspective rather than the “Transactional” perspective.

Integration Points

3. Functional Capabilities

Parameters & Filtering

Performance & Optimization

4. FAQ

Q: Why does this report show different amounts than the “Invoice Register”? A: The Invoice Register shows entered amounts. This report shows accounted amounts. Differences can arise due to exchange rate variances, tax calculations, or SLA rules that modify the accounting derivation.

Q: Can I see unposted invoices here? A: No, this report is specifically for Posted items. Use the “Unaccounted Transactions” report for items stuck in AP.

Q: What is the “Pivot” template? A: The Pivot template summarizes the data by Account and Currency, mimicking the “Summarize Report = Yes” option in the standard Oracle report, but with the ability to drill down in Excel.

© 2026 Enginatics