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

BI Publisher Service

1,745 reports

	Description
HXC Missing Timecard	Imported from BI Publisher Description: OTL Missing Timecard Report Application: Time and Labor Engine Source: Missing Timecard Report (XML) Short Name: HXCMISTC_XML DB package: HXC_HXCMISTC_XMLP_PKG	BI Publisher
HXC Retrieval Error Handling	Application: Time and Labor Engine Source: Retrieval Error Handling Report (XML) Short Name: HXCRTERR_XML DB package: HXC_HXCRTERR_XMLP_PKG	BI Publisher
HXC Timecard Audit Trail	Application: Time and Labor Engine Source: OTL: Timecard Audit Trail Report Short Name: HXCRPTAUD DB package: HXC_RPT_TC_AUDIT_TRAIL	BI Publisher
HXT Earning Variance Calculation	Application: Time and Labor Source: Earning Variance Calculation (XML) Short Name: HXT953A_XML DB package: HXT_HXT953A_XMLP_PKG	Human Resources BI Publisher
HXT Hour Deduction Plcy Tbl List	Application: Time and Labor Source: Hour Deduction Plcy Tbl List (XML) Short Name: HXT956B_XML DB package: HXT_HXT956B_XMLP_PKG	Human Resources BI Publisher
HXT Location Variance Calculation	Application: Time and Labor Source: Location Variance Calculation (XML) Short Name: HXT952A_XML DB package: HXT_HXT952A_XMLP_PKG	Human Resources BI Publisher
HXT Manual and Autogen	Application: Time and Labor Source: Manual and Autogen Report (XML) Short Name: HXT970A_XML DB package: HXT_HXT970A_XMLP_PKG	Human Resources BI Publisher
HXT OTLR Missing Timecard	Application: Time and Labor Source: OTLR Missing Timecard Report (XML) Short Name: HXT964A_XML DB package: HXT_HXT964A_XMLP_PKG	Human Resources BI Publisher
HXT Periodic Late Clock-In	Application: Time and Labor Source: Periodic Late Clock-In Report (XML) Short Name: HXT959A_XML DB package: HXT_HXT959A_XMLP_PKG	Human Resources BI Publisher
HXT Person/Assignment Table List	Application: Time and Labor Source: Person/Assignment Table List (XML) Short Name: HXT957I_XML DB package: HXT_HXT957I_XMLP_PKG	Human Resources BI Publisher
HXT Prem. Interaction Plcy Tbl Lst	Application: Time and Labor Source: Prem. Interaction Plcy Tbl Lst (XML) Short Name: HXT956E_XML DB package: HXT_HXT956E_XMLP_PKG	Human Resources BI Publisher
HXT Premium Elg. Policy Tbl List	Application: Time and Labor Source: Premium Elg. Policy Tbl List (XML) Short Name: HXT956D_XML DB package: HXT_HXT956D_XMLP_PKG	Human Resources BI Publisher
HXT Project Accounting Table List	Application: Time and Labor Source: Project Accounting Table List (XML) Short Name: HXT957E_XML DB package: HXT_HXT957E_XMLP_PKG	Human Resources BI Publisher
HXT Rotation Plan Table Listing	Application: Time and Labor Source: Rotation Plan Table Listing (XML) Short Name: HXT957C_XML DB package: HXT_HXT957C_XMLP_PKG	Human Resources BI Publisher
HXT Shift Diff. Pol. Table Listing	Application: Time and Labor Source: Shift Diff. Pol. Table Listing (XML) Short Name: HXT956C_XML DB package: HXT_HXT956C_XMLP_PKG	Human Resources BI Publisher
HXT Time Entry Detail	Application: Time and Labor Source: OTL: Time Entry Detail Report Short Name: HXTDETRPT DB package: HXT_DET_HRS_WORKED_RPT	Human Resources BI Publisher
HXT Time Management to Project Accounting Retrieval	Application: Time and Labor Source: OTL: Time Management to Project Accounting Retrieval Report Short Name: HXTPATRAN DB package: HXT_TRAN_PA_RPT	Human Resources BI Publisher
HXT Total Hours To BEE	Application: Time and Labor Source: Total Hours To BEE (XML) Short Name: HXT007A_XML DB package: HXT_HXT007A_XMLP_PKG	Human Resources BI Publisher
HXT Work Plan Table Listing	Application: Time and Labor Source: Work Plan Table Listing (XML) Short Name: HXT957B_XML DB package: HXT_HXT957B_XMLP_PKG	Human Resources BI Publisher
ICX Military Interdepartmental Purchase Request	Application: Oracle iProcurement Source: Short Name: ICXCLMREQ_XML DB package: ICX_DATATEMPLATE_PKG	Purchasing BI Publisher
IGC Contract Commitment Archive Purge Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Contract Commitment Archive Purge Report Application: Contract Commitment Source: Contract Commitment Archive Purge Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCCAPRR_XML DB package: IGC_IGCCAPRR_XMLP_PKG	BI Publisher
IGC Contract Commitment Complete Cover Commitment Exception Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Contract Commitment Complete Cover Commitment Exception Report Application: Contract Commitment Source: Contract Commitment Complete Cover Commitment Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCCCOVR_XML DB package: IGC_IGCCYRPR_XMLP_PKG	BI Publisher
IGC Contract Commitment Display Results - draft	Application: Contract Commitment Source: Contract Commitment Display Results (XML) - Not Supported: Reserved For Future Use Short Name: IGCBDTRR_XML DB package: IGC_IGCBDTRR_XMLP_PKG	BI Publisher
IGC Contract Commitment Mass Payment Forecast Shift Exception Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Contract Commitment Mass Payment Forecast Shift Exception Report Application: Contract Commitment Source: Contract Commitment Mass Payment Forecast Shift Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCCMPPR_XML DB package: IGC_IGCCYRPR_XMLP_PKG	BI Publisher
IGC Contract Commitment Open Interface Exception Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Contract Commitment Open Interface Exception Report Application: Contract Commitment Source: Contract Commitment Open Interface Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCCLDER_XML DB package: IGC_IGCCLDER_XMLP_PKG	BI Publisher
IGC Contract Commitment Revaluation Exception Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Contract Commitment Revaluation Exception Report Application: Contract Commitment Source: Contract Commitment Revaluation Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCCRVPR_XML DB package: IGC_IGCCYRPR_XMLP_PKG	BI Publisher
IGC Contract Commitment Revaluation Fix Exception - draft	Application: Contract Commitment Source: Contract Commitment Revaluation Fix Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCCRVFR_XML DB package: IGC_IGCCYRPR_XMLP_PKG	BI Publisher
IGC Purchasing Year End Exception Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Purchasing Year End Exception Report Application: Contract Commitment Source: Purchasing Year End Exception Report (XML) - Not Supported: Reserved For Future Use Short Name: IGCPOYEE_XML DB package: IGC_IGCPOYEE_XMLP_PKG	BI Publisher
IGI Application Wide Features Status - draft	Application: Public Sector Financials International Source: IGI: Application Wide Features Status Report (XML) - Not Supported: Reserved For Future Use Short Name: IGILGCCD_XML DB package: IGI_IGILGCCD_XMLP_PKG	BI Publisher
IGI Balanced Budget History Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: BUD: Budgeting: Balanced Budget History Report Application: Public Sector Financials International Source: Budgeting: Balanced Budget History Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIGBHRB_XML DB package: IGI_IGIGBHRB_XMLP_PKG	BI Publisher
IGI Balanced Budget Journal Input Proforma- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: BUD: Budgeting: Balanced Budget Journal Input Proforma Application: Public Sector Financials International Source: Budgeting: Balanced Budget Journal Input Proforma (XML) - Not Supported: Reserved For Future Use Short Name: IGIGBIPB_XML DB package: IGI_IGIGBIPB_XMLP_PKG	BI Publisher
IGI Balanced Budget Journal Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: BUD: Budgeting: Balanced Budget Journal Report Application: Public Sector Financials International Source: Budgeting: Balanced Budget Journal Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIGBJRB_XML DB package: IGI_IGIGBJRB_XMLP_PKG	BI Publisher
IGI CIS Resubmit: Monthly Returns History	Application: Public Sector Financials International Source: IGI CIS Resubmit: Monthly Returns History Report Short Name: IGIPMTHRAR DB package:	BI Publisher
IGI CIS Resubmit: Monthly Returns View	Application: Public Sector Financials International Source: IGI CIS Resubmit: Monthly Returns View Report Short Name: IGIPMTHRVR DB package:	BI Publisher
IGI CIS2007 Monthly Returns	Imported from BI Publisher Description: Construction Industry Scheme : Monthly Returns Report Application: Public Sector Financials International Source: IGI : CIS2007 Monthly Returns Report Short Name: IGIPMTHR_XMLP DB package: igi_cis_igipmthp_pkg	BI Publisher
IGI CIS2007 Registered Supplier Listing	Imported from BI Publisher Description: Construction Industry Scheme : Registered Supplier Listing Report Application: Public Sector Financials International Source: IGI : CIS2007 Registered Supplier Listing Report Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG	BI Publisher
IGI CIS2007 Subcontractor Statement of Payment and Deductions	Application: Public Sector Financials International Source: IGI : CIS2007 Subcontractor Statement of Payment and Deductions Report Short Name: IGIPPADR_XMLP DB package: IGI_CIS2007_IGIPPADR_PKG	BI Publisher
IGI CIS2007 Subcontractor Verification Status	Imported from BI Publisher Description: Construction Industry Scheme : Subcontractor Verification Status Report Application: Public Sector Financials International Source: IGI : CIS2007 Subcontractor Verification Status Report Short Name: IGIPVERR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG	BI Publisher
IGI Combined Basis Reports: Detail Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Combined Basis Reports: Detail Report Application: Public Sector Financials International Source: Combined Basis Reports: Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIGCBGD_XML DB package: IGI_IGIGCBGD_XMLP_PKG	BI Publisher
IGI Combined Basis Reports: Payables Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Combined Basis Reports: Payables Report Application: Public Sector Financials International Source: Combined Basis Reports: Payables Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIPCBAP_XML DB package: IGI_IGIPCBAP_XMLP_PKG	BI Publisher
IGI Combined Basis Reports: Receivables - draft	Application: Public Sector Financials International Source: Combined Basis Reports: Receivables Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIRCCBR_XML DB package: IGI_IGIRCCBR_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Adjustments Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Inflation Accounting : Adjustments Report Application: Public Sector Financials International Source: Inflation Accounting : Adjustments Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIACAR_XML DB package: IGI_IGIIACAR_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Asset Revaluation Preview Detail - draft	Application: Public Sector Financials International Source: Inflation Accounting : Asset Revaluation Preview Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIARPR_XML DB package: IGI_IGIIARPR_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Asset Revaluation Preview Summary - draft	Application: Public Sector Financials International Source: Inflation Accounting : Asset Revaluation Preview Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIARPS_XML DB package: IGI_IGIIARPS_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Backlog Detail Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Inflation Accounting : Backlog Detail Report Application: Public Sector Financials International Source: Inflation Accounting : Backlog Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIABLD_XML DB package: IGI_IGIIABLD_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Backlog Summary Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Inflation Accounting : Backlog Summary Report Application: Public Sector Financials International Source: Inflation Accounting : Backlog Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIABLS_XML DB package: IGI_IGIIABLS_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Cost Detail Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Inflation Accounting : Cost Detail Report Application: Public Sector Financials International Source: Inflation Accounting : Cost Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIACSD_XML DB package: IGI_IGIIACSD_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Cost Summary Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Inflation Accounting : Cost Summary Report Application: Public Sector Financials International Source: Inflation Accounting : Cost Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIACST_XML DB package: IGI_IGIIACST_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Operating Expense Detail Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Inflation Accounting : Operating Expense Detail Report Application: Public Sector Financials International Source: Inflation Accounting : Operating Expense Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIAOPD_XML DB package: IGI_IGIIAOPD_XMLP_PKG	BI Publisher
IGI Inflation Accounting : Operating Expense Summary Report- Not Supported: Reserved For Future Use	Imported from BI Publisher Description: Inflation Accounting : Operating Expense Summary Report Application: Public Sector Financials International Source: Inflation Accounting : Operating Expense Summary Report (XML) - Not Supported: Reserved For Future Use Short Name: IGIIAOPE_XML DB package: IGI_IGIIAOPE_XMLP_PKG	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