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 143 AR 123 FA 138 CE 25 PO 116 INV 129 OM 89 MFG 214 COST 175 PA 131 HR 182 PAY 151 SYS 162
ORBIT

9 reports

DescriptionDownload
ORB Business Object and Assignments
List all business objects available to create report with domain name,logical model name and current assignment.
 ORBIT XML
ORB Logical and Physical Model Details(Data Report)
List the details of ORB Logical and Physical Model including the Database table name and INLINE SQL details for the Report
 ORBIT XML
ORB Report Assignment Details
Details of the Active Report Assignments. Report can be assigned to ROLE or USER. It also indicate if the assignee has access to run,copy,edit,delete,export the report
 ORBIT XML
ORB Report Columns
Report to List the Orbit Report Columns for the Report inclusing the physical column name and logical model object it uses
 ORBIT XML
ORB Report Execution History
Execution history of Orbit reports. This can be used when migrating from Orbit Reporting to Blitz Report, to analyze which Orbit reports were previously used by the business.
 ORBIT XML
ORB Report Execution Summary
Execution history of Orbit reports, summarized by users accessing the reports ,most frequent user and total user count. This can be used when migrating from Orbit Reporting to Blitz Report, to analyze which Orbit Report were previously used by the business
 ORBIT XML
ORB Report Parameters
Orbit Report Parameters with equivalent mapping for Blitz Report Parameter including datatype,LOV SQL .
 ORBIT XML
ORB Report and Details
Orbit Reporting reports, folders ,business object ,logical model ,physical model and domain these reports resides in.
 ORBIT XML
ORB User and Assigned Roles
All the Orbit Users and their Assigned roles which will help to find out which user has the required roles assigned
 ORBIT XML