Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

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

3,151 reports

	Description
OPM Recipie Diagnostics		Manufacturing
OPM Transactions, Reservations, Pending Product Lots	Listing of OPM transactions with reservations and pending product lot details.	Manufacturing
OPM WIP Value - V2		Manufacturing
OPM batch steps resources	Listing of OPM batch step resources How to Analyze OPM Variances FAQ (Doc ID 371064.1)	Manufacturing
OPM2
ORB Business Object and Assignments	List all business objects available to create report with domain name,logical model name and current assignment.	ORBIT
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
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
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
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
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
ORB Report Parameters	Orbit Report Parameters with equivalent mapping for Blitz Report Parameter including datatype,LOV SQL .	ORBIT
ORB Report and Details	Orbit Reporting reports, folders ,business object ,logical model ,physical model and domain these reports resides in.	ORBIT
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
OTA Attendance Signature Sheet	Imported from BI Publisher Description: Attendance Signature Sheet Report Application: Learning Management Source: Attendance Signature Sheet Report (XML) Short Name: OTARPATT_XML DB package: OTA_OTARPATT_XMLP_PKG	Human Resources BI Publisher
OTA Budget Costs Breakdown	Application: Learning Management Source: Budget Costs Breakdown Report (XML) Short Name: OTARPBUD_XML DB package: OTA_OTARPBUD_XMLP_PKG	Human Resources BI Publisher
OTA Budget and Cost Reconciliation	Imported from BI Publisher Description: Budget and Cost Reconciliation Report Application: Learning Management Source: Budget and Cost Reconciliation Report (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG	Human Resources BI Publisher
OTA Learner Sign-In Sheet	Imported from BI Publisher Description: Attendance Signature Sheet Report Application: Learning Management Source: Learner Sign-In Sheet (XML) Short Name: OTARPSIS_XML DB package: OTA_OTARPSIS_XMLP_PKG	Human Resources BI Publisher
OTA OLM Chat	Application: Learning Management Source: OLM Chat Report Short Name: OTACHT DB package: OTA_CHT_XMLP_PKG	Human Resources BI Publisher
OTA OLM Course Evaluation	Application: Learning Management Source: OLM Course Evaluation Report Short Name: OTAEVAL DB package: OTA_EVAL_XMLP_PKG	Human Resources BI Publisher
OTA OLM Learning Path	Application: Learning Management Source: OLM Learning Path Report Short Name: OTALP DB package: OTA_LP_XMLP_PKG	Human Resources BI Publisher
OTA Registration	Imported from BI Publisher Description: Registration Report Application: Learning Management Source: Registration Report (XML) Short Name: OTARPREG_XML DB package: OTA_OTARPREG_XMLP_PKG	Human Resources BI Publisher
Open order lines
P2P Report		Training Purposes
PA AUD: Expenditure Batch Status	Application: Projects Source: AUD: Expenditure Batch Status (XML) Short Name: PAXPCEGS_XML DB package: PA_PAXPCEGS_XMLP_PKG	Projects BI Publisher
PA AutoAccounting Functions	Imported from BI Publisher Description: AutoAccounting Functions Application: Projects Source: IMP: AutoAccounting Functions (XML) Short Name: PAXAAFTP_XML DB package: PA_PAXAAFTP_XMLP_PKG	Projects BI Publisher
PA AutoAccounting Rule Definitions	Application: Projects Source: IMP: AutoAccounting Rule Definitions (XML) Short Name: PAXAARUL_XML DB package: PA_PAXAARUL_XMLP_PKG	Projects BI Publisher
PA AutoAccounting Segment Rule Pairings	Application: Projects Source: IMP: AutoAccounting Segment Rule Pairings (XML) Short Name: PAXAASRP_XML DB package: PA_PAXAASRP_XMLP_PKG	Projects BI Publisher
PA Collect Dimension and Fact Tables	Application: Projects Source: PRC: Collect Dimension and Fact Tables Short Name: PAADWCP	Projects
PA Compile All Burden Schedule Revisions	Imported from BI Publisher Description: Compile All Burden Schedule Revisions Application: Projects Source: PRC: Compile All Burden Schedule Revisions (XML) Short Name: PAXCCARS_XML DB package: PA_PAXCCARS_XMLP_PKG	Projects BI Publisher
PA Costs ALL Projects	Collect all project costs	Projects
PA Create Accounting	Imported from BI Publisher Description: Create Accounting Program Application: Projects Source: PRC: Create Accounting Short Name: PAXACCPB DB package: XLA_CREATE_ACCT_RPT_PVT	Projects BI Publisher
PA Cross Charge Audit	Imported from BI Publisher Description: AUD: Cross Charge Audit Report Application: Projects Source: AUD: Cross Charge Audit Report (XML) Short Name: PAXCCGLA_XML DB package: PA_PAXCCGLA_XMLP_PKG	Projects BI Publisher
PA Delete PA Periods	Application: Projects Source: PRC: Delete PA Periods Short Name: PAXDELPA DB package: PA_PERIODS_MODIFICATION_PKG	Projects BI Publisher
PA Delete Revaluated Funding for a Range of Projects	Imported from BI Publisher Description: Delete Revaluated Funding for a Range of Projects Application: Projects Source: PRC: Delete Revaluated Funding for a Range of Projects (XML) Short Name: PAXPRFRP_DELETE_XML DB package: PA_PAXPRFRP_XMLP_PKG	Projects BI Publisher
PA Distribute Labor Costs	Imported from Concurrent Program Description: Distribute Labor Costs Application: Projects Source: PRC: Distribute Labor Costs Short Name: PALDLC	Projects Concurrent Program
PA Employee Assignment	Application: Projects Source: IMP: Employee Assignment (XML) Short Name: PAXPEAST_XML DB package: PA_PAXPEAST_XMLP_PKG	Projects BI Publisher
PA Employee Assignments By Organization	Application: Projects Source: IMP: Employee Assignments By Organization (XML) Short Name: PAXPEEMO_XML DB package: PA_PAXPEEMO_XMLP_PKG	Projects BI Publisher
PA Expense Report Entry	Imported from BI Publisher Description: Expense Report Entry Application: Projects Source: AUD: Expense Report Entry (XML) Short Name: PAXEXONE_XML DB package: PA_PAXEXONE_XMLP_PKG	Projects BI Publisher
PA Federal SF 1034	Application: Projects Source: MGT: Federal SF 1034 Short Name: PAXFBPVS_XML DB package:	Projects BI Publisher
PA Federal SF 1035	Application: Projects Source: MGT: Federal SF 1035 Short Name: PAXFBPVD_XML DB package:	Projects BI Publisher
PA Federal SF 1443	Application: Projects Source: MGT: Federal SF 1443 Short Name: PAXFBPPS_XML DB package:	Projects BI Publisher
PA Generate Allocations Transactions	Imported from BI Publisher Description: Generate Allocations Transactions Application: Projects Source: PRC: Generate Allocations Transactions (XML) Short Name: PAXALGAT_XML DB package: PA_PAXALRUN_XMLP_PKG	Projects BI Publisher
PA Generate Asset Lines for a Range of Projects	Application: Projects Source: PRC: Generate Asset Lines for a Range of Projects (XML) Short Name: PAXCPGAL_XML DB package: PA_PAXCPGAL_XMLP_PKG	Projects BI Publisher
PA Generate Asset Lines for a Single Project	Imported from BI Publisher Description: Generate Asset Lines for a Single Project Application: Projects Source: PRC: Generate Asset Lines for a Single Project (XML) Short Name: PAXCPGAL_SINGLE_XML DB package: PA_PAXCPGAL_XMLP_PKG	Projects BI Publisher
PA Generate Calendar Schedules for a Range of Calendars	Imported from BI Publisher Description: Generate Calendar Schedules for a Range of Calendars Application: Projects Source: PRC: Generate Calendar Schedules for a Range of Calendars (XML) Short Name: PARGCALG_XML DB package: PA_PARGCALG_XMLP_PKG	Projects BI Publisher
PA Generate Cross Charge Accounting Events	Application: Projects Source: PRC: Generate Cross Charge Accounting Events (XML) Short Name: PACCSLAR_XML DB package: PA_PACCGLTR_XMLP_PKG	Projects BI Publisher
PA Implementation Options	Application: Projects Source: IMP: Implementation Options (XML) Short Name: PAXRWIMP_XML DB package: PA_PAXRWIMP_XMLP_PKG	Projects BI Publisher
PA Interface Assets to Oracle Assets	Application: Projects Source: PRC: Interface Assets to Oracle Assets (XML) Short Name: PAXCPCAL_XML DB package: PA_PAXCPCAL_XMLP_PKG	Projects BI Publisher
PA Interfaced CIP/RWIP Amounts by FA Period	Imported from BI Publisher Description: Report that displayes the interfaced CIP and RWIP Amounts Application: Projects Source: AUD: Interfaced CIP/RWIP Amounts by FA Period Report (XML) Short Name: PACRCIPF_XML DB package: PA_PACRCIPF_XMLP_PKG	Projects BI Publisher

Blitz Report™ Library

The Blitz Report™ library is a collection of operational and diagnostic reports for Oracle E-Business Suite

Also found in SQL, tables and columns