AP Period Close Exceptions – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Based on Oracle standard Period Close Exceptions Report Source: Period Close Exceptions Report (XML) Short Name: APXPCER DB package: ap_period_close_pkg
Report Parameters
Ledger, Operating Unit, Exception Type, Period Name, From Accounting Date, To Accounting Date, Supplier
Oracle EBS Tables Used
ap_invoices_all, ap_invoice_distributions_all, ap_suppliers, hz_parties, hr_all_organization_units, gl_ledgers, fnd_currencies, ap_invoice_lines_all, ap_checks_all, ap_payment_history_all, ce_bank_accounts, ce_bank_acct_uses_all, ap_system_parameters_all, ap_inv_selection_criteria_all, ap_selected_invoices_all, ap_lookup_codes, fnd_lookups, iby_pay_service_requests, xla_ae_headers, xla_events, xla_event_types_tl, xla_transaction_entities
Report Categories
BI Publisher, Enginatics, R12 only
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_Period_Close_Exceptions.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/ap-period-close-exceptions/ |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics