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

6 reports

DescriptionDownload
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 XLS XML
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 XLS XML
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 XLS XML
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 XML
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 XML
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 XML