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

116 reports

	Description
PO Approval Assignments	Active PO document approval group assignments with HR jobs or positions	Purchasing Enginatics
PO Approval Groups	PO approval groups and approval rules e.g. amount limits or account ranges	Purchasing Enginatics
PO Approval History	Approval and action history of purchase orders, releases, agreements and requisitions: one row per entry of the document's action history (submit, forward, approve, reject, return, reserve, cancel, close, hold), in sequence. The pending step of a document awaiting approval is shown with action Pending and the current approver as performer. Days Since Previous Action is measured from the previous history entry, for a pending step until today. Submitted Date is the latest submission up to that step. For a release, Document Number is the number of its blanket agreement.	Purchasing Enginatics
PO Approved Supplier List	Approved supplier list and attribute details such as source documents, supplier scheduling, planning constraints and inventory attributes.	Purchasing Enginatics
PO Cancelled Purchase Orders	Application: Purchasing Source: Cancelled Purchase Orders Report (XML) Short Name: POXPOCAN_XML DB package: PO_POXPOCAN_XMLP_PKG	Purchasing Enginatics
PO Cancelled Requisitions	Application: Purchasing Source: Cancelled Requisition Report (XML) Short Name: POXRQCRQ_XML DB package: PO_POXRQCRQ_XMLP_PKG	Purchasing Enginatics
PO Document Types	PO document types setup	Purchasing Enginatics
PO Headers	PO headers or releases with corresponding invoices and their payment status. Example: To show all POs or releases which have an invoice but no receiving TRX yet, set following parameters: Invoice exists=Yes Receiving TRX exists=No	Purchasing Enginatics
PO Headers and Lines	PO headers, lines, receiving transactions and corresponding AP invoices When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CGST Rate, SGST Rate, IGST Rate, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code.	Purchasing Enginatics
PO Internal Requisitions and Sales Orders	Report to display internal sales orders and requisition numbers, with aging dates and other useful information.	Purchasing Enginatics
PO Internal Requisitions/Deliveries Discrepancy	Application: Purchasing Description: Internal Requisitions/Deliveries Discrepancy Report Source: Internal Requisitions/Deliveries Discrepancy Report (XML) Short Name: POXRQSDD_XML	Purchasing Enginatics
PO Invoice Price Variance	Imported Oracle standard Invoice Price Variance report Application: Purchasing Source: Invoice Price Variance Report Short Name: POXRCIPV	Purchasing Enginatics, R12 only
PO Printed Planning Schedule	Migration of the Oracle standard concurrent program Printed Planning Schedule (XML) (CHVPRSCH_XML) from Supplier Scheduling. Shows, for each confirmed planning/shipping schedule, the time-phased demand grid sent to the supplier - one row per schedule, item and time bucket - with forecast, released, total and cumulative (CUM+) quantities per bucket, plus the schedule header, item, CUM and authorization context. The horizontal schedule grid (chv_horizontal_schedules, up to 60 bucket columns) is un-pivoted into rows for analysis in Excel.	Purchasing Enginatics
PO Purchase Price Variance	Imported Oracle standard Purchase Price Variance report Source: Purchase Price Variance Report (XML) Short Name: POXRCPPV_XML DB package: PO_POXRCPPV_XMLP_PKG	Purchasing Enginatics, R12 only
PO Purchase Requisitions with PO Details	Purchase Requisitions Status with PO Details Report. Lists purchase requisition headers, lines and distributions together with the purchase order they were converted into, including requisition and PO approval dates, the Converted To PO indicator and the PO total amount. Set the Show Invoice and Payment Details parameter to Yes to additionally return the supplier invoices and payments matched to each purchase order shipment: invoice numbers, invoice date, invoiced amount, invoice amount paid, payment status, payment numbers, payment date and payment method. These columns are omitted by… full description	Purchasing Enginatics
PO Receiving Transactions	Receiving transactions register: one row per receiving transaction (receive, accept, reject, transfer, deliver, return to supplier or receiving, correction) for purchase orders, internal requisitions, RMAs and inter-organization shipments, with the source document, item, quantity and PO price. Quantity In Receiving and Days In Receiving are current values from the receiving supply, populated only on the receive, accept, reject or transfer transaction whose quantity still sits in receiving. Days In Receiving counts from the receipt date. Amount is quantity times PO unit price and is blank… full description	Purchasing Enginatics
PO Requisition Upload	Upload to create and update requisitions. In the generated Excel, the user can amend the following columns for an existing requisition. - Header Description - Quantity - Unit Price - Need By Date - Reference Number - Supplier Item - Buyer - Note To Buyer - Currency - Conversion Type - Conversion Rate - Conversion Date Additionally, the user can create a requisition by entering the below required fields. - Line Type - Source Type - Item - Item Description - Category - Unit of Measure - Quantity - Need By Date - Destination Type - Deliver To Requestor - Destination… full description	Purchasing Enginatics, Upload
PO Supplier Scheduling On-Time Delivery	Supplier on-time delivery (OTD) based on the Oracle Supplier Scheduling (CHV) module instead of the purchase order form. For each firm scheduled release the report compares the scheduling-module requested delivery date against the actual goods receipt date and reports the delivery delay, ordered vs received quantity, and a partial-delivery flag. Designed for environments where the blanket PO holds only a skeleton (with placeholder dates) and the real call-off dates arrive via EDI into Supplier Scheduling. First-pass draft - see version comments for open scoping items.	Purchasing Enginatics, R12 only
PO Vendor Service Performance Analysis	Imported from BI Publisher Application: Purchasing Source: Vendor Service Performance Analysis Report (XML) Short Name: POXSERPR_XML DB package: PO_POXSERPR_XMLP_PKG	Purchasing Enginatics
PO Acceptance Upload	This upload allows users to create new PO Acceptances (Acknowledgments)	Purchasing Enginatics, Upload
PO Approved Supplier List Upload	This upload supports the creation and update of Approved Supplier Lists (ASL) in Oracle Purchasing. The upload supports creation/update/deletion of the following Approved Supplier List entities: - Approved Supplier Lists (Global and Local) - Approved Supplier List Attributes. Including Local (Using Organization specific) attributes against a global ASL. - Source Documents - Authorizations - Supplier Capacities - Supplier Tolerances Notes: - You cannot delete Manufacturer ASLs using this upload. There is a restriction in the standard Oracle API used by this upload that prevents this. - When… full description	Purchasing Enginatics, R12 only, Upload
PO Procure to Pay Tracker	One row per purchase order shipment, and per requisition line not yet on a purchase order, with the date of each step from requisition to payment and the accounting and GL posting of the invoice. Requisition columns are those of the first requisition line placed on the shipment. Invoice columns are those of the first invoice matched to the shipment; Invoiced Amount sums its matched item lines. Validation Status reads as in the invoice workbench, Hold Name lists the invoice's unreleased holds, and Amount Remaining is shown on the invoice's first row only, so it can be summed. Paid Date is the… full description	Purchasing Enginatics, R12 only
PO Purchasing Document Upload	Upload to create and update purchase documents The buyer of an existing standard purchase order can be changed. An approved order then requires reapproval, which the upload submits with the new buyer as preparer.	Purchasing Enginatics, Upload
PO Receipts/Deliveries Discrepancy	PO Receipts/Deliveries Discrepancy highlights, at purchase order line and release level, differences between the quantities and amounts received into receiving (transaction type RECEIVE) and delivered to their final destination (DELIVER), including the impact of any CORRECT transactions applied to either side. Quantity Received and Quantity Delivered show the original transaction quantities, Quantity Corrected Receipt and Quantity Corrected Delivery the net correction impact, and Total Quantity Received and Total Quantity Delivered the corrected totals. Quantity Variance and Cost Variance… full description	Purchasing Enginatics, R12 only
PO Receiving Transaction Upload	PO Receiving Transaction Upload ================================ Create receiving transactions (receipts) against approved standard purchase orders. Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can manually enter PO receiving details. Create, Update -------------- Downloads open PO shipment lines with quantities available to receive for the selected organization. The user fills in the Quantity and Transaction Date columns for each line to receive, then uploads. Prerequisites ============= - PO must be approved and not cancelled or closed. - PO shipment… full description	Purchasing Enginatics, Upload
PO Requisition Template Upload	PO Requisition Template Upload ================================ The purpose of the PO Requisition Template Upload is to allow for: - the creation of new Requisition Templates (Create Mode). - the update of existing Requisition Templates (Update Mode). Update includes the update to existing template and template lines, the creation of new template lines against an existing template, and the deletion of template lines from an existing template. As far as feasible, the upload provides the user with the same functionality available in the ‘Requisition Template’ Form. (Purchasing: + Setup –… full description	Purchasing Enginatics, Upload
PO Requisition Upload 11i	Upload to create and update requisitions. In the generated Excel, the user can amend the following columns for an existing requisition. - Header Description - Quantity - Unit Price - Need By Date - Reference Number - Supplier Item - Buyer - Note To Buyer - Currency - Conversion Type - Conversion Rate - Conversion Date Additionally, the user can create a requisition by entering the below required fields. - Line Type - Source Type - Item - Item Description - Category - Unit of Measure - Quantity - Need By Date - Destination Type - Deliver To Requestor - Destination… full description	Purchasing Enginatics, Upload
PO Blanket and Planned PO Status	Imported from BI Publisher Description: Blanket and Planned PO Status Report Application: Purchasing Source: Blanket and Planned PO Status Report (XML) Short Name: POXPOBPS_XML DB package: PO_POXPOBPS_XMLP_PKG	Purchasing BI Publisher
PO Buyer Listing	Imported from BI Publisher Description: Buyer Listing Application: Purchasing Source: Buyer Listing (XML) Short Name: POXAGLST_XML DB package: PO_POXAGLST_XMLP_PKG	Purchasing BI Publisher
PO Internal Requisition Status	Application: Purchasing Source: Internal Requisition Status Report (XML) Short Name: POXRQSIN_XML DB package: PO_POXRQSIN_XMLP_PKG	Purchasing BI Publisher
PO Location Listing	Application: Purchasing Source: Location Listing (XML) Short Name: POXSURLC_XML DB package: PO_POXSURLC_XMLP_PKG	Purchasing BI Publisher
PO New Vendor Letter	Application: Purchasing Source: New Vendor Letter Report (XML) Short Name: POXVDRVL_XML DB package: PO_POXVDRVL_XMLP_PKG	Purchasing BI Publisher
PO Overshipments	Imported from BI Publisher Description: Overshipments Report Application: Purchasing Source: Overshipments Report (XML) Short Name: POXRVOVS_XML DB package: PO_POXRVOVS_XMLP_PKG	Purchasing BI Publisher
PO Printed Requisitions	Imported from BI Publisher Description: Printed Requisitions Report Application: Purchasing Source: Printed Requisitions Report (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG	Purchasing BI Publisher
PO Purchase Order and Releases Detail	Imported from BI Publisher Description: Purchase Order and Releases Detail Report Application: Purchasing Source: Purchase Order and Releases Detail Report (XML) Short Name: POXBLREL_XML DB package: PO_POXBLREL_XMLP_PKG	Purchasing BI Publisher
PO Purchasing Activity Register	Imported from BI Publisher Description: Purchasing Activity Register Application: Purchasing Source: Purchasing Activity Register (XML) Short Name: POXACTPO_XML DB package: PO_POXACTPO_XMLP_PKG	Purchasing BI Publisher
PO Quality Code Listing	Application: Purchasing Source: Quality Code Listing (XML) Short Name: POXSURQC_XML DB package: PO_POXSURQC_XMLP_PKG	Purchasing BI Publisher
PO Quotation Action Required	Imported from BI Publisher Description: Quotation Action Required Report Application: Purchasing Source: Quotation Action Required Report (XML) Short Name: POXQTQAR_XML DB package: PO_POXQTQAR_XMLP_PKG	Purchasing BI Publisher
PO RFQ Action Required	Imported from BI Publisher Description: RFQ Action Required Report Application: Purchasing Source: RFQ Action Required Report (XML) Short Name: POXRFRAR_XML DB package: PO_POXRFRAR_XMLP_PKG	Purchasing BI Publisher
PO Receiving Account Distribution	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 BI Publisher
PO Requisition Activity Register	Imported from BI Publisher Description: Requisition Activity Register Application: Purchasing Source: Requisition Activity Register (XML) Short Name: POXREQAC_XML DB package: PO_POXREQAC_XMLP_PKG	Purchasing BI Publisher
PO Requisition Distribution Detail	Imported from BI Publisher Description: Requisitions Distribution Detail Report Application: Purchasing Source: Requisition Distribution Detail Report (XML) Short Name: POXRQDDR_XML DB package: PO_POXRQDDR_XMLP_PKG	Purchasing BI Publisher
PO Requisition Import Exceptions	Application: Purchasing Source: Requisition Import Exceptions Report (XML) Short Name: POXREQIM_XML DB package: PO_POXREQIM_XMLP_PKG	Purchasing BI Publisher
PO Standard Notes Listing	Application: Purchasing Source: Standard Notes Listing (XML) Short Name: POXNOTES_XML DB package: PO_POXNOTES_XMLP_PKG	Purchasing BI Publisher
PO Unit of Measure Class Listing	Application: Purchasing Source: Unit of Measure Class Listing (XML) Short Name: POXSURUC_XML DB package: PO_POXSURUC_XMLP_PKG	Purchasing BI Publisher
PO Unit of Measure Listing	Application: Purchasing Source: Unit of Measure Listing (XML) Short Name: POXSURUM_XML DB package: PO_POXSURUM_XMLP_PKG	Purchasing BI Publisher
PO Vendor Affiliated Structure Listing	Application: Purchasing Source: Vendor Affiliated Structure Listing (XML) Short Name: POXVESTR_XML DB package: PO_POXVESTR_XMLP_PKG	Purchasing BI Publisher
PO Vendor Purchase Summary	Imported from BI Publisher Description: Vendor Purchase Summary Report Application: Purchasing Source: Vendor Purchase Summary Report (XML) Short Name: POXPOVPS_XML DB package: PO_POXPOVPS_XMLP_PKG	Purchasing BI Publisher
ICX Military Interdepartmental Purchase Request	Application: Oracle iProcurement Source: Short Name: ICXCLMREQ_XML DB package: ICX_DATATEMPLATE_PKG	Purchasing BI Publisher
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

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