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

Engineering

7 reports

DescriptionDownload
ENG Engineering Change Orders
Engineering change orders (ECOs) with one row per revised item: the ECO header with its type, status, approval status, priority, reason, requestor and dates, and the revised item with its new revision, effectivity, implementation and cancellation dates, use-up item and material disposition. An ECO without revised items is listed once with blank revised item columns. Change types are those based on the Change Order change category, as on the Engineering Change Orders form. Show Component Changes adds one row per component the revised item adds, changes or disables. Old Quantity and Old Op…
full description		 Enginatics XLS XML
ENG Engineering Change Order Approval Lists
Imported from BI Publisher Description: Engineering Change Order Approval Lists Report Application: Engineering Source: Engineering Change Order Approval Lists Report (XML) Short Name: ENGRCOAL_XML DB package: ENG_ENGRCOAL_XMLP_PKG
 BI Publisher XLS XML
ENG Engineering Change Order Priorities
Imported from BI Publisher Description: Engineering Change Order Priorities Report Application: Engineering Source: Engineering Change Order Priorities Report (XML) Short Name: ENGRDECP_XML DB package: ENG_ENGRDECP_XMLP_PKG
 BI Publisher XLS XML
ENG Engineering Change Order Reasons
Imported from BI Publisher Description: Engineering Change Order Reasons Report Application: Engineering Source: Engineering Change Order Reasons Report (XML) Short Name: ENGRDECR_XML DB package: ENG_ENGRDECR_XMLP_PKG
 BI Publisher XLS XML
ENG Engineering Change Order Types
Imported from BI Publisher Description: Engineering Change Order Types Report Application: Engineering Source: Engineering Change Order Types Report (XML) Short Name: ENGRECOT_XML DB package: ENG_ENGRECOT_XMLP_PKG
 BI Publisher XLS XML
ENG Engineering Change Order Detail
Imported from BI Publisher Description: Engineering Change Order Detail Report Application: Engineering Source: Engineering Change Order Detail Report (XML) Short Name: ENGRCNDR_XML DB package: ENG_ENGRCNDR_XMLP_PKG
 BI Publisher XML
ENG Engineering Change Order Schedule
Imported from BI Publisher Description: Engineering Change Order Schedule Report Application: Engineering Source: Engineering Change Order Schedule Report (XML) Short Name: ENGRCNSR_XML DB package: ENG_ENGRCNSR_XMLP_PKG
 BI Publisher XML