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

3,151 reports

DescriptionDownload
OKL Lease Subsidy Pool Association
Application: Lease and Finance Management Source: Lease Subsidy Pool Association Report Short Name: OKLLASUBPOOLASSOCRPT DB package: OKL_SUBSIDY_POOL_RPT_PVT
BI Publisher XML
OKL Lease Subsidy Pool At-Limit
Application: Lease and Finance Management Source: Lease Subsidy Pool At-Limit Report Short Name: OKLLASUBPOOLATLMTRPT DB package: OKL_SUBSIDY_POOL_RPT_PVT
BI Publisher XML
OKL Lease Subsidy Pool Reconciliation
Application: Lease and Finance Management Source: Lease Subsidy Pool Reconciliation Report Short Name: OKLLASUBPOOLRECONRPT DB package: OKL_SUBSIDY_POOL_RPT_PVT
BI Publisher XML
OKL Lease Vendor Party Mismatch
Application: Lease and Finance Management Source: Lease Vendor Party Mismatch Report Short Name: OKLVNDMISMATCH DB package:
BI Publisher XML
OKL Loans Amortization Schedule
Application: Lease and Finance Management Source: Short Name: OKLLNSAMORTSCHED DB package:
BI Publisher XML
OKL Notify Repossession
Application: Lease and Finance Management Source: Short Name: OKLNTFYREPOS DB package:
BI Publisher XML
OKL Notify Title Filing Authority
Application: Lease and Finance Management Source: Short Name: OKLTITLEFILING DB package:
BI Publisher XML
OKL Passthrough Transaction Activity
Application: Lease and Finance Management Source: Passthrough Transaction Activity Report Short Name: OKLPASSTHRPT DB package: OKL_PASSTHROUGH_RECON_RPT_PVT
BI Publisher XML
OKL Payment Schedule
Application: Lease and Finance Management Source: Short Name: OKLPAYSCHED DB package:
BI Publisher XML
OKL Principal Paydown Statement
Application: Lease and Finance Management Source: Short Name: OKLPRINPAYDOWN DB package:
BI Publisher XML
OKL Professional Tax
Application: Lease and Finance Management Source: Short Name: OKLPROFTAX DB package:
BI Publisher XML
OKL Purchase Option
Application: Lease and Finance Management Source: Short Name: OKLPURCHSOPT DB package:
BI Publisher XML
OKL Receipt Inquiry
Application: Lease and Finance Management Source: Short Name: OKLRECPTINQ DB package:
BI Publisher XML
OKL Report - Vendor Residual Share
Application: Lease and Finance Management Source: OKL Report - Vendor Residual Share Report Short Name: OKL_AM_VEND_RES_SHR_RPT DB package: OKL_AM_VENDOR_RES_SHARE_PVT
BI Publisher XML
OKL Settlement Letter
Application: Lease and Finance Management Source: Short Name: OKLSTLMNTLTR DB package:
BI Publisher XML
OKL Tax Schedule
Application: Lease and Finance Management Source: Short Name: OKLTAXSCHED DB package:
BI Publisher XML
OKL Termination Bill of Sale
Application: Lease and Finance Management Source: Short Name: OKLTERMBILLSALE DB package:
BI Publisher XML
OKL Termination Quote
Application: Lease and Finance Management Source: Short Name: OKLTERMQUOTE DB package:
BI Publisher XML
OKL Title Return from Third Party Title Custodian
Application: Lease and Finance Management Source: Short Name: OKLTHIRDCUST DB package:
BI Publisher XML
OKL Transfer Journal Entries to GL - Lease and Finance Management
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: Lease and Finance Management Source: Transfer Journal Entries to GL - Lease and Finance Management Short Name: OKLGLTRN DB package: XLA_CREATE_ACCT_RPT_PVT
BI Publisher XML
OKL Transfer and Assumption
Application: Lease and Finance Management Source: Short Name: OKLTRSFRASUM DB package:
BI Publisher XML
OKL Variable Rate Schedule
Application: Lease and Finance Management Source: Short Name: OKLVARSCHED DB package:
BI Publisher XML
OKS Products Not Renewed
Application: Service Contracts Source: OKS Products Not Renewed Report (XML) Short Name: OKSNREPD_XML DB package: OKS_OKSNREPD_XMLP_PKG
BI Publisher XML
OKS Service Contracts Detail
Application: Service Contracts Source: Service Contracts Detail Report (XML) Short Name: OKSCODET_XML DB package: OKS_OKSCODET_XMLP_PKG
BI Publisher 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
ONT-ECC Command Center XML
OPM Actual Item Cost Transaction Manufacturing Draft XML
OPM Batch Material Transactions Manufacturing Draft XML
OPM Batch Steps
Listing of batch steps and status
Manufacturing Draft XML
OPM Batch steps and activities
Listing of the batch steps with activity factors
Manufacturing XML
OPM Batches
Detail report showing the status of the OPM Batches, including basic information such as plant code, batch number, batch type (0 for normal batches or 10 for firm planned orders), and batch status. Batches have many steps which are found in GME_BATCH_STEPS. It's not in the example query; but, the operation name can be found in GMD_OPERATIONS_B which is linked by OPRN_ID. Steps have many activities which are found in GME_BATCH_STEP_ACTIVITIES. Activities have many resources which are found in GME_BATCH_STEP_RESOURCESS. Resources have many process parameters which are found…
full description
Manufacturing Draft XML
OPM Formulas
Summary listing of all active formulas
Manufacturing Draft XML
OPM Lot Costs Manufacturing XML
OPM Product Qty in batches
Query to Find out Quantity of Products and Ingredients of all Batches in particular Month.
Manufacturing Draft XML