| layout | default |
|---|---|
| title | AP Period Close Exceptions | Oracle EBS SQL Report |
| description | Based on Oracle standard Period Close Exceptions Report Source: Period Close Exceptions Report (XML) Short Name: APXPCER DB package: apperiodclosepkg |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, BI Publisher, Enginatics, R12 only, Period, Close, Exceptions, ap_invoices_all, ap_invoice_distributions_all, ap_suppliers |
| permalink | /AP%20Period%20Close%20Exceptions/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Based on Oracle standard Period Close Exceptions Report Source: Period Close Exceptions Report (XML) Short Name: APXPCER DB package: ap_period_close_pkg
Ledger, Operating Unit, Exception Type, Period Name, From Accounting Date, To Accounting Date, Supplier
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
BI Publisher, Enginatics, R12 only
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.
| 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/ |
- 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