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

131 reports

	Description
PA Summarization Period Exceptions	Application: Projects Source: EXC: Summarization Period Exceptions (XML) Short Name: PAXSMPRD_XML DB package: PA_PAXSMPRD_XMLP_PKG	Projects BI Publisher
PA Timecard Entry	Imported from BI Publisher Description: Timecard Entry Application: Projects Source: AUD: Timecard Entry (XML) Short Name: PAXPCTCE_XML DB package: PA_PAXPCTCE_XMLP_PKG	Projects BI Publisher
PA Units Definition	Application: Projects Source: IMP: Units Definition (XML) Short Name: PAXRWUDF_XML DB package: PA_PAXRWUDF_XMLP_PKG	Projects BI Publisher
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
PA Invoice Flow Detail	Application: Projects Source: FLW: Invoice Flow Detail (XML) Short Name: PAXPCIDF_XML DB package: PA_PAXPCIDF_XMLP_PKG	Projects BI Publisher
PA Invoice Flow Summary	Application: Projects Source: FLW: Invoice Flow Summary (XML) Short Name: PAXPCIFS_XML DB package: PA_PAXPCIFS_XMLP_PKG	Projects BI Publisher
PA Job Listing	Application: Projects Source: IMP: Job Listing (XML) Short Name: PAXPEJOB_XML DB package: PA_PAXPEJOB_XMLP_PKG	Projects BI Publisher
PA Labor Cost Rates Listing By Organization	Application: Projects Source: IMP: Labor Cost Rates Listing By Organization (XML) Short Name: PAXRWLCO_XML DB package: PA_PAXRWLCO_XMLP_PKG	Projects BI Publisher
PA List Organization Forecast Exceptions	Imported from BI Publisher Description: Organization Forecast Exceptions Report Application: Projects Source: PRC: List Organization Forecast Exceptions (XML) Short Name: PAFPEXRP_XML DB package: PA_PAFPEXRP_XMLP_PKG	Projects BI Publisher
PA Maintain Project Resources	Application: Projects Source: PRC: Maintain Project Resources (XML) Short Name: PARCPRJR_XML DB package: PA_PARCPRJR_XMLP_PKG	Projects BI Publisher
PA Non-Labor Resources By Organization	Application: Projects Source: IMP: Non-Labor Resources By Organization (XML) Short Name: PAXRWNLR_XML DB package: PA_PAXRWNLR_XMLP_PKG	Projects BI Publisher
PA Pay When Paid Release Audit	Application: Projects Source: AUD: Pay When Paid Release Audit Short Name: PAPWPRIREP DB package: PA_PAPWPRIREP_XMLP_PKG	Projects BI Publisher
PA Payroll Distribution Employee Detail	Application: Projects Source: AUD: Payroll Distribution Employee Detail Report Short Name: PAPAYREP DB package:	Projects BI Publisher
PA Perform Action Rules	Application: Projects Source: PRC: Perform Action Rules (XML) Short Name: PAPERACTRULES_XML DB package: PA_PAPERACR_XMLP_PKG	Projects BI Publisher
PA Potential Revenue Summary	Application: Projects Source: MGT: Potential Revenue Summary (XML) Short Name: PAXPCPRS_XML DB package: PA_PAXPCPRS_XMLP_PKG	Projects BI Publisher
PA Process Mass Update Batches	Application: Projects Source: PRC: Process Mass Update Batches (XML) Short Name: PAXBAUPD_XML DB package: PA_PAXBAUPD_XMLP_PKG	Projects BI Publisher
PA Process Payroll Actuals	Application: Projects Source: AUD: Process Payroll Actuals Short Name: PAPAYAUD DB package:	Projects BI Publisher
PA Process Payroll Actuals Exception	Application: Projects Source: PRC: Process Payroll Actuals Exception Report Short Name: PAPAYEXC DB package:	Projects BI Publisher
PA Project Configuration	Imported from BI Publisher Description: Project Configuration Application: Projects Source: AUD: Project Configuration (XML) Short Name: PAXPRCON_XML DB package: PA_PAXPRCON_XMLP_PKG	Projects BI Publisher
PA Project Expenditure Adjustment Activity	Application: Projects Source: AUD: Project Expenditure Adjustment Activity (XML) Short Name: PAXEXADJ_XML DB package: PA_PAXEXADJ_XMLP_PKG	Projects BI Publisher
PA Project Subledger: Detail by Project	Imported from BI Publisher Description: AUD: Project Subledger: Detail by Project: Shows the transactions in Oracle Projects for a GL account projectwise Application: Projects Source: AUD: Project Subledger: Detail by Project (XML) Short Name: PAXMGSLD_XML DB package: PA_PAXMGSLD_XMLP_PKG	Projects BI Publisher
PA Project Tasks and Budgets	Summary project report showing operating unit, project number, project name, description, type, status, start date, completion date, closed date, task information, budget information.	Projects Draft
PA Purge Project Data	Application: Projects Source: ADM: Purge Project Data (XML) Short Name: PAXARPPR_XML DB package: PA_PAXARPPR_XMLP_PKG	Projects BI Publisher
PA Push Order	Imported from BI Publisher Description: Concurrent Program to generate XML for Order details to push to G-Invoice System Application: Projects Source: MGT:Push Order Short Name: PAGOPUSH_XML DB package: PA_PAGOPUSH_XMLP_PKG	Projects BI Publisher
PA Rebuild Timeline for a Range of Resources	Imported from BI Publisher Description: Rebuild Timeline for a Range of Resources Application: Projects Source: PRC: Rebuild Timeline for a Range of Resources (XML) Short Name: PARLBLDG_XML DB package: PA_PARLBLDG_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