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

8 reports

DescriptionDownload
ONT Order Upload
Upload to Create, Update, Book and Cancel Sales Orders in Oracle Order Management. Supports creating new orders, updating existing orders, adding new lines to existing orders, splitting lines, booking orders and cancelling orders. To split a line, add a row for the order with the line to split in Split From Line and the new shipment's quantity in Ordered Quantity. The original line is reduced by that quantity unless its own row sets its new quantity. As in the Split Line window, the new shipment copies all other values from the original line, only Request Date, Warehouse and Ship To can…
full description
Order Management Enginatics, Upload XML
ONT Sales Quote Close Upload
Bulk closes open Oracle Order Management sales quotes (documents in the Negotiation transaction phase) - useful for cleaning up large volumes of old draft quotes. Download the open quotes, keep the rows you want to close, set a Close Reason, and upload. Each quote is driven to the Lost terminal (status Lost, no longer open) through the standard negotiation workflow, and the reason is recorded against the quote. Quotes are identified by Quote Number and Operating Unit, so you can also paste those two values from an external list instead of downloading. Only open quotes are closed - an order…
full description
Order Management Enginatics, Upload XML
QP GSA Pricing Upload
This upload supports the creation and update of GSA Pricing Setup in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within a GSA Pricing List: - GSA Lists (created as a Modifier List) - GSA List Qualifiers (created as a Modifier List Qualifier) - GSA List Lines (created as Modifier Lines) Notes: When downloading existing GSA Lists into the upload excel; the List level Qualifiers and the List Lines will be downloaded into separate rows in the excel. This is to minimize the duplication of data in the excel. However: When entering List…
full description
Order Management Enginatics, Upload XML
QP Modifier Upload
This upload supports the creation and update of Modifiers in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within a Modifier List: - Modifier List Qualifiers - Modifier List Limits - Modifier Lines - Modifier Line Price Breaks. To enter the Modifier Price Breaks in the upload, repeat the Modifier Price Break Header Line and enter/adjust the Price Break Columns for each Price Break. - Modifier Line Additional Buy Items. - Modifier Line Get Items - Modifier Line Pricing Attributes - Modifier Line Qualifiers - Modifier Line Limits Notes: When…
full description
Order Management Enginatics, Upload XML
QP Price List Upload
This upload supports the creation and update of Standard Price Lists in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within the Price List: - Price List Lines 'End Date Matching List Lines?' When creating new Price List Lines, the upload can automatically end date any existing matching active price list line by setting the report parameter 'End Date Matching List Lines?' to Yes. Set this parameter to Yes to automatically end date any active matching price list line on upload. Any price list lines downloaded when this parameter is set to…
full description
Order Management Enginatics, Upload XML
QP Qualifier Group Upload
This upload supports the creation and update of Qualifier Groups in Oracle Advanced Pricing.
Order Management Enginatics, Upload XML
WSH Container Items Upload
Creates, updates and deletes container-item relationships - the Container-Item Relationships form (Shipping > Setup > Container Load Details). A relationship states the maximum quantity of a load item that fits into a container item in one inventory organization; auto-pack uses the load item's preferred container. Setting Preferred Flag to Yes removes the flag from the load item's current preferred container, as the form does after asking, and the Message names that container. When several rows of one file make different containers preferred for the same load item, the last row…
full description
Order Management Enginatics, Upload 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