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
Draft

8 reports

DescriptionDownload
BOM Models
Master data report showing the exploded Bill of Materials
 Manufacturing Draft XML
GMF MUV Detail Manufacturing Draft 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 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 Product Qty in batches
Query to Find out Quantity of Products and Ingredients of all Batches in particular Month.
 Manufacturing Draft XML