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

4 reports

DescriptionDownload
ONT Recurring Billing Plan
Profile report showing the Sales order recurring billing plan for header and line details including status, frequency, billing period, billing amounts and dates.
 Order Management Enginatics, R12 only XLS XML
QP Modifier Details
Imported from BI Publisher Description: Modifier Details Report for QP Application: Advanced Pricing Source: Modifier Details (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG he Modifier Details (columns) are repeated across all rows pertaining to the Modifier The List Line Details (columns) are repeated across all rows pertaining to the List Line For a given modifier the row sequence is: - Modifier Level Qualifiers (sorted by qualifier group, qualifier grouping number) - Modifier List Lines (sorted by list line number) For each Modifier List the row sequence is: - List…
full description		 Order Management Enginatics, R12 only XLS XML
ONT Order to Cash Tracker
One row per sales order or quote line with the date of each step from quote to payment, and the accounting and GL posting of its invoice. Invoice columns are those of the first invoice raised for the line; Invoiced Amount sums all its invoice lines. Amount Due Remaining is shown on the invoice's first order line only, so it can be summed. Paid Date is the date the invoice's last installment closed, Receipt Number the latest receipt applied to it. Accounted Date is when final accounting was created for the invoice, GL Posted Date when its journal was posted.
 Order Management Enginatics, R12 only XML
WSH Pick Confirm Upload
WSH Pick Confirm Upload ======================= Confirms released sales order pick tasks in bulk from Excel: the picked quantity, the subinventory, locator and lot actually picked, the staging location and, in WMS enabled organizations, the LPN the material was packed into. Download the released to warehouse lines of an organization, optionally restricted to an order, delivery, trip, move order (pick slip), customer or item. One row is created per pick allocation, and per allocated lot for lot controlled items. Overwrite the pre-filled allocation where the pick differs, enter the LPN and…
full description		 Order Management Enginatics, R12 only, Upload XML