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

89 reports

DescriptionDownload
WSH Shipped Delivery Lines
Imported from BI Publisher Description: Shipped Delivery Lines Report Application: Shipping Execution Source: Shipped Delivery Lines Report (XML) Short Name: WSHRDSDL_XML DB package: WSH_WSHRDSDL_XMLP_PKG
 Order Management BI Publisher XLS XML
WSH Shipping Exceptions
Imported from BI Publisher Description: Shipping Exceptions Report Application: Shipping Execution Source: Shipping Exceptions Report (XML) Short Name: WSHRDXCP_XML DB package: WSH_WSHRDXCP_XMLP_PKG
 Order Management BI Publisher XLS XML
WSH Vehicle Load Sheet Summary PDF Output
Application: Shipping Execution Source: Vehicle Load Sheet Summary PDF Output (XML) Short Name: WSHRDVLSX_XML DB package: WSH_WSHRDVLS_XMLP_PKG
 Order Management BI Publisher XLS XML
OE Order Processing Key Indicators
Imported from Concurrent Program Application: Order Entry Source: Order Processing Key Indicators Short Name: OEXOEPKI
 Order Management Concurrent Program XML
ONT - Planning Reliability Metric
Legging metric for trend / plan relaibility analysis on schedule ship date and promise date Use this to pinpoint trends in the late shipping of a sales order versus reality
 Order Management XML
ONT Cancelled Orders Reason Detail
Imported from BI Publisher Description: Cancelled Orders Reason Detail Report Application: Order Management Source: Cancelled Orders Reason Detail Report (XML) Short Name: OEXOEOCR_XML DB package: ONT_OEXOEOCR_XMLP_PKG
 Order Management BI Publisher XML
ONT Credit Check Processor
Application: Order Management Source: Credit Check Processor (XML) Short Name: OEXAUCRC_XML DB package: ONT_OEXAUCRC_XMLP_PKG
 Order Management BI Publisher XML
ONT Credit Exposure
Imported from BI Publisher Application: Order Management Source: Credit Exposure Report (XML) Short Name: OEXCEXP_XML DB package: ONT_OEXCEXP_XMLP_PKG
 Order Management BI Publisher XML
ONT DIFOT
Sales order header and line details with additional logic to measure the order shipping performance metric: delivered in full and on time (DIFOT).
 Order Management Draft XML
ONT Hold Source Activity
Imported from BI Publisher Description: Hold Source Activity Report Application: Order Management Source: Hold Source Activity Report (XML) Short Name: OEXOHHSA_XML DB package: ONT_OEXOHHSA_XMLP_PKG
 Order Management BI Publisher XML
ONT Internal Order and Purchasing Requisition Discrepancy
Imported from BI Publisher Description: Internal Order and Purchasing Requisition Discrepancy Report Application: Order Management Source: Internal Order and Purchasing Requisition Discrepancy Report (XML) Short Name: OEXIODIS_XML DB package: ONT_OEXIODIS_XMLP_PKG
 Order Management BI Publisher XML
ONT Lines on Credit Check Hold
Imported from BI Publisher Description: Lines on Credit Check Hold Report Application: Order Management Source: Lines on Credit Check Hold Report (XML) Short Name: OEXOECCL_XML DB package: ONT_OEXOECCL_XMLP_PKG
 Order Management BI Publisher XML
ONT Order Management Setup Validation
Application: Order Management Source: Order Management Setup Validation Report (XML) Short Name: OEXSEVAL_XML DB package: ONT_OEXSEVAL_XMLP_PKG
 Order Management XML
ONT Order Processing Errors
During a Sales Order Creation scenario, when data is inserted into Interface table – sometimes Orders can fail to get created due to issues in the Interface table. The corresponding error information is stored in the oe_processing_msgs_tl table. original_sys_document_ref contains the order number Schedule this query to find out error messages in the Order Interface table is: SELECT * FROM oe_headers_iface_all WHERE order_number = '123456'; SELECT * FROM oe_lines_iface_all WHERE orig_sys_document_ref = (SELECT orig_sys_document_ref FROM…
full description		 Order Management XML
ONT Order/Invoice Detail
Imported from BI Publisher Description: Order/Invoice Detail Report Application: Order Management Source: Order/Invoice Detail Report (XML) Short Name: OEXOEIOD_XML DB package: ONT_OEXOEIOD_XMLP_PKG
 Order Management BI Publisher XML
ONT Order/Invoice Summary
Imported from BI Publisher Description: Order/Invoice Summary Report Application: Order Management Source: Order/Invoice Summary Report (XML) Short Name: OEXOEIOS_XML DB package: ONT_OEXOEIOS_XMLP_PKG
 Order Management BI Publisher XML
ONT Orders - GW
Detail Sales Order or Quote header report, including status, amount and invoice status information.
 Order Management XML
ONT Orders Failing Trip Stop
List of orders with accounts
 Order Management XML
ONT Orders on Credit Check Hold
Imported from BI Publisher Description: Orders on Credit Check Hold Report Application: Order Management Source: Orders on Credit Check Hold Report (XML) Short Name: OEXOECCH_XML DB package: ONT_OEXOECCH_XMLP_PKG
 Order Management BI Publisher XML
ONT Sales Order Acknowledgement
Imported from BI Publisher Description: Sales Order Acknowledgement Application: Order Management Source: Sales Order Acknowledgement (XML) Short Name: OEXOEACK_XML DB package: ONT_OEXOEACK_XMLP_PKG
 Order Management BI Publisher XML
ONT Salesperson Order Summary
Imported from BI Publisher Description: Salesperson Order Summary Report Application: Order Management Source: Salesperson Order Summary Report (XML) Short Name: OEXOESOS_XML DB package: ONT_OEXOESOS_XMLP_PKG
 Order Management BI Publisher XML
QP Accrual Details
Application: Advanced Pricing Source: Accrual Details (XML) Short Name: QPXPACRL_XML DB package: QP_QPXPACRL_XMLP_PKG
 Order Management BI Publisher XML
QP Modifier Details (1)
Imported from BI Publisher Description: Modifier Details Report for QP Application: Advanced Pricing Source: Modifier Details (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG
 Order Management BI Publisher XML
QP Pricing Formulas
Application: Advanced Pricing Source: Pricing Formulas (XML) Short Name: QPXPRFOR_XML DB package: QP_QPXPRFOR_XMLP_PKG
 Order Management BI Publisher XML
QP Qualifier Grouping
Application: Advanced Pricing Source: Qualifier Grouping (XML) Short Name: QPXPRQFS_XML DB package: QP_QPXPRQFS_XMLP_PKG
 Order Management BI Publisher XML
WSH Auto Ship Confirm
Imported from BI Publisher Application: Shipping Execution Source: Auto Ship Confirm Report (XML) Short Name: WSHRDASC_XML DB package: WSH_WSHRDASP_XMLP_PKG
 Order Management BI Publisher XML
WSH Auto-pack
Imported from BI Publisher Application: Shipping Execution Source: Auto-pack Report (XML) Short Name: WSHRDAPK_XML DB package: WSH_WSHRDASP_XMLP_PKG
 Order Management BI Publisher XML
WSH Bill of Lading
Imported from BI Publisher Description: Bill of Lading Application: Shipping Execution Source: Bill of Lading (XML) Short Name: WSHRDBOL_XML DB package: WSH_WSHRDBOL_XMLP_PKG
 Order Management BI Publisher XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML
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 XML