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

1,744 reports

DescriptionDownload
PO Print CLM Requisition Amendments
Application: Purchasing Source: Print CLM Requisition Amendments Report Short Name: POXPRAMDCLM_XML DB package: PO_POXPRCLM_PKG
 Purchasing BI Publisher XML
PO Print CLM Requisitions
Application: Purchasing Source: Print CLM Requisitions Report Short Name: POXPRCLM_XML DB package: PO_POXPRCLM_PKG
 Purchasing BI Publisher XML
PO Printed RFQ
Imported from BI Publisher Description: Printed RFQ Report(Portrait) Application: Purchasing Source: Printed RFQ Report (XML) Short Name: POXPRRFP_XML DB package: PO_POXPRRFP_XMLP_PKG
 Purchasing BI Publisher XML
PO Purchase Agreement Audit
Imported from BI Publisher Description: Purchase Agreement Audit Report Application: Purchasing Source: Purchase Agreement Audit Report (XML) Short Name: POXPOABP_XML DB package: PO_POXPOABP_XMLP_PKG
 Purchasing BI Publisher XML
PO Purchase Order Commitment By Period
Imported from BI Publisher Description: Purchase Order Commitment By Period Report Application: Purchasing Source: Purchase Order Commitment By Period Report (XML) Short Name: POXPOCOM_XML DB package: PO_POXPOCOM_XMLP_PKG
 Purchasing BI Publisher XML
PO Purchase Order Detail
Imported from BI Publisher Description: Purchase Order Detail Report Application: Purchasing Source: Purchase Order Detail Report (XML) Short Name: POXPOSTD_XML DB package: PO_POXPOSTD_XMLP_PKG
 Purchasing BI Publisher XML
PO Purchase Order Distribution Detail
Application: Purchasing Source: Purchase Order Distribution Detail Report (XML) Short Name: POXPODDR_XML DB package: PO_POXPODDR_XMLP_PKG
 Purchasing BI Publisher XML
PO Purchase Requisition Status
Imported from BI Publisher Description: Purchase Requisition Status Report Application: Purchasing Source: Purchase Requisition Status Report (XML) Short Name: POXRQRSR_XML DB package: PO_POXRQRSR_XMLP_PKG
 Purchasing BI Publisher XML
PO Purchase Summary Report By Category
Imported from BI Publisher Description: Purchase Summary By Category Application: Purchasing Source: Purchase Summary Report By Category (XML) Short Name: POXSUCAT_XML DB package: PO_POXSUCAT_XMLP_PKG
 Purchasing BI Publisher XML
PO Purchasing Interface Errors
Application: Purchasing Source: Purchasing Interface Errors Report (XML) Short Name: POXPIERR_XML DB package: PO_POXPIERR_XMLP_PKG
 Purchasing BI Publisher XML
PO Receipt Adjustments
Imported from BI Publisher Description: Receipt Adjustments Report Application: Purchasing Source: Receipt Adjustments Report (XML) Short Name: POXRVRTN_XML DB package: PO_POXRVRTN_XMLP_PKG
 Purchasing BI Publisher XML
PO Receipt Traveler
Imported from BI Publisher Description: Receipt Traveler Application: Purchasing Source: Receipt Traveler (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG
 Purchasing BI Publisher XML
PO Receiving Exceptions
Imported from BI Publisher Description: Receiving Exceptions Report Application: Purchasing Source: Receiving Exceptions Report (XML) Short Name: POXRVRER_XML DB package: PO_POXRVRER_XMLP_PKG
 Purchasing BI Publisher XML
PO Receiving Interface Errors
Application: Purchasing Source: Receiving Interface Errors Report (XML) Short Name: RCVIERR_XML DB package: PO_RCVIERR_XMLP_PKG
 Purchasing BI Publisher XML
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