AP Invoice Payments 11g – Oracle EBS SQL Report

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

Overview

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 to pay different payments and invoices. To allow reconciling payment with invoices and checks, invoice and check level amounts are shown on the last payment record only and are blank for multiple/duplicate records.

Report Parameters

Ledger, Operating Unit, Payment Date From, Payment Date To, Accounting Date From, Accounting Date To, Supplier, Supplier Number, Supplier Site, Invoice Number, Check Number, Check State

Oracle EBS Tables Used

iby_payment_profiles, gl_je_batches

Report Categories

Enginatics

CE Bank Statement and Reconciliation, AP Invoice Payments, CE Cleared Transactions, AR Miscellaneous Receipts, AR Customers and Sites, AR Transactions and Payments, AR Customer Upload, IBY Payment Process Request Details

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
Blitz Report™ XML Import AP_Invoice_Payments_11g.xml
Full SQL on Enginatics www.enginatics.com/reports/ap-invoice-payments-11g/

© 2026 Enginatics