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

3,151 reports

DescriptionDownload
PO Receiving Transactions Register
Imported from BI Publisher Description: Receiving Transactions Register Application: Purchasing Source: Receiving Transactions Register (XML) Short Name: RCVTXRTR_XML DB package: PO_RCVTXRTR_new_XMLP_PKG
 Purchasing BI Publisher XML
PO Receiving Value
Imported from BI Publisher Description: Receiving Value Report Application: Purchasing Source: Receiving Value Report (XML) Short Name: POXRRCVV_XML DB package: PO_POXRRCVV_XMLP_PKG
 Purchasing BI Publisher XML
PO ReqExpress Templates Listing
Imported from BI Publisher Description: ReqExpress Template Listing Application: Purchasing Source: ReqExpress Templates Listing (XML) Short Name: POXRQEXP_XML DB package: PO_POXRQEXP_XMLP_PKG
 Purchasing BI Publisher XML
PO Requisitions on Cancelled Order
Imported from BI Publisher Description: Requisitions on Cancelled Order Report Application: Purchasing Source: Requisitions on Cancelled Order Report (XML) Short Name: POXRQRCO_XML DB package: PO_POXRQRCO_XMLP_PKG
 Purchasing BI Publisher XML
PO Savings Analysis Report(by Buyer)
Imported from BI Publisher Description: Savings Analysis Report(by Buyer) Application: Purchasing Source: Savings Analysis Report(by Buyer) (XML) Short Name: POXKISUM_XML DB package: PO_POXKISUM_XMLP_PKG
 Purchasing BI Publisher XML
PO Savings Analysis Report(by Category)
Imported from BI Publisher Description: Savings Analysis Report(by Category) Application: Purchasing Source: Savings Analysis Report(by Category) (XML) Short Name: POXKIAGN_XML DB package: PO_POXKIAGN_XMLP_PKG
 Purchasing BI Publisher XML
PO Substitute Receipts
Imported from BI Publisher Description: Substitute Receipts Report Application: Purchasing Source: Substitute Receipts Report (XML) Short Name: POXRVRSR_XML DB package: PO_POXRVRSR_XMLP_PKG
 Purchasing BI Publisher XML
PO Undefinitized Contract Actions
Application: Purchasing Source: Undefinitized Contract Actions Report Short Name: POUCA DB package: PO_UCA
 Purchasing BI Publisher XML
PO Unordered Receipts
Imported from BI Publisher Description: Unordered Receipts Report Application: Purchasing Source: Unordered Receipts Report (XML) Short Name: POXRVRUR_XML DB package: PO_POXRVRUR_XMLP_PKG
 Purchasing BI Publisher XML
PO Vendor Price Performance Analysis
Imported from BI Publisher Description: Vendor Price Performance Analysis Report Application: Purchasing Source: Vendor Price Performance Analysis Report (XML) Short Name: POXPRIPR_XML DB package: PO_POXPRIPR_XMLP_PKG
 Purchasing BI Publisher XML
PO Vendor Quality Performance Analysis
Imported from BI Publisher Description: Vendor Quality Performance Analysis Report Application: Purchasing Source: Vendor Quality Performance Analysis Report (XML) Short Name: POXQUAPR_XML DB package: PO_POXQUAPR_XMLP_PKG
 Purchasing BI Publisher XML
PO Vendor Volume Analysis
Imported from BI Publisher Description: Vendor Volume Analysis Report Application: Purchasing Source: Vendor Volume Analysis Report (XML) Short Name: POXVCVAR_XML DB package: PO_POXVCVAR_XMLP_PKG
 Purchasing BI Publisher XML
PO Vendors on Hold
Application: Purchasing Source: Vendors on Hold Report (XML) Short Name: POXVDVOH_XML DB package: PO_POXVDVOH_XMLP_PKG
 Purchasing BI Publisher XML
PO View Award Changes Data Definition
Imported from BI Publisher Application: Purchasing Source: Short Name: PO_VIEW_AWARD_CHANGES DB package:
 Purchasing BI Publisher XML
