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

1,744 reports

	Description
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
XTR Positions - Limit Utilizations	Application: Treasury Source: Positions - Limit Utilizations Report (XML) Short Name: XTRLIUTL_XML DB package: XTR_XTRLIUTL_XMLP_PKG	BI Publisher
XTR Positions - Mark to Market Revaluation Summary	Application: Treasury Source: Positions - Mark to Market Revaluation Summary Report (XML) Short Name: XTRREVGL_XML DB package: XTR_XTRREVGL_XMLP_PKG	BI Publisher
XTR Positions - Maturities by Counterparty	Application: Treasury Source: Positions - Maturities by Counterparty Report (XML) Short Name: XTRMTCPY_XML DB package: XTR_XTRMTCPY_XMLP_PKG	BI Publisher
XTR Positions - Maturities by Date	Application: Treasury Source: Positions - Maturities by Date Report (XML) Short Name: XTRMTDAT_XML DB package: XTR_XTRMTDAT_XMLP_PKG	BI Publisher
XTR Positions - Outstanding Hedge Instruments	Application: Treasury Source: Positions - Outstanding Hedge Instruments Report (XML) Short Name: XTROHINS_XML DB package: XTR_XTROHINS_XMLP_PKG	BI Publisher
XTR Positions - Outstanding Receivables / Payables	Imported from BI Publisher Description: Positions - Outstanding Receivables / Payables Report Application: Treasury Source: Positions - Outstanding Receivables / Payables Report (XML) Short Name: XTRHOAPR_XML DB package: XTR_XTRHOAPR_XMLP_PKG	BI Publisher
XTR Positions - Treasury Cashflows by Account	Application: Treasury Source: Positions - Treasury Cashflows by Account Report (XML) Short Name: XTRCFACC_XML DB package: XTR_XTRCFACC_XMLP_PKG	BI Publisher
XTR Positions - Treasury Consolidated Cashflows	Imported from BI Publisher Description: Positions - Treasury Consolidated Cashflows Report Application: Treasury Source: Positions - Treasury Consolidated Cashflows Report (XML) Short Name: XTRCFCON_XML DB package: XTR_XTRCFCON_XMLP_PKG	BI Publisher
XTR Program - Update Settlement Bank Account Execution	Application: Treasury Source: Program - Update Settlement Bank Account Execution Report (XML) Short Name: XTRUPREP_XML DB package: XTR_XTRUPREP_XMLP_PKG	BI Publisher
XTR Settlements - Daily Payments / Receipts Letters	Application: Treasury Source: Settlements - Daily Payments / Receipts Letters (XML) Short Name: XTRLTDAP_XML DB package: XTR_XTRLTDAP_XMLP_PKG	BI Publisher
XTR Settlements - Journals by Date	Imported from BI Publisher Description: Settlements - Journals by Date Report Application: Treasury Source: Settlements - Journals by Date Report (XML) Short Name: XTRJLDAT_XML DB package: XTR_XTRJLDAT_XMLP_PKG	BI Publisher
XTR Settlements - Status	Application: Treasury Source: Settlements - Status Report (XML) Short Name: XTRSESTA_XML DB package: XTR_XTRSESTA_XMLP_PKG	BI Publisher
XTR Term Money - By Type and Product	Application: Treasury Source: Term Money - By Type and Product Report (XML) Short Name: XTRTMBLT_XML DB package: XTR_XTRTMBLT_XMLP_PKG	BI Publisher
XTR Term Money - New/Settled Retail Term Money	Application: Treasury Source: Term Money - New/Settled Retail Term Money Report (XML) Short Name: XTRTMNEW_XML DB package: XTR_XTRTMNEW_XMLP_PKG	BI Publisher
XTR Term Money - Retail Term Money Aging	Application: Treasury Source: Term Money - Retail Term Money Aging Report (XML) Short Name: XTRTMODR_XML DB package: XTR_XTRTMODR_XMLP_PKG	BI Publisher
XTR Term Money - Retail Term Money Overdues	Application: Treasury Source: Term Money - Retail Term Money Overdues Report (XML) Short Name: XTRTMAOD_XML DB package: XTR_XTRTMAOD_XMLP_PKG	BI Publisher
XTR Term Money - Retail Term Money Statements	Application: Treasury Source: Term Money - Retail Term Money Statements (XML) Short Name: XTRTMSTM_XML DB package: XTR_XTRTMSTM_XMLP_PKG	BI Publisher
XTR Term Money - Term Average Rates	Application: Treasury Source: Term Money - Term Average Rates Report (XML) Short Name: XTRTMAVG_XML DB package: XTR_XTRTMAVG_XMLP_PKG	BI Publisher
XX Account Analysis	Application: Subledger Accounting Source: XX Account Analysis Report Short Name: XXXLAAARPT DB package: XLA_ACCT_ANALYSIS_RPT_PKG	BI Publisher
XXAR EMR AR Aging by BU Report LAM	Imported from BI Publisher Application: Custom Receivables Source: EMR AR Aging by BU Report LAM Short Name: XXAR_AGING_REP_LAM DB package:	BI Publisher
YMS Yard Equipment Move Slip	Application: Oracle Yard Management Source: Yard Equipment Move Slip (XML) Short Name: YMSTOPKL_XML DB package: YMS_YMSTOPKL_XMLP_PKG	BI Publisher
ZX E-Business Tax Missing Location Values - draft	Application: E-Business Tax Source: E-Business Tax Missing Location Values Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXLOCREP_XML DB package: ZX_ZXLOCREP_XMLP_PKG	BI Publisher
ZX Singaporean GST F5 Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Singaporean GST F5 Report Application: E-Business Tax Source: Singaporean GST F5 Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXSGGF5_XML DB package: ZX_ZXAPJAJL_XMLP_PKG	BI Publisher
ZX Singaporean Input Taxes Gain/Loss Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Singaporean Input Taxes Gain/Loss Report Application: E-Business Tax Source: Singaporean Input Taxes Gain/Loss Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXSGAGAL_XML DB package: ZX_ZXAPJAJL_XMLP_PKG	BI Publisher
ZX Taiwanese Input VAT Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Input VAT Report Application: E-Business Tax Source: Taiwanese Input VAT Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWPVAT_XML DB package: ZX_ZXAPJAJL_XMLP_PKG	BI Publisher
ZX Taiwanese Output VAT Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Output VAT Report Application: E-Business Tax Source: Taiwanese Output VAT Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWRVAT_XML DB package: ZX_ZXARRECV_XMLP_PKG	BI Publisher
ZX Taiwanese Payables Sales/Purchase Return and Discount Certificate- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Payables Sales/Purchase Return and Discount Certificate Application: E-Business Tax Source: Taiwanese Payables Sales/Purchase Return and Discount Certificate (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWPSPC_XML DB package: ZX_ZXAPJAJL_XMLP_PKG	BI Publisher
ZX Taiwanese Pro Forma 401 Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Pro Forma 401 Report Application: E-Business Tax Source: Taiwanese Pro Forma 401 Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWSPRF_XML DB package: ZX_ZXARRECV_XMLP_PKG	BI Publisher
ZX Taiwanese Purchase Return and Discount Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Purchase Return and Discount Report Application: E-Business Tax Source: Taiwanese Purchase Return and Discount Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWPPRD_XML DB package: ZX_ZXAPJAJL_XMLP_PKG	BI Publisher
ZX Taiwanese Receivables Government Uniform Invoice Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Receivables Government Uniform Invoice Report Application: E-Business Tax Source: Taiwanese Receivables Government Uniform Invoice Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWRUIL_XML DB package: ZX_ZXARRECV_XMLP_PKG	BI Publisher
ZX Taiwanese Receivables Zero-Rate Tax Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Receivables Zero Rate Tax Report Application: E-Business Tax Source: Taiwanese Receivables Zero-Rate Tax Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWRZTR_XML DB package: ZX_ZXARRECV_XMLP_PKG	BI Publisher
ZX Taiwanese Sales Return and Discount Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Taiwanese Sales Return and Discount Report Application: E-Business Tax Source: Taiwanese Sales Return and Discount Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXTWRSRD_XML DB package: ZX_ZXARRECV_XMLP_PKG	BI Publisher
ZX Tax Reconciliation by Taxable Account Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Tax Reconciliation by Taxable Account Report Application: E-Business Tax Source: Tax Reconciliation by Taxable Account Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXJGTAX_XML DB package: ZX_ZXJGTAX_XMLP_PKG	BI Publisher
ZX Tax-Only Open Invoices - draft	Application: E-Business Tax Source: Tax-Only Open Invoices Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXXATB_XML DB package: ZX_ZXXATB_XMLP_PKG	BI Publisher
ZX Use Tax Liability Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Use Tax Liability Report Application: E-Business Tax Source: Use Tax Liability Report (XML) - Not Supported: Reserved For Future Use Short Name: ZXXINUTR_XML DB package: ZX_ZXXINUTR_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