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

	Description
PO Advanced Shipment Notice Discrepant Receipts	Imported from Concurrent Program Description: Sends supplier Application Advice Notices for an advanced shipment notice that was either overrecieved or not fulfilled. Application: Purchasing Source: Advanced Shipment Notice Discrepant Receipts Short Name: RCVDSC	Purchasing Concurrent Program
PO Award Data template	Application: Purchasing Source: Short Name: PO_STD_PO DB package: PO_DataTemplate_Pkg	Purchasing BI Publisher
PO Award Data template for FPDS-NG	Application: Purchasing Source: Short Name: POAWDFPDSNG DB package: PO_XML_FPDSNG_Pkg	Purchasing BI Publisher
PO Award Mod data template for FPDS-NG	Application: Purchasing Source: Short Name: POAWDMODFPDSNG DB package: PO_XML_FPDSNG_PKG	Purchasing BI Publisher
PO Awards by COTR	Application: Purchasing Source: Awards by COTR Short Name: POXAWDCOTR_XML DB package: PO_POXAWDCOTR_XMLP_PKG	Purchasing BI Publisher
PO Awards by Status	Application: Purchasing Source: Awards by Status Short Name: POXAWDSTA_XML DB package: PO_POXAWDSTA_XMLP_PKG	Purchasing BI Publisher
PO Backordered Internal Requisitions	Application: Purchasing Source: Backordered Internal Requisitions Report (XML) Short Name: POXRQOBO_XML DB package: PO_POXRQOBO_XMLP_PKG	Purchasing BI Publisher
PO Buyer's Requisition Action Required	Imported from BI Publisher Description: Buyer's Requisition Action Required Report Application: Purchasing Source: Buyer's Requisition Action Required Report (XML) Short Name: POXRQUNI_XML DB package: PO_POXRQUNI_XMLP_PKG	Purchasing BI Publisher
PO CCR Compliance	Application: Purchasing Source: CCR Compliance Short Name: POXAWDCCR_XML DB package: PO_POXAWDCCR_XMLP_PKG	Purchasing BI Publisher
PO Cancelled Purchase Orders (1)	Imported from BI Publisher Description: Cancelled Purchase Orders Report Application: Purchasing Source: Cancelled Purchase Orders Report (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG	Purchasing BI Publisher
PO Closeout Checklist Template	Application: Purchasing Source: Short Name: POCLOSEOUTCT DB package:	Purchasing BI Publisher
PO Closeout Contract Completion Statement	Application: Purchasing Source: Short Name: POCLOSEOUTCCS DB package: PO_DataTemplate_Pkg	Purchasing BI Publisher
PO Contract Status	Application: Purchasing Source: Contract Status Report (XML) Short Name: POXCONST_XML DB package: PO_POXCONST_XMLP_PKG	Purchasing BI Publisher
PO Country of Origin (By Item)	Imported from BI Publisher Description: Country of Origin (By Item) Report Application: Purchasing Source: Country of Origin (By Item) Report (XML) Short Name: POXCORIT_XML DB package: PO_POXCORIT_XMLP_PKG	Purchasing BI Publisher
PO Country of Origin (By Supplier)	Application: Purchasing Source: Country of Origin (By Supplier) Report (XML) Short Name: POXCORSL_XML DB package: PO_POXCORSL_XMLP_PKG	Purchasing BI Publisher
PO Encumbrance Detail	Imported from BI Publisher Description: Encumbrance Detail Report Application: Purchasing Source: Encumbrance Detail Report (XML) Short Name: POXPOEDR_XML DB package: PO_POXPOEDR_XMLP_PKG	Purchasing BI Publisher
PO Endeca Template	Application: Purchasing Source: Short Name: POENDECAXML DB package:	Purchasing BI Publisher
PO FPDS Compliance	Application: Purchasing Source: FPDS Compliance Short Name: POXFPDSCOM_XML DB package: PO_POXFPDSCOM_XMLP_PKG	Purchasing BI Publisher
PO Financials/Purchasing Options Listing	Application: Purchasing Source: Financials/Purchasing Options Listing (XML) Short Name: POXFIPOL_XML DB package: PO_POXFIPOL_XMLP_PKG	Purchasing BI Publisher
PO Generate XML for EDA	Application: Purchasing Source: Short Name: POEDAXML DB package: PO_EDA_DATATEMPLATE_PKG	Purchasing BI Publisher
PO IDV Data template	Application: Purchasing Source: Short Name: PO_BPA DB package: PO_DataTemplate_Pkg	Purchasing BI Publisher
PO IDV Mod datatemplate for FPDS-NG	Application: Purchasing Source: Short Name: POIDVMODFPDSNG DB package: PO_XML_FPDSNG_PKG	Purchasing BI Publisher
PO IDV Modification	Application: Purchasing Source: Short Name: PO_IDV_MOD DB package: PO_DataTemplate_Pkg	Purchasing BI Publisher
PO IDV data template for FPDS-NG	Application: Purchasing Source: Short Name: POIDVFPDSNG DB package: PO_XML_FPDSNG_PKG	Purchasing BI Publisher
PO IGT Order Data Template	Imported from BI Publisher Application: Purchasing Source: Short Name: PO_IGT_ORDER DB package:	Purchasing BI Publisher
PO Item Detail Listing	Imported from BI Publisher Description: Item Detail Listing Application: Purchasing Source: Item Detail Listing (XML) Short Name: POXDETIT_XML DB package: PO_POXDETIT_XMLP_PKG	Purchasing BI Publisher
PO Item Summary Listing	Application: Purchasing Source: Item Summary Listing (XML) Short Name: POXSUMIT_XML DB package: PO_POXSUMIT_XMLP_PKG	Purchasing BI Publisher
PO Matching Holds Report by Buyer	Imported from BI Publisher Description: Matching Holds Report by Buyer Report Application: Purchasing Source: Matching Holds Report by Buyer Report (XML) Short Name: POXPOSMH_XML DB package: PO_POXPOSMH_XMLP_PKG	Purchasing BI Publisher
PO Modification Data template	Application: Purchasing Source: Short Name: PO_MODIFICATION DB package: PO_SGD_PKG	Purchasing BI Publisher
PO Open Purchase Orders Report(by Buyer)	Application: Purchasing Source: Open Purchase Orders Report(by Buyer) (XML) Short Name: POXPOPAA_XML DB package: PO_POXPOPAA_XMLP_PKG	Purchasing BI Publisher
PO Open Purchase Orders Report(by Cost Center)	Imported from BI Publisher Description: Open Purchase Orders Report(by Cost Center) Application: Purchasing Source: Open Purchase Orders Report(by Cost Center) (XML) Short Name: POXPOPAR_XML DB package: PO_POXPOPAR_XMLP_PKG	Purchasing BI Publisher
PO Overdue Vendor Shipments	Imported from BI Publisher Description: Overdue Vendor Shipments Report Application: Purchasing Source: Overdue Vendor Shipments Report (XML) Short Name: POXRVODS_XML DB package: PO_POXRVODS_XMLP_PKG	Purchasing BI Publisher
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
PO Print CLM Requisitions	Application: Purchasing Source: Print CLM Requisitions Report Short Name: POXPRCLM_XML DB package: PO_POXPRCLM_PKG	Purchasing BI Publisher
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
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
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
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
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
PO Purchase Requisition Interface	Purchase requisitions interface listing with status for support and operational purposes.	Purchasing Draft
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
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
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
PO RCV Interface	Requisition Interface Errors	Purchasing
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
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
PO Receiving Account Distribution (1)	Imported from BI Publisher Description: Receiving Account Distribution Report Application: Purchasing Source: Receiving Account Distribution Report (XML) Short Name: POXRRVDR_XML DB package: PO_POXRRVDR_XMLP_PKG	Purchasing
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
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
PO Receiving Transactions Pipeline	PO Receiving Transactions Pipeline	Purchasing Draft

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