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 147 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
Senfor International

2 reports

DescriptionDownload
Mgt: Senfor Intl - Sales Order Book - Demand Planning Analysis
This report extracts details of Sales Orders and Lines according to the parameters entered. Kit items with an item type of "INCLUDED" are excluded. Pivot tables and templates can be added to produce Analysis dashboards. This example contains a pivot table by Business Unit and Customer with a dashboard configued. Data fields, parameters and other templates may be added or removed according to requirements. Please contact the author, [email protected], if you require assistance. Version Modified on Modified  by   Description  ===== ======== == ====== ========   1.0    …
full description		 Mgt Senfor Intl, Senfor International XLS XML
WIP Senfor Intl WIP Production Job Details
This program extracts job details with release and operation dates and elapsed times according to when the transactions were entered in Oracle. It is allows identifying job details to the operation level delays in production, for example when an operation is not completed or exceeds the time expected. The report can be run by any combination of organization, release dates, job, assembly, job status. License: Creative commons with Attribution by Ion Yılmaz, Senfor International, www.senfor-intl.eu
 Manufacturing Senfor International, WIP Senfor Intl XML