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).

BI Publisher Engineering

1,745 reports

	Description
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	BI Publisher, Enginatics, R12 only
CE Bank Statement Import Execution	Application: Cash Management Source: Bank Statement Import Execution Report Short Name: CEIMPERR DB package: CE_CEXINERR_XMLP_PKG	BI Publisher, Enginatics, R12 only
CST Supply Chain Indented Bills of Material Cost	This report is based on the (static) Oracle Supply Chain Indented Bills of Material Cost Report and merely sums up the available information from the Cost Type. It does not do a Cost Rollup and as a result, the "Extended Cost" column might not add up to the total item cost for the assembly especially if changes have been made to the bills of material, routing or item costs, since the last cost rollup. If this is the case, run a Supply Chain Cost Rollup in Pending or some other cost type (such as Current) for reporting purposes, to synchronize the cost information and then use this report,… full description	BI Publisher, Enginatics, R12 only
ENG Engineering Change Orders	Engineering change orders (ECOs) with one row per revised item: the ECO header with its type, status, approval status, priority, reason, requestor and dates, and the revised item with its new revision, effectivity, implementation and cancellation dates, use-up item and material disposition. An ECO without revised items is listed once with blank revised item columns. Change types are those based on the Change Order change category, as on the Engineering Change Orders form. Show Component Changes adds one row per component the revised item adds, changes or disables. Old Quantity and Old Op… full description	Enginatics
PER Position Hierarchy	Position hierarchy showing the reporting structure of positions with hierarchy level, organization, job, grade, location, budgeted vs actual headcount, vacancy count, and current incumbent names. Useful for position control, staffing analysis, and org chart construction.	BI Publisher, Enginatics
AR Unaccounted Transaction Sweep	Imported from BI Publisher Application: Receivables Source: Unaccounted Transaction Sweep Short Name: ARTRXSWP DB package: ar_unaccounted_trx_sweep	BI Publisher, Enginatics, R12 only
AP Advances in Selected Currency	Imported from BI Publisher Application: Payables Source: Advances in Selected Currency Short Name: APADVSELCUR DB package: AP_BAL_PKG	BI Publisher
AP Payment Audit by Voucher Number	Imported from BI Publisher Description: Payment Audit by Voucher Number Application: Payables Source: Payment Audit by Voucher Number (XML) Short Name: APXPAYAD_XML DB package: AP_APXPAYAD_XMLP_PKG	BI Publisher
AP Prepayment Balance	Imported from BI Publisher Application: Payables Source: AP Prepayment Balance Report Short Name: APPPBR DB package: AP_BAL_PKG	BI Publisher
AR Account Status	Imported from BI Publisher Description: Account Status Report Application: Receivables Source: Account Status Report (XML) Short Name: ARXASR_XML DB package: AR_ARXASR_XMLP_PKG	BI Publisher
AR Accounting Rules Listing	Application: Receivables Source: Accounting Rules Listing Report (XML) Short Name: RAXARL_XML DB package: AR_RAXARL_XMLP_PKG	BI Publisher
AR Adjustment Approval	Application: Receivables Source: Adjustment Approval Report (XML) Short Name: ARXCTA_XML DB package: AR_ARXCTA_XMLP_PKG	BI Publisher
AR AutoCash Rules	Imported from BI Publisher Description: AutoCash Rules Report Application: Receivables Source: AutoCash Rules (XML) Short Name: ARXPAR_XML DB package: AR_ARXPAR_XMLP_PKG	BI Publisher
AR Billing History	Imported from BI Publisher Description: Billing History Application: Receivables Source: Billing History (XML) Short Name: ARXCBH_XML DB package: AR_ARXCBH_XMLP_PKG	BI Publisher
AR Commitment Balance	Application: Receivables Source: Commitment Balance Report (XML) Short Name: RAXCBR_XML DB package: AR_RAXCBR_XMLP_PKG	BI Publisher
AR Cross Currency Exchange Gain/Loss	Imported from BI Publisher Description: Cross Currency Exchange Gain/Loss Report Application: Receivables Source: Cross Currency Exchange Gain/Loss Report (XML) Short Name: ARXFXGL_XML DB package: AR_ARXFXGL_XMLP_PKG	BI Publisher
AR Customer Open Balance Letter	Application: Receivables Source: Customer Open Balance Letter (XML) Short Name: ARXCOBLX_XML DB package: AR_ARXCOBLX_XMLP_PKG	BI Publisher
AR Customer Relationships Listing	Application: Receivables Source: Customer Relationships Listing (XML) Short Name: ARXCURLL_XML DB package: AR_ARXCURLL_XMLP_PKG	BI Publisher
AR DNB Global Data Products Request	Application: Receivables Source: DNB Global Data Products Request Report (XML) Short Name: ARHGDPRQ_XML DB package: AR_ARHGDPRQ_XMLP_PKG	BI Publisher
AR Duplicate Customer	Application: Receivables Source: Duplicate Customer Report (XML) Short Name: RAXMRP_XML DB package: AR_RAXMRP_XMLP_PKG	BI Publisher
AR Duplicate DUNS	Application: Receivables Source: Duplicate DUNS Report (XML) Short Name: ARHDUNDP_XML DB package: AR_ARHDUNDP_XMLP_PKG	BI Publisher
AR Incomplete Invoices	Application: Receivables Source: Incomplete Invoices Report (XML) Short Name: RAXIIR_XML DB package: AR_RAXIIR_XMLP_PKG	BI Publisher
AR Ordering and Grouping Rules Listing	Application: Receivables Source: Ordering and Grouping Rules Listing (XML) Short Name: ARXGRL_XML DB package: AR_ARXGRL_XMLP_PKG	BI Publisher
AR Payment Terms Listing	Application: Receivables Source: Payment Terms Listing (XML) Short Name: RAXPTL_XML DB package: AR_RAXPTL_XMLP_PKG	BI Publisher
AR Receipt Journal	Imported from BI Publisher Description: Receipt Journal Report Application: Receivables Source: Receipt Journal Report (XML) Short Name: ARXRJR_XML DB package: AR_ARXRJR_XMLP_PKG	BI Publisher
AR Receipts Awaiting Bank Clearance	Imported from BI Publisher Description: Receipts Awaiting Bank Clearance Report Application: Receivables Source: Receipts Awaiting Bank Clearance Report (XML) Short Name: ARXAPRCL_XML DB package: AR_ARXAPRCL_XMLP_PKG	BI Publisher
AR Receipts Awaiting Remittance	Imported from BI Publisher Description: Receipts Awaiting Remittance Report Application: Receivables Source: Receipts Awaiting Remittance Report (XML) Short Name: ARXAPRRM_XML DB package: AR_ARXAPRRM_XMLP_PKG	BI Publisher
AR Receipts Without Sites	Application: Receivables Source: Receipts Without Sites Report (XML) Short Name: ARXRWS_XML DB package: AR_ARXRWS_XMLP_PKG	BI Publisher
AR Remittance Batch Management	Imported from BI Publisher Description: Remittance Batch Management Report Application: Receivables Source: Remittance Batch Management Report (XML) Short Name: ARXAPRMB_XML DB package: AR_ARXAPRMB_XMLP_PKG	BI Publisher
AR Standard Memo Lines Listing	Application: Receivables Source: Standard Memo Lines Listing (XML) Short Name: RAXILL_XML DB package: AR_RAXILL_XMLP_PKG	BI Publisher
AR Transaction Batch Source Listing	Application: Receivables Source: Transaction Batch Source Listing (XML) Short Name: RAXSOL_XML DB package: AR_RAXSOL_XMLP_PKG	BI Publisher
AR Transaction Detail	Application: Receivables Source: Transaction Detail Report (XML) Short Name: ARXTDR_XML DB package: AR_ARXTDR_XMLP_PKG	BI Publisher
BEN Default Enrollment Summary	Application: Advanced Benefits Source: Default Enrollment Summary Report (XML) Short Name: BENDFSUM_XML DB package: BEN_BENDFSUM_XMLP_PKG	BI Publisher
BEN Dependent Eligibility Summary	Application: Advanced Benefits Source: Dependent Eligibility Summary Report (XML) Short Name: BENDESUM_XML DB package: BEN_BENDESUM_XMLP_PKG	BI Publisher
BEN Extract Audit	Application: Advanced Benefits Source: Extract Audit Report (XML) Short Name: BENXAUDT_XML DB package: BEN_BENXAUDT_XMLP_PKG	BI Publisher
BEN Extract Summary	Application: Advanced Benefits Source: Extract Summary Report (XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG	BI Publisher
BEN HIPAA Letter	Imported from BI Publisher Description: HIPAA Letter` Application: Advanced Benefits Source: HIPAA Letter (XML) Short Name: BENHIPAA_XML DB package: BEN_BENHIPAA_XMLP_PKG	BI Publisher
BOM Alternates	Imported from BI Publisher Description: Alternates Report Application: Bills of Material Source: Alternates Report (XML) Short Name: BOMRDBAD_XML DB package: BOM_BOMRDBAD_XMLP_PKG	BI Publisher
BOM Bill of Material Listing	Imported from BI Publisher Description: Bill of Material Listing Application: Bills of Material Source: Bill of Material Listing (XML) Short Name: BOMRASSY_XML DB package: BOM_BOMRASSY_XMLP_PKG	BI Publisher
BOM Bills of Material Parameters	Imported from BI Publisher Description: Bills of Material Parameters Report Application: Bills of Material Source: Bills of Material Parameters Report (XML) Short Name: BOMRDBPR_XML DB package: BOM_BOMRDBPR_XMLP_PKG	BI Publisher
BOM Delete Items	Imported from BI Publisher Description: Delete Items Report Application: Bills of Material Source: Delete Items Report (XML) Short Name: BOMRDDEL_XML DB package: BOM_BOMRDDEL_XMLP_PKG	BI Publisher
BOM Resource	Imported from BI Publisher Description: Resource Report Application: Bills of Material Source: Resource Report (XML) Short Name: BOMRDORS_XML DB package: BOM_BOMRDORS_XMLP_PKG	BI Publisher
BOM Workday Exception Sets	Application: Bills of Material Source: Workday Exception Sets Report (XML) Short Name: BOMRDEXS_XML DB package: BOM_BOMRDEXS_XMLP_PKG	BI Publisher
CSE Bill of Lading	Application: Asset Tracking Source: Bill of Lading Report (XML) Short Name: CSEBOFLD_XML DB package: CSE_CSEBOFLD_XMLP_PKG	BI Publisher
CST All Inventories Value	Imported from BI Publisher Description: All Inventories Value Report Application: Bills of Material Source: All Inventories Value Report (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG	BI Publisher
CST Intransit Value	Imported from BI Publisher Description: Intransit Value Report Application: Bills of Material Source: Intransit Value Report (XML) Short Name: CSTRITVR_XML DB package: BOM_CSTRITVR_XMLP_PKG	BI Publisher
CST Inventory Subledger	Imported from BI Publisher Description: Inventory Subledger Report Application: Bills of Material Source: Inventory Subledger Report (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG	BI Publisher
CST Overhead	Imported from BI Publisher Description: Overhead Report Application: Bills of Material Source: Overhead Report (XML) Short Name: CSTROVHD_XML DB package: BOM_CSTROVHD_XMLP_PKG	BI Publisher
CST Shipping Transaction Summary	Imported from BI Publisher Description: Shipping Transaction Summary Report Application: Bills of Material Source: Shipping Transaction Summary Report (XML) Short Name: CSTRSTSR_XML DB package: BOM_CSTRSTSR_XMLP_PKG	BI Publisher
CUSTOM IDC Authorized Bank Account Signers	Application: Custom Development Source: IDC Authorized Bank Account Signers Short Name: IDC_BA_SIGN DB package:	BI Publisher

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