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

BI Publisher Service

155 reports

	Description
PER Position Hierarchy	Position hierarchy showing the reporting structure of positions with hierarchy level, organization, job, grade, location, budgeted vs actual headcount, vacancy count, and current incumbent names. Useful for position control, staffing analysis, and org chart construction.	Human Resources BI Publisher, Enginatics
BEN Default Enrollment Summary	Application: Advanced Benefits Source: Default Enrollment Summary Report (XML) Short Name: BENDFSUM_XML DB package: BEN_BENDFSUM_XMLP_PKG	Human Resources BI Publisher
BEN Dependent Eligibility Summary	Application: Advanced Benefits Source: Dependent Eligibility Summary Report (XML) Short Name: BENDESUM_XML DB package: BEN_BENDESUM_XMLP_PKG	Human Resources BI Publisher
BEN Extract Audit	Application: Advanced Benefits Source: Extract Audit Report (XML) Short Name: BENXAUDT_XML DB package: BEN_BENXAUDT_XMLP_PKG	Human Resources BI Publisher
BEN Extract Summary	Application: Advanced Benefits Source: Extract Summary Report (XML) Short Name: BENXSMRY_XML DB package: BEN_BENXSMRY_XMLP_PKG	Human Resources BI Publisher
BEN HIPAA Letter	Imported from BI Publisher Description: HIPAA Letter` Application: Advanced Benefits Source: HIPAA Letter (XML) Short Name: BENHIPAA_XML DB package: BEN_BENHIPAA_XMLP_PKG	Human Resources BI Publisher
HXT Actual and Rounded Time Punch	Application: Time and Labor Source: Actual and Rounded Time Punch (XML) Short Name: HXT958A_XML DB package: HXT_HXT958A_XMLP_PKG	Human Resources BI Publisher
HXT Earning Group Table Listing	Application: Time and Labor Source: Earning Group Table Listing (XML) Short Name: HXT957G_XML DB package: HXT_HXT957G_XMLP_PKG	Human Resources BI Publisher
HXT Earning Policy Table Listing	Application: Time and Labor Source: Earning Policy Table Listing (XML) Short Name: HXT956A_XML DB package: HXT_HXT956A_XMLP_PKG	Human Resources BI Publisher
HXT Holiday Calendar Table	Application: Time and Labor Source: Holiday Calendar Table Report (XML) Short Name: HXT957A_XML DB package: HXT_HXT957A_XMLP_PKG	Human Resources BI Publisher
HXT Organization Variance Calc	Application: Time and Labor Source: Organization Variance Calc (XML) Short Name: HXT951A_XML DB package: HXT_HXT951A_XMLP_PKG	Human Resources BI Publisher
HXT Shift Table Listing	Application: Time and Labor Source: Shift Table Listing (XML) Short Name: HXT957D_XML DB package: HXT_HXT957D_XMLP_PKG	Human Resources BI Publisher
HXT Total Table Entries	Application: Time and Labor Source: Total Table Entries (XML) Short Name: HXT957H_XML DB package: HXT_HXT957H_XMLP_PKG	Human Resources BI Publisher
HXT Variance Table Listing	Application: Time and Labor Source: Variance Table Listing (XML) Short Name: HXT957F_XML DB package: HXT_HXT957F_XMLP_PKG	Human Resources BI Publisher
OTA OLM Certification	Application: Learning Management Source: OLM Certification Report Short Name: OTACERT DB package: ota_cert_xmlp_pkg	Human Resources BI Publisher
OTA OLM Forum	Application: Learning Management Source: OLM Forum Report Short Name: OTAFRM DB package: OTA_FRM_XMLP_PKG	Human Resources BI Publisher
PER ADS Current Vacancy Details	Application: Human Resources Source: ADS Current Vacancy Details Short Name: ADSCURVACDET DB package:	Human Resources BI Publisher
PER Assignment Status	Imported from BI Publisher Description: Assignment Status Report Application: Human Resources Source: Assignment Status Report (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG	Human Resources BI Publisher
PER COBRA Payments	Imported from BI Publisher Description: COBRA Payments Report Application: Human Resources Source: COBRA Payments Report (XML) Short Name: PERRPCPR_XML DB package: PER_PERUSCPR_XMLP_PKG	Human Resources BI Publisher
PER EEO Consolidated	Imported from BI Publisher Description: EEO Consolidated Report Application: Human Resources Source: EEO Consolidated Report (XML) Short Name: PERRPEOC_XML DB package: PER_PERUSEOC_XMLP_PKG	Human Resources BI Publisher
PER Employee Missing Details	Imported from BI Publisher Description: French HRMS employee missing details report Application: Human Resources Source: Employee Missing Details Report (XML) Short Name: PERFREMD_XML DB package: PER_PERFREMD_XMLP_PKG	Human Resources BI Publisher
PER Invalid Address	Imported from BI Publisher Application: Human Resources Source: Invalid Address Report (XML) Short Name: PERRPADD_XML DB package: PER_PERRPADD_XMLP_PKG	Human Resources BI Publisher
PER Person Synchronization	Imported from BI Publisher Application: Human Resources Source: Person Synchronization Report (XML) Short Name: PERBGSYN_XML DB package: PER_PERBGSYN_XMLP_PKG	Human Resources BI Publisher
PER Requisition Summary	Imported from BI Publisher Description: Requisition Summary Report Application: Human Resources Source: Requisition Summary Report (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG	Human Resources BI Publisher
PQH EEO5 Reporting	Imported from BI Publisher Description: EEO5 Reporting Application: Public Sector HR Source: EEO5 Reporting (XML) Short Name: PQHEEO5_XML DB package: PQH_PQHEEO5_XMLP_PKG	Human Resources BI Publisher
PQH Position Summary	Imported from BI Publisher Application: Public Sector HR Source: Position Summary Report (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG	Human Resources BI Publisher
BEN Back-out Life Events Audit Log	Application: Advanced Benefits Source: Back-out Life Events Audit Log (XML) Short Name: BENBOAUD_XML DB package: BEN_BENBOAUD_XMLP_PKG	Human Resources BI Publisher
BEN Back-out Life Events Summary	Application: Advanced Benefits Source: Back-out Life Events Summary Report (XML) Short Name: BENBOSUM_XML DB package: BEN_BENBOSUM_XMLP_PKG	Human Resources BI Publisher
BEN Benefits ACA Errors	Imported from BI Publisher Application: Advanced Benefits Source: Benefits ACA Errors Report Short Name: BENACAERR DB package:	Human Resources BI Publisher
BEN Benefits ACA Persons Report for 1095C Printed Forms	Imported from BI Publisher Application: Advanced Benefits Source: Benefits ACA Persons Report for 1095C Printed Forms Short Name: BEN1095PRINTPRSNS DB package: BEN_1095PRINTPERSONS_XMLP_PKG	Human Resources BI Publisher
BEN Benefits Confirmation and Summary	Imported from BI Publisher Application: Advanced Benefits Source: Benefits Confirmation and Summary Report (XML) Short Name: BENSMREP_XML DB package: BEN_BENSMREP_XMLP_PKG	Human Resources BI Publisher
BEN COBRA Benefit Notification Letter	Imported from BI Publisher Description: COBRA Benefit Notification Letter Application: Advanced Benefits Source: COBRA Benefit Notification Letter (XML) Short Name: BENCOBN1_XML DB package: BEN_BEN_US_COBNL_XMLP_PKG	Human Resources BI Publisher
BEN COBRA Benefit Initial Information	Imported from BI Publisher Application: Advanced Benefits Source: COBRA Benefit Initial Information (XML) Short Name: BENCBRIN_XML DB package: BEN_BENCBRIN_XMLP_PKG	Human Resources BI Publisher
BEN Close Action Items Audit Log	Application: Advanced Benefits Source: Close Action Items Audit Log (XML) Short Name: BENUAAUD_XML DB package: BEN_BENUAAUD_XMLP_PKG	Human Resources BI Publisher
BEN Close Action Items Summary	Application: Advanced Benefits Source: Close Action Items Summary Report (XML) Short Name: BENUASUM_XML DB package: BEN_BENUASUM_XMLP_PKG	Human Resources BI Publisher
BEN Close Enrollments Audit Log	Application: Advanced Benefits Source: Close Enrollments Audit Log (XML) Short Name: BENCLAUD_XML DB package: BEN_BENCLAUD_XMLP_PKG	Human Resources BI Publisher
BEN Close Enrollments Summary	Application: Advanced Benefits Source: Close Enrollments Summary Report (XML) Short Name: BENCLSUM_XML DB package: BEN_BENCLSUM_XMLP_PKG	Human Resources BI Publisher
BEN Communications Triggers Audit Log	Application: Advanced Benefits Source: Communications Triggers Audit Log (XML) Short Name: BENCMAUD_XML DB package: BEN_BENCMAUD_XMLP_PKG	Human Resources BI Publisher
BEN Communications Triggers Summary	Application: Advanced Benefits Source: Communications Triggers Summary Report (XML) Short Name: BENCMSUM_XML DB package: BEN_BENCMSUM_XMLP_PKG	Human Resources BI Publisher
BEN Default Enrollment Audit Log	Application: Advanced Benefits Source: Default Enrollment Audit Log (XML) Short Name: BENDFAUD_XML DB package: BEN_BENDFAUD_XMLP_PKG	Human Resources BI Publisher
BEN Dependent Eligibility Audit Log	Application: Advanced Benefits Source: Dependent Eligibility Audit Log (XML) Short Name: BENDEAUD_XML DB package: BEN_BENDEAUD_XMLP_PKG	Human Resources BI Publisher
BEN Error By Error Type Report(Comm.)	Application: Advanced Benefits Source: Error By Error Type Report(Comm.) (XML) Short Name: BENCMETY_XML DB package: BEN_BENCMETY_XMLP_PKG	Human Resources BI Publisher
BEN Error By Person Report(Comm.)	Application: Advanced Benefits Source: Error By Person Report(Comm.) (XML) Short Name: BENCMEPE_XML DB package: BEN_BENCMEPE_XMLP_PKG	Human Resources BI Publisher
BEN Error Type	Application: Advanced Benefits Source: Error Type Report (XML) Short Name: BENERTYP_XML DB package: BEN_BENERTYP_XMLP_PKG	Human Resources BI Publisher
BEN Extract Layout	Application: Advanced Benefits Source: Extract Layout Report (XML) Short Name: BENXLAYT_XML DB package: BEN_BENXLAYT_XMLP_PKG	Human Resources BI Publisher
BEN Life Events Summary	Imported from BI Publisher Description: Life Events Summary Report Application: Advanced Benefits Source: Life Events Summary Report (XML) Short Name: BENLESUM_XML DB package: BEN_BENLESUM_XMLP_PKG	Human Resources BI Publisher
BEN Participation Audit Log	Application: Advanced Benefits Source: Participation Audit Log (XML) Short Name: BENAUDIT_XML DB package: BEN_BENAUDIT_XMLP_PKG	Human Resources BI Publisher
BEN Participation Error Detail Report by Error Type	Application: Advanced Benefits Source: Participation Error Detail Report by Error Type (XML) Short Name: BENERRTY_XML DB package: BEN_BENERRTY_XMLP_PKG	Human Resources BI Publisher
BEN Participation Process Reports Output	Imported from BI Publisher Application: Advanced Benefits Source: Participation Process Reports Output(XML) Short Name: BENERRPA DB package: BEN_BENERRPA_XMLP_PKG	Human Resources BI Publisher
BEN Participation Summary	Application: Advanced Benefits Source: Participation Summary Report (XML) Short Name: BENACTIV_XML DB package: BEN_BENACTIV_XMLP_PKG	Human Resources 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