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 143 AR 123 FA 138 CE 25 PO 116 INV 129 OM 89 MFG 214 COST 175 PA 131 HR 182 PAY 151 SYS 162

3,151 reports

	Description
WSH Bill of Lading PDF Output	Imported from BI Publisher Description: Bill of Lading PDF Output Application: Shipping Execution Source: Bill of Lading PDF Output (XML) Short Name: WSHRDBOLX_XML DB package: WSH_WSHRDBOL_XMLP_PKG	Order Management BI Publisher
WSH ITM Adapter Status	Application: Shipping Execution Source: ITM Adapter Status Report (XML) Short Name: WSHRDIST_XML DB package: WSH_WSHRDIST_XMLP_PKG	Order Management BI Publisher
WSH Mailing Label PDF Output	Application: Shipping Execution Source: Mailing Label PDF Output (XML) Short Name: WSHRDLABX_XML DB package: WSH_WSHRDLAB_XMLP_PKG	Order Management BI Publisher
WSH Master Bill of Lading	Application: Shipping Execution Source: Master Bill of Lading (XML) Short Name: WSHRDMBL_XML DB package: WSH_WSHRDMBL_XMLP_PKG	Order Management BI Publisher
WSH Master Bill of Lading PDF Output	Application: Shipping Execution Source: Master Bill of Lading PDF Output (XML) Short Name: WSHRDMBLX_XML DB package: WSH_WSHRDMBL_XMLP_PKG	Order Management BI Publisher
WSH Packing Slip	Imported from BI Publisher Description: Packing Slip Report Application: Shipping Execution Source: Packing Slip Report (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG	Order Management BI Publisher
WSH Packing Slip Report PDF Output	Imported from BI Publisher Description: Packing Slip Report PDF Output Application: Shipping Execution Source: Packing Slip Report PDF Output (XML) Short Name: WSHRDPAKX_XML DB package: WSH_WSHRDPAK_XMLP_PKG	Order Management BI Publisher
WSH Pick Slip	Imported from BI Publisher Description: Pick Slip Report Application: Shipping Execution Source: Pick Slip Report (XML) Short Name: WSHRDPIK_XML DB package: WSH_WSHRDPIK_XMLP_PKG	Order Management BI Publisher
WSH Pick Slip Report PDF Output	Imported from BI Publisher Description: Pick Slip Report PDF Output Application: Shipping Execution Source: Pick Slip Report PDF Output (XML) Short Name: WSHRDPIKX_XML DB package: WSH_WSHRDPIK_XMLP_PKG	Order Management BI Publisher
WSH Vehicle Load Sheet Details	Application: Shipping Execution Source: Vehicle Load Sheet Details (XML) Short Name: WSHRDVLD_XML DB package: WSH_WSHRDVLD_XMLP_PKG	Order Management BI Publisher
WSH Vehicle Load Sheet Summary	Application: Shipping Execution Source: Vehicle Load Sheet Summary (XML) Short Name: WSHRDVLS_XML DB package: WSH_WSHRDVLS_XMLP_PKG	Order Management BI Publisher
WSH_CARRIER_SERVICES
WSH_DELIVERY_ASSIGNMENTS
WSH_DELIVERY_DETAILS
WSH_NEW_DELIVERIES
WSM Pending Transactions	Imported from BI Publisher Description: Pending Transactions Report Application: Shop Floor Management Source: Pending Transactions Report (XML) Short Name: WSMPNTXN_XML DB package: WSM_WSMPNTXN_XMLP_PKG	BI Publisher
XLA Account Analysis	Imported from BI Publisher Description: Standard Account Analysis Report Application: Subledger Accounting Source: Account Analysis Report Short Name: XLAAARPT DB package: XLA_ACCT_ANALYSIS_RPT_PKG	General Ledger BI Publisher
XLA Accounts Payables Trial Balance Rebuild	Imported from BI Publisher Application: Subledger Accounting Source: Accounts Payables Trial Balance Rebuild Short Name: XLATBBLD DB package: XLA_TB_REBUILD_PKG	General Ledger BI Publisher
XLA Complete Multiperiod Accounting	Imported from BI Publisher Application: Subledger Accounting Source: Complete Multiperiod Accounting Short Name: XLARPMPA DB package: XLA_MULTIPERIOD_RPRTG_PKG	General Ledger BI Publisher
XLA Create Accounting	Imported from BI Publisher Description: Report for the Accounting Program Application: Subledger Accounting Source: Create Accounting Short Name: XLAACCPB DB package: XLA_CREATE_ACCT_RPT_PVT	General Ledger BI Publisher
XLA Create and Assign Sources- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Create and Assign Sources Report Application: Subledger Accounting Source: Create and Assign Sources (XML) - Not Supported: Reserved For Future Use Short Name: XLAABASR_XML DB package: XLA_XLAABASR_XMLP_PKG	General Ledger BI Publisher
XLA Export Application Accounting Definitions- Not Supported: Reserved For Future Use	Imported from BI Publisher Application: Subledger Accounting Source: Export Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use Short Name: XLAALEXP_XML DB package: XLA_XLAALEXP_XMLP_PKG	General Ledger BI Publisher
XLA Import Initial Balance for Third Party Control Account	Application: Subledger Accounting Source: Import Initial Balance for Third Party Control Account Short Name: XLACAINBAL DB package: XLA_CA_BALANCES_PKG	General Ledger BI Publisher
XLA Import Initial Balances for Supporting References	Application: Subledger Accounting Source: Import Initial Balances for Supporting References Short Name: XLAACSUPREF DB package: XLA_AC_BALANCES_PKG	General Ledger BI Publisher
XLA Journal Entries	Imported from BI Publisher Description: SLA Standard Journal Entry Lines Report Application: Subledger Accounting Source: Journal Entries Report Short Name: XLAJELINESRPT DB package: XLA_JELINES_RPT_PKG	General Ledger BI Publisher
XLA Open Account AP Balances Listing	Imported from BI Publisher Application: Subledger Accounting Source: Open Account AP Balances Listing Short Name: XLAAPRPT DB package: XLA_TB_AP_REPORT_PVT	General Ledger BI Publisher
XLA Open Account Balances Listing	Imported from BI Publisher Application: Subledger Accounting Source: Open Account Balances Listing Short Name: XLATBRPT DB package: XLA_TB_REPORT_PVT	General Ledger BI Publisher
XLA Subledger Multiperiod Accounting and Accrual Reversal	Imported from BI Publisher Description: Report for the Accounting Program Application: Subledger Accounting Source: Subledger Multiperiod Accounting and Accrual Reversal Report Short Name: XLARPMPX DB package: XLA_MPA_ACCRUAL_RPRTG_PKG	General Ledger BI Publisher
XLA Subledger Period Close Exceptions (1)	Imported from BI Publisher Description: This report is called by the Period Close Validation Program to extract all those events which are either untransferred or are not accounted for. Application: Subledger Accounting Source: Subledger Period Close Exceptions Report Short Name: XLAPEXRPT DB package: XLA_PERIOD_CLOSE_EXP_PKG	General Ledger BI Publisher
XLA Third Party Balances	Imported from BI Publisher Description: Standard Third Party Balances Report Application: Subledger Accounting Source: Third Party Balances Report Short Name: XLATPRPT DB package: XLA_TP_BALANCE_RPT_PKG	General Ledger BI Publisher
XLA Trading Partner Summary	Imported from BI Publisher Application: Subledger Accounting Source: Trading Partner Summary Report Short Name: XLATPSUMRPT DB package: XLA_TP_SUMMARY_RPT_PKG	General Ledger BI Publisher
XLA Transfer Journal Entries to GL	Imported from BI Publisher Description: Use this program to transfer to GL subledger journal entries generated by previous executions of the create accounting program Application: Subledger Accounting Source: Transfer Journal Entries to GL Short Name: XLAGLTRN DB package: XLA_CREATE_ACCT_RPT_PVT	General Ledger BI Publisher
XLA Trial Balance - Manual SLA AP Amounts	XLA Trial Balance - Manual SLA AP Amounts	General Ledger XLA Trial Balance Analysis
XLA Trial Balance - Non AP Journal Amounts	XLA Trial Balance - Non AP Sourced Journal Amounts	General Ledger XLA Trial Balance Analysis
XLA Trial Balance - Raw Data	xla_trial_balances - Raw Data	General Ledger XLA Trial Balance Analysis
XLA Validate Application Accounting Definitions- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Application Accounting Definition Validation Report Application: Subledger Accounting Source: Validate Application Accounting Definitions (XML) - Not Supported: Reserved For Future Use Short Name: XLAABACR_XML DB package: XLA_XLAABACR_XMLP_PKG	General Ledger BI Publisher
XTR Admin - Audit Summary	Application: Treasury Source: Admin - Audit Summary Report (XML) Short Name: XTRAUSRM_XML DB package: XTR_XTRAUSRM_XMLP_PKG	BI Publisher
XTR Admin - Average FX Rates	Application: Treasury Source: Admin - Average FX Rates Report (XML) Short Name: XTRFXAVG_XML DB package: XTR_XTRFXAVG_XMLP_PKG	BI Publisher
XTR Admin - Cancelled Transactions Summary	Application: Treasury Source: Admin - Cancelled Transactions Summary Report (XML) Short Name: XTRAUNCL_XML DB package: XTR_XTRAUNCL_XMLP_PKG	BI Publisher
XTR Admin - Limit Exceptions Log	Application: Treasury Source: Admin - Limit Exceptions Log (XML) Short Name: XTRLIEXP_XML DB package: XTR_XTRLIEXP_XMLP_PKG	BI Publisher
XTR Admin - Loan Securities	Imported from BI Publisher Description: Admin - Loan Securities Report Application: Treasury Source: Admin - Loan Securities Report (XML) Short Name: XTRMILNS_XML DB package: XTR_XTRMILNS_XMLP_PKG	BI Publisher
XTR Data Exchange - Market Data Transfer	Application: Treasury Source: Data Exchange - Market Data Transfer Report (XML) Short Name: XTRMDTRP_XML DB package: XTR_XTRMDTRP_XMLP_PKG	BI Publisher
XTR Intercompany - Interest Settlement	Application: Treasury Source: Intercompany - Interest Settlement Report (XML) Short Name: XTRIGINS_XML DB package: XTR_XTRIGINS_XMLP_PKG	BI Publisher
XTR Intercompany - Letters	Application: Treasury Source: Intercompany - Letters (XML) Short Name: XTRLTIGI_XML DB package: XTR_XTRLTIGI_XMLP_PKG	BI Publisher
XTR Intercompany - Statements	Application: Treasury Source: Intercompany - Statements (XML) Short Name: XTRIGSUM_XML DB package: XTR_XTRIGSUM_XMLP_PKG	BI Publisher
XTR Positions - Currency Gain/Loss Revaluation	Application: Treasury Source: Positions - Currency Gain/Loss Revaluation Report (XML) Short Name: XTRCCYGL_XML DB package: XTR_XTRCCYGL_XMLP_PKG	BI Publisher
XTR Positions - Derivatives Disclosure by Hedge Type	Application: Treasury Source: Positions - Derivatives Disclosure by Hedge Type Report (XML) Short Name: XTRDDHTY_XML DB package: XTR_XTRDDHTY_XMLP_PKG	BI Publisher
XTR Positions - Discounted Securities Register	Application: Treasury Source: Positions - Discounted Securities Register (XML) Short Name: XTRDISRE_XML DB package: XTR_XTRDISRE_XMLP_PKG	BI Publisher
XTR Positions - FX Exposures	Application: Treasury Source: Positions - FX Exposures Report (XML) Short Name: XTRFXEXP_XML DB package: XTR_XTRFXEXP_XMLP_PKG	BI Publisher
XTR Positions - Interest Rate Hedges	Application: Treasury Source: Positions - Interest Rate Hedges Report (XML) Short Name: XTRIRHED_XML DB package: XTR_XTRIRHED_XMLP_PKG	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