PON Amendment Data Template
Application: Sourcing Source: Short Name: PON_AMEND DB package: PON_SGD_PKG
 Purchasing BI Publisher XML
PON FedBizOpps Compliance
Application: Sourcing Source: FedBizOpps Compliance Short Name: PONXFEDOPPS_XML DB package: PON_PONXFEDOPPS_XMLP_PKG
 Purchasing BI Publisher XML
PON Solicitation data template
Application: Sourcing Source: Short Name: PON_SOLICIT DB package: pon_datatemplate_pkg
 Purchasing BI Publisher XML
POS Generate Supplier
Application: iSupplier Portal Source: Short Name: POSGENRPT DB package: POS_SUPP_GENERATE_RPT_PKG
 BI Publisher XML
POS Integrated Supplier Import Rejections
Application: iSupplier Portal Source: Integrated Supplier Import Rejections Report Short Name: POS_SUPP_IMP_REJ_REP DB package:
 BI Publisher XML
POS POSASNDATA
Application: iSupplier Portal Source: Short Name: POSASNDATA DB package: POS_CANCEL_ASN
 BI Publisher XML
PQH Annual Status
Imported from BI Publisher Description: Tenure: Annual Status Report Application: Public Sector HR Source: Tenure: Annual Status Report (XML) Short Name: PQHUSASR_XML DB package: PQH_PQHUSASR_XMLP_PKG
 Human Resources BI Publisher XML
PQH Budget Period Position Detail
Imported from BI Publisher Application: Public Sector HR Source: Budget Period Position Detail Report (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG
 Human Resources BI Publisher XML
PQH EEO4 Reporting
Imported from BI Publisher Description: EEO4 Reporting Application: Public Sector HR Source: EEO4 Reporting (XML) Short Name: PQHEEO4_XML DB package: PQH_PQHEEO4_XMLP_PKG
 Human Resources BI Publisher XML
PQH Entity Element Summary
Imported from BI Publisher Application: Public Sector HR Source: Entity Element Summary Report (XML) Short Name: PQHWSEES_XML DB package: PQH_PQHWSEES_XMLP_PKG
 Human Resources BI Publisher XML
PQH Existing Profile
Imported from BI Publisher Description: Tenure: Existing Profile Report Application: Public Sector HR Source: Tenure: Existing Profile Report (XML) Short Name: PQHUSEPR_XML DB package: PQH_PQHUSEPR_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Employees By Assigned Position (EAP) - Part A(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Employees By Assigned Position (EAP) - Part A (XML) (obsoleted) Short Name: PQIPED1_XML DB package: PQH_PQIPED1_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Employees By Assigned Position (EAP) - Part B(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Employees By Assigned Position (EAP) - Part B (XML) (obsoleted) Short Name: PQIPED2_XML DB package: PQH_PQIPED2_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part A(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Non-Degree Granting Institutions (S2) - Part A (XML) (obsoleted) Short Name: PQIPED10_XML DB package: PQH_PQIPED10_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Non-Degree Granting Institutions (S2) - Part B(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Non-Degree Granting Institutions (S2) - Part B (XML) (obsoleted) Short Name: PQIPED11_XML DB package: PQH_PQIPED11_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Salary and Fringe Benefits Survey (SA) - Part A(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Salary and Fringe Benefits Survey (SA) - Part A (XML) (obsoleted) Short Name: PQIPED3_XML DB package: PQH_PQIPED3_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Staff Survey (S1) - Part A(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Staff Survey (S1) - Part A (XML) (obsoleted) Short Name: PQIPED5_XML DB package: PQH_PQIPED5_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Staff Survey (S1) - Part B(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Staff Survey (S1) - Part B (XML) (obsoleted) Short Name: PQIPED6_XML DB package: PQH_PQIPED6_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Staff Survey (S1) - Part D(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Staff Survey (S1) - Part D (XML) (obsoleted) Short Name: PQIPED7_XML DB package: PQH_PQIPED7_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Staff Survey (S1) - Part F(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Staff Survey (S1) - Part F (XML) (obsoleted) Short Name: PQIPED8_XML DB package: PQH_PQIPED8_XMLP_PKG
 Human Resources BI Publisher XML
PQH IPEDS Report - Staff Survey (S1) - Part G(obsoleted)
Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Staff Survey (S1) - Part G (XML) (obsoleted) Short Name: PQIPED9_XML DB package: PQH_PQIPED9_XMLP_PKG
 Human Resources BI Publisher XML
PQH Notification for Tenure-track Status
Imported from BI Publisher Description: Notification for Tenure-track Status Application: Public Sector HR Source: Notification for Tenure-track Status (XML) Short Name: PQHUSNTT_XML DB package: PQH_PQHUSNTT_XMLP_PKG
 Human Resources BI Publisher XML
PQH Organizational Position Summary
Imported from BI Publisher Application: Public Sector HR Source: Organizational Position Summary Report (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG
 Human Resources BI Publisher XML
PQH Position Element Detail
Imported from BI Publisher Application: Public Sector HR Source: Position Element Detail Report (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG
 Human Resources BI Publisher XML
PQH Position Element Summary
Imported from BI Publisher Application: Public Sector HR Source: Position Element Summary Report (XML) Short Name: PQHWSEPS_XML DB package: PQH_PQHWSEPS_XMLP_PKG
 Human Resources BI Publisher XML
PQH Recap
Imported from BI Publisher Description: Tenure: Recap Report Application: Public Sector HR Source: Tenure: Recap Report (XML) Short Name: PQHUSRCP_XML DB package: PQH_PQHUSRCP_XMLP_PKG
 Human Resources BI Publisher XML
PQH Report Under Budgeted Entities
Imported from BI Publisher Description: Report Under Budgeted Entities for a unit Application: Public Sector HR Source: Report Under Budgeted Entities (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG
 Human Resources BI Publisher XML
PQH Upcoming Events
Imported from BI Publisher Description: Tenure: Upcoming Events Report Application: Public Sector HR Source: Tenure: Upcoming Events Report (XML) Short Name: PQHUSUCE_XML DB package: PQH_PQHUSUCE_XMLP_PKG
 Human Resources BI Publisher XML
PQP Generate MCR CSV
Imported from BI Publisher Application: Public Sector Payroll Source: Generate MCR CSV Report Short Name: PQPMCRCSV DB package:
 BI Publisher XML
PQP OSS HRMS Comparison
Application: Public Sector Payroll Source: OSS HRMS Comparison Report Short Name: PQPCMPRPT DB package: pqp_hross_reports
 BI Publisher XML
PQP TP MDC Reconciliation Report - Excel Output
Application: Public Sector Payroll Source: PQP TP MDC Reconciliation Report - Excel Output Short Name: PQPMDCRECXLSOP DB package:
 BI Publisher XML
PQP TP MDC Reconciliation Report - PDF Output
Application: Public Sector Payroll Source: PQP TP MDC Reconciliation Report - PDF Output Short Name: PQPMDCRECPDFOP DB package:
 BI Publisher XML
PQP Teachers Pension MCR Reconciliation Report (Excel)
Imported from BI Publisher Description: Teachers Pension MCR Reconciliation Report (PDF) Application: Public Sector Payroll Source: Teachers Pension MCR Reconciliation Report (Excel) Short Name: PQPGBMCRREP_XLS DB package:
 BI Publisher XML
PQP Teachers Pension MCR Reconciliation Report (PDF)
Imported from BI Publisher Application: Public Sector Payroll Source: Teachers Pension MCR Reconciliation Report (PDF) Short Name: PQPGBMCRREP_PDF DB package:
 BI Publisher XML
PSA Encumbrance Detail Trial Balance
Imported from BI Publisher Application: Public Sector Financials Source: Encumbrance Detail Trial Balance Report Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg
 BI Publisher XML
PSB Allocation Rules Listing
Application: Public Sector Budgeting (Obsolete) Source: Allocation Rules Listing (XML) Short Name: PSBRPPAL_XML DB package: PSB_PSBRPPAL_XMLP_PKG
 BI Publisher XML