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
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
XXEN: FND User Login History with Geolocation	Audit history of application user logins. EBS user logon audit is controlled by profile 'Sign-On:Audit Level'. The most detailed audit level setting is 'FORM'. Unfortunately, this audit tracks access to individual forms only, but not to different JSPs (HTML / OAF / ADF Pages). As a workaround, the report SQL also joins to icx_sessions, which contains a record for each login (in fact, it also stores a record for each access to the login page before login. These records are marked with guest='Y'). The function retrieved from icx_session however, just shows the latest OAF function accessed by… full description	Draft
XXEN_SCHUB_FORECAST_FILTER	System report controlling the forecast filter functionality on the Supply Chain Hub form	Supply Chain Hub
XXEN_SCHUB_ITEM_CUSTOM_QUERY	Supply Chain Hub Form - Customer Extension Query to populate the configurable placeholder columns in the Items Tab with Customer Site Specific item information. 1. Modify the query to derive and populate the query select columns with your custom specific item information 2. Do not remove the organization_id or inventory_item_id select columns 3. Do not modify the column aliases 4. Do not modify or add and additional lexical parameters 5. Remove the where clause and 1=2 6. In Responsibility: CRM Administrator, Menu: Spreadtable - Metadata Administration, modify the spreadtable… full description	Supply Chain Hub
XXEN_SCHUB_ITEM_FILTER	System report controlling the item filter functionality on the Supply Chain Hub form	Supply Chain Hub
XXEN_SCHUB_ITEM_SEARCH	System report controlling the search functionality on the Supply Chain Hub form	Supply Chain Hub
XXEN_SCHUB_PLAN_ACTIONS_FILTER	System report controlling the plan actions filter functionality on the Supply Chain Hub form	Supply Chain Hub
XXEN_SCHUB_SUPPLY_DEMAND_FILTER	System report controlling the supply/demand filter functionality on the Supply Chain Hub form	Supply Chain Hub
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
Yanmar - Discount on order lines check	Detail Sales Order or Quote header report with line item details including status, cost, project and shipping information.
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 Register	Imported from BI Publisher Description: Tax Register Application: E-Business Tax Source: Tax Register (XML) Short Name: ZXXSTVRR_XML DB package: ZXXSTVRR	RDF
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
all tables
bank inteface
deno 2 sql to report
inventory item tracker
jens report
new blitz report
orgs
rares repo	this is a simple report

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