Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162

R12 only

19 reports

	Description
AR Adjustment Register	Application: Receivables Source: Adjustment Register Short Name: ARRXARPB The report has now been enhanced to allow multiple accessible Ledgers or Operating Units to be selected in the Reporting Context parameter. Additionally, the Reporting Context parameter has been made optional. Leaving it null will allow the report to be run across all accessible Ledgers or Operating Units.	Receivables Enginatics, R12 only
AR Aging	The AR Aging report allows users to review information about their open receivables items at a specified point in time (the As of Date). The report will show the aging of the open receivables items based on the selected aging bucket. - The report includes detailed (Transaction Level) or summary (Customer Level) information about customers current and past due invoices, debit memos, and chargebacks. - Optionally the report can include details of credit memos, on-account credits, unidentified payments, on-account and unapplied cash amounts, and receipts at risk. - Optionally the report allows… full description	Receivables Enginatics, R12 only
AR Applied Receipts	Application: Receivables Description: Receivables Applied Receipts Register Provided Templates: Default: Detail - Detail Listing with no Pivot Summarization Pivot: Summary by Apply Date - Summary by Balancing Segment, Receipt Currency, Apply Date Pivot: Summary by Batch - Summary by Balancing Segment, Receipt Currency, Batch Pivot: Summary by Customer Name - Summary by Balancing Segment, Receipt Currency, Customer with drilldown to details Pivot: Summary by Debit Account - Summary by Balancing Segment, Account Segment, Debit Account, Receipt Currency Pivot: Summary by GL Date - Summary by… full description	Receivables Enginatics, R12 only
AR Customer Credit Snapshot	Application: Receivables Source: Customer Credit Snapshot (XML) Short Name: ARXCCS_XML DB package: AR_ARXCCS_XMLP_PKG	Receivables Enginatics, R12 only
AR Customers and Sites	Master data report of customer master data including address, sites, site uses, payment terms, Salesperson, price list and other profile information. Payment terms are reported from each of their own sources: Account Profile Payment Term and Site Profile Payment Term from the customer profile at account and site level, and Site Use Payment Term from the site use Order Management terms. When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No.	Receivables Enginatics, R12 only
AR European Sales Listing	Summary report listing sales by country and currency code, with transaction amount / currency and accounted amount/ currency	Receivables Enginatics, R12 only
AR Open Balances Revaluation	Report: AR Open Balances Revaluation Report Application: Receivables Source: AR Open Balances Revaluation Report Short Name: AROBRR	Receivables Enginatics, R12 only
AR Open Items Revaluation	Imported from BI Publisher Description: Open Items Revaluation Report Application: Receivables Source: Open Items Revaluation Report (XML) Short Name: ARXINREV_XML DB package: AR_ARXINREV_XMLP_PKG	Receivables BI Publisher, Enginatics, R12 only
AR Receipt Register	Application: Receivables Description: Receivables Receipt Register Provided Templates: Default: Detail - Detail Listing with no Pivot Summarization Pivot: Summary by Receipt Date - Summary by Balancing Segment, Receipt Currency, Receipt Date Pivot: Summary by Receipt Status - Summary by Balancing Segment, Receipt Status Pivot: Summary by Batch - Summary by Balancing Segment, Receipt Currency, Batch Pivot: Summary by Customer Name - Summary by Balancing Segment, Receipt Currency, Customer Pivot: Summary by Debit Account - Summary by Balancing Segment, Account Segment, Debit Account, Receipt… full description	Receivables Enginatics, R12 only
AR Sales Journal By Customer	Imported from BI Publisher Description: Sales Journal By Customer Application: Receivables Source: Sales Journal By Customer (XML) Short Name: RAXGLA_XML DB package: AR_RAXGLA_XMLP_PKG When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, HSN Length Warning, CGST Rate, SGST Rate, IGST Rate, CESS Rate.	Receivables Enginatics, R12 only
AR Transaction Register	Application: Receivables Source: Transaction Register Short Name: ARRXINVR The report has now been enhanced to allow multiple accessible Ledgers or Operating Units to be selected in the Reporting Context parameter. Additionally, the Reporting Context parameter has been made optional. Leaving it null will allow the report to be run across all accessible Ledgers or Operating Units. When India Localization is installed, the following GST columns are also included: IGST Amount, IGST Recoverable, IGST Non-Recoverable, CGST Amount, CGST Recoverable, CGST Non-Recoverable, SGST Amount, SGST… full description	Receivables Enginatics, R12 only
AR to GL Reconciliation	Imported from Concurrent Program Application: Receivables Source: AR to GL Reconciliation Report Short Name: ARGLRECR DB package:	Receivables Enginatics, R12 only
AR AutoAccounting Upload	Creates and updates the Receivables AutoAccounting definitions - the Excel equivalent of the Automatic Accounting form (Setup > Transactions > AutoAccounting). Each row is one segment of the chart of accounts of an AutoAccounting type, with the operating unit and type repeated on every row. Enter either a Table Name, from which AutoAccounting takes the segment value, or a Constant. Each type is saved as a whole: after the upload, every enabled segment of the chart of accounts must have a table name or constant, and a dependent segment must use the table name of its parent segment or a… full description	Receivables Enginatics, R12 only, Upload
AR Credit Memo Application Upload	Applies open on account credit memos to invoices and debit memos, and unapplies existing credit memo applications - the Applications action of the Transactions workbench (ar_cm_api_pub). The download lists the operating unit's open credit memos (Apply To Invoice empty) and their existing active applications (one row per application). To apply, enter Apply To Invoice on an open credit memo row. To unapply, set Unapply to Yes on an application row. An existing application cannot be changed in place: unapply it, then enter the new application on the credit memo's open row.	Receivables Enginatics, R12 only, Upload
AR Customer Statement	Application: Receivables Source: Customer Statement Short Name: ARSTMTRPT DB package: AR_TP_STMT_PKG When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code.	Receivables Enginatics, R12 only
AR HSBC FAA Asset File (France)	Extracts completed Receivables invoices and credit memos in the HSBC FACTORING FRANCE FAA file format, for invoice discounting. One 532 character record per document. The report is implemented from the HSBC specification document "HFF - Invoice Discounting - Asset File IT Protocol.pdf" dated 09/09/2025, and its output has been validated against both the field table in that document and the sample file supplied with it. The 31 zones are, in order, each followed by a semicolon: File type FAA (3), Seller account number (5), File creation date YYYYMMDDHHMM (12), Debtor's Seller Identifier (15),… full description	Receivables Enginatics, R12 only
AR Refund Upload	Bulk-refund customer credit balances in AR. Each row refunds either an open credit memo or the unapplied/on-account portion of a customer cash receipt by applying it against the operating unit's Credit Memo Refund Receivables Activity, via AR_CM_APPLICATION_PUB.Activity_application or AR_RECEIPT_API_PUB.Activity_application. WHEN TO USE EACH REFUND SOURCE - Credit Memo - the customer has an open credit memo (e.g. overpayment recorded as a CM) and wants the money back. - Unapplied Receipt - the customer paid more than they owed, or paid against the account with no specific invoice. The… full description	Receivables Enginatics, R12 only, Upload
AR Transaction Update Upload	Updates the post completion header fields of Receivables transactions in the same way as the Transactions workbench: comments, special instructions, print option, purchase order details, salesperson, remit to address, late charges exemption, ship via, FOB, waybill, cross reference and the transaction descriptive flexfield. The transaction is identified by Operating Unit and Transaction Number. A hidden transaction id links downloaded rows exactly; pasted rows resolve by number, and a number existing under more than one transaction source is rejected with a request to download the transaction… full description	Receivables Enginatics, R12 only, Upload
AR Unaccounted Transaction Sweep	Imported from BI Publisher Application: Receivables Source: Unaccounted Transaction Sweep Short Name: ARTRXSWP DB package: ar_unaccounted_trx_sweep	Receivables BI Publisher, Enginatics, R12 only

Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

Also found in SQL, tables and columns