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
R12 only

5 reports

DescriptionDownload
PA Capital Project Summary with Asset Detail
Detail project report that shows the project asset details, and combined project level costs breakdown, along with the project assets details from the Capital Summary
 Projects Enginatics, R12 only XLS XML
PA Project Expenditure Items with WIP and INV Detail
Project expenditure items showing WIP and inventory transaction details including transaction types, quantities, WIP job, assembly, department, resource, and inventory item information.
 Projects Enginatics, R12 only XLS XML
PA Supplier Invoice Audit
AP invoices charged to projects showing vendor, invoice, cost distribution, and GL transfer details for supplier expenditure audit.
 Projects Enginatics, R12 only XLS XML
PA Revenue, Cost, Budgets by Resources
This Blitz Report is the implements the following standard oracle reports. - MGT: Task - Revenue, Cost, Budgets by Resources - MGT: Revenue, Cost, Budgets by Resources (Project Level) The 'Report Level' parameter determines if the report is run at the Project Level or Task Level Report Level Parameter: Project - equivalent to running the MGT: Revenue, Cost, Budgets by Resources (Project Level) report Task - equivalent to running the MGT: Task - Revenue, Cost, Budgets by Resources report The report has been extended to pull in additional datapoints as displayed in the Project Status…
full description		 Projects Enginatics, R12 only XML
PA Revenue, Cost, Budgets by Work Breakdown Structure
This Blitz report implements the standard Oracle report: MGT: Revenue, Cost, Budgets by Work Breakdown Structure (XML) The 'Report Level' parameter determines if the report is run at the Project Level or Task Level Report Level Parameter: Project - will pull back revenue, costs and budgets accumulated at the project level Task - will pull back revenue, costs and budgets accumulated at the task level The report has been extended to pull in additional datapoints as displayed in the Project Status Inquiry Form. Application: Projects Source: MGT: Revenue, Cost, Budgets by Work Breakdown…
full description		 Projects Enginatics, R12 only XML