Blitz Report™ Library

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

146 reports

DescriptionDownload
AP Accounts Payable Trial Balance
Imported from BI Publisher Application: Payables Source: Accounts Payable Trial Balance Short Name: APTBRPT DB package: XLA_TB_AP_REPORT_PVT
 Payables BI Publisher XML
AP Bank Account Listing
Imported from Concurrent Program Application: Payables Source: Bank Account Listing Short Name: APXBABAL
 Payables Concurrent Program XML
AP Bank Account Listing- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Bank Account Listing Application: Payables Source: Bank Account Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXBABAL_XML DB package: AP_APXBABAL_XMLP_PKG
 Payables BI Publisher XML
AP Bank Charges - draft
Application: Payables Source: Bank Charges Report (XML) - Not Supported: Reserved For Future Use Short Name: APXBCRPT_XML DB package: AP_APXBCRPT_XMLP_PKG
 Payables BI Publisher XML
AP Batch Control Report by Batch Name- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Batch Control Report by Batch Name Application: Payables Source: Batch Control Report by Batch Name (XML) - Not Supported: Reserved For Future Use Short Name: APXBCOBN_XML DB package: AP_APXBCOBN_XMLP_PKG
 Payables BI Publisher XML
AP Batch Control Report by Entered By- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Batch Control Report by Entered By Application: Payables Source: Batch Control Report by Entered By (XML) - Not Supported: Reserved For Future Use Short Name: APXBCOEB_XML DB package: AP_APXBCOEB_XMLP_PKG
 Payables BI Publisher XML
AP Bills Payable Maturity Date
Application: Payables Source: Bills Payable Maturity Date Report (XML) Short Name: APXFPMDR_XML DB package: AP_APXFPMDR_XMLP_PKG
 Payables BI Publisher XML
AP Cash Requirement - draft
Application: Payables Source: Cash Requirement Report (XML) - Not Supported: Reserved For Future Use Short Name: APXCRRCR_XML DB package: AP_APXCRRCR_XMLP_PKG
 Payables BI Publisher XML
AP Check Payments to Suppliers
Application: Payables Source: AP Check Payments to Suppliers Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG
 Payables BI Publisher XML
AP Check Payments to Suppliers (1)
Imported from BI Publisher Application: Payables Source: AP Check Payments to Suppliers Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG
 Payables BI Publisher XML
AP Check Payments to Suppliers (2)
Imported from BI Publisher Application: Payables Source: AP Check Payments to Suppliers Short Name: APCHECKPAYSUPRPT DB package: AP_CHECK_PAYMT_SUPP_RPT_PKG
 Payables BI Publisher XML
AP Consolidated Invoices
AP invoices and distributions from the HDFC consolidated view, with the full set of invoice, distribution, payment, travel/expense, account, cost centre, branch, banking, TDS, WCT, ESI and GST attributes. Migrated from the Oracle Discoverer worksheet built on HDFC.HDFC_CONSOLIDATED_VW. Invoice Line Number, Available Amount, CESS Amount, Total Tax Amount and TDS Rate are summed for each unique combination of all other columns, and the Discoverer Year/Quarter/Month/Day date buckets for Invoice GL Date, Created Date, Prepaid Invoice Date, Hold Date, Release Date, GL Date and Payment Date are…
full description		 Payables Custom Reports HDFC XML
AP Credit Card Historical Transactions Management- Not Supported: Reserved For Future Use
Imported from BI Publisher Application: Payables Source: Credit Card Historical Transactions Management (XML) - Not Supported: Reserved For Future Use Short Name: APXCCPUT_XML DB package: AP_APXCCPUT_XMLP_PKG
 Payables BI Publisher XML
AP Credit Card Outstanding Transactions Management (Details)- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Credit Card Outstanding Transactions Management (Details) Application: Payables Source: Credit Card Outstanding Transactions Management (Details) (XML) - Not Supported: Reserved For Future Use Short Name: APXCCOUT_XML DB package: AP_APXCCOUT_XMLP_PKG
 Payables BI Publisher XML
AP Credit Card Outstanding Transactions Summary Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Credit Card Outstanding Transactions Summary Report Application: Payables Source: Credit Card Outstanding Transactions Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: APXCCOUT_SUMMARY_XML DB package: AP_APXCCOUT_XMLP_PKG
 Payables BI Publisher XML
AP Credit Memo Matching
Application: Payables Source: Credit Memo Matching Report Short Name: APXCMINV
 Payables XML
AP Credit Memo Matching - draft
Application: Payables Source: Credit Memo Matching Report (XML) - Not Supported: Reserved For Future Use Short Name: APXCMINV_XML DB package: AP_APXCMINV_XMLP_PKG
 Payables BI Publisher XML
AP Discounts Available
Imported from BI Publisher Description: Discounts Available Report Application: Payables Source: Discounts Available Report (XML) Short Name: APXINDIA_XML DB package: AP_APXINDIA_XMLP_PKG
 Payables BI Publisher XML
AP Discounts Taken and Lost Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Discounts Taken and Lost Report Application: Payables Source: Discounts Taken and Lost Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINDTL_XML DB package: AP_APXINDTL_XMLP_PKG
 Payables BI Publisher XML
AP Distribution Set Listing- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Distribution Set Listing Application: Payables Source: Distribution Set Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXGDGDL_XML DB package: AP_APXGDGDL_XMLP_PKG
 Payables BI Publisher XML
AP Employee Listing- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Employee Listing Application: Payables Source: Employee Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXEMELR_XML DB package: AP_APXEMELR_XMLP_PKG
 Payables BI Publisher XML
AP Employee Update Program- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Employee Update Program Application: Payables Source: Employee Update Program (XML) - Not Supported: Reserved For Future Use Short Name: APXHRUPD_XML DB package: AP_APXHRUPD_XMLP_PKG
 Payables BI Publisher XML
AP Expense Report Template Listing- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Expense Report Template Listing Application: Payables Source: Expense Report Template Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXXPXPL_XML DB package: AP_APXXPXPL_XMLP_PKG
 Payables BI Publisher XML
AP Input Tax Group Listing
Imported from Concurrent Program Description: Tax Group Listing Application: Payables Source: AP Input Tax Group Listing Short Name: AP_ARXTTGL
 Payables Concurrent Program XML
AP Invalid PO Supplier Notice- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Invalid PO Supplier Notice Application: Payables Source: Invalid PO Supplier Notice (XML) - Not Supported: Reserved For Future Use Short Name: APXVDLET_XML DB package: AP_APXVDLET_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Aging Report Test Payables Training Purposes XML
AP Invoice Aging Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Invoice Aging Report Application: Payables Source: Invoice Aging Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINAGE_XML DB package: AP_APXINAGE_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Approval Workflow - draft
Application: Payables Source: Invoice Approval Workflow (XML) - Not Supported: Reserved For Future Use Short Name: APXIAWRE_XML DB package: AP_APXIAWRE_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Audit Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Invoice Audit Report Application: Payables Source: Invoice Audit Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINDUP_XML DB package: AP_APXINDUP_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Audit by Voucher Number- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Invoice Audit by Voucher Number Application: Payables Source: Invoice Audit by Voucher Number (XML) - Not Supported: Reserved For Future Use Short Name: APXINVAD_XML DB package: AP_APXINVAD_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Distribution Account LOV Check
For a given Operating Unit and concatenated GL Account String, this Blitz Report will show the attributes used in restricting the account in the AP Invoice Upload Distribution Account LOV.
 Payables XML
AP Invoice Errors
This sql query help you to get Payables invoice interface rejection records. You can get complete details for the rejected records using this sql query. It helps you to understand the invoice rejection reason in the AP invoice interface and can work on this. We cannot get those details in oracle apps but using this sql query we can get the rejected records with the detailed reason for the rejection. This is quite useful in the Payables Invoice interface.
 Payables XML
AP Invoice History Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Invoice History Report Application: Payables Source: Invoice History Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINHIS_XML DB package: AP_APXINHIS_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Register - draft
Application: Payables Source: Invoice Register (XML) - Not Supported: Reserved For Future Use Short Name: APXINRIR_XML DB package: AP_APXINRIR_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Transaction Check Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Japanese Invoice Transaction Check Report Application: Payables Source: Invoice Transaction Check Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINVTC_XML DB package: AP_APXINVTC_XMLP_PKG
 Payables BI Publisher XML
AP Invoice Validation- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Invoice Validation Application: Payables Source: Invoice Validation (XML) - Not Supported: Reserved For Future Use Short Name: APPRVL_XML DB package: AP_APXAPRVL_XMLP_PKG
 Payables BI Publisher XML
AP Invoices and Lines - Test
Detail Invoice Aging report with line item details and amounts Parameter explanation: - Invoice on Hold (LOV: Yes/No) Default Value = Null (Hold Status not considered as per current behaviour) Yes - Only Invoices that currently have an unreleased hold will be retrieved No - Only Invoices that do not currently have an unreleased hold will be retrieved - Hold Name (LOV: AP Hold Names) Default Value Null If specified - only Invoices that currently have an unreleased hold of the specified name will be retrieved Hold column explanation: - Holds - a list of the current unreleased…
full description		 Payables XML
AP Key Indicators Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Key Indicators Report Application: Payables Source: Key Indicators Report (XML) - Not Supported: Reserved For Future Use Short Name: APXKIRKI_XML DB package: AP_APXKIRKI_XMLP_PKG
 Payables BI Publisher XML
AP Matching Detail Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Matching Detail Report Application: Payables Source: Matching Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: APXMTDTR_XML DB package: AP_APXMTDTR_XMLP_PKG
 Payables BI Publisher XML
AP Matching Hold Agent Notice- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Matching Hold Agent Notice Application: Payables Source: Matching Hold Agent Notice (XML) - Not Supported: Reserved For Future Use Short Name: APXMHLET_XML DB package: AP_APXMHLET_XMLP_PKG
 Payables BI Publisher XML
AP Matching Hold Detail Report- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Matching Hold Detail Report Application: Payables Source: Matching Hold Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: APXINMHD_XML DB package: AP_APXINMHD_XMLP_PKG
 Payables BI Publisher XML
AP Missing Supplier Contact Address Associations Payables XML
AP Never Validated Invoices
AP invoices and distributions that were never validated, sourced from the HDFC combined view, with the full set of invoice, distribution, account, cost centre, branch, banking, requestor, expense, TDS and GST attributes. Migrated from the Oracle Discoverer worksheet built on APPS.HDFC_AP_NEVER_VALID_COMBINED_V. Available Amount and Distribution Line Number are summed for each unique combination of all other columns, and the Discoverer Day/Month/Quarter/Year date buckets for Distribution Accounting Date, GL Date and Terms Date are retained. Enter a GL Date to report on a single accounting…
full description		 Payables Custom Reports HDFC XML
AP Open Balances Revaluation (1)
Imported from BI Publisher Application: Payables Source: AP Open Balances Revaluation Report Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG
 Payables BI Publisher XML
AP Open Balances Revaluation (2)
Imported from BI Publisher Application: Payables Source: AP Open Balances Revaluation Report Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG
 Payables BI Publisher XML
AP Open Balances Revaluation (3)
Imported from BI Publisher Application: Payables Source: AP Open Balances Revaluation Report Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG
 Payables BI Publisher XML
AP Open Balances Revaluation (4)
Imported from BI Publisher Application: Payables Source: AP Open Balances Revaluation Report Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG
 Payables BI Publisher XML
AP Open Balances Revaluation (5)
Imported from BI Publisher Application: Payables Source: AP Open Balances Revaluation Report Short Name: APOBRR DB package: AP_OPEN_BAL_REV_RPT_PKG
 Payables BI Publisher XML
AP Payables Lookup Listing- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Payables Lookup Listing Application: Payables Source: Payables Lookup Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG
 Payables BI Publisher XML
AP Payables Open Interface Import- Not Supported: Reserved For Future Use
Imported from BI Publisher Description: Payables Open Interface Import Application: Payables Source: Payables Open Interface Import (XML) - Not Supported: Reserved For Future Use Short Name: APXIIMPT_XML DB package: AP_APXIIMPT_XMLP_PKG
 Payables BI Publisher XML