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

15 reports

DescriptionDownload
INV Aging
The Inventory Aging Report indicates how long an inventory item has been in a FIFO warehouse. You can define bucket days to identify the period from when an item is in the inventory. NOTES: This report will only run for clients running R12.2.8 or later. This report requires the profile 'INV: FIFO for Original Receipt Date' to be set to Yes in order to return data. For customers encountering an error running this Blitz report, please first verify the Oracle standard report Inventory Aging Report(XML) can be run in the same instance. If the standard Oracle report does not complete…
full description
Inventory Enginatics, R12 only XLS XML
INV Lot Transaction Register
Imported from BI Publisher Description: Lot transaction register Application: Inventory Source: Lot transaction register (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG
Inventory Enginatics, R12 only XLS XML
INV Material Account Distribution Detail
Description: Material account distribution detail Application: Inventory Source: Material account distribution detail (XML) Short Name: INVTRDST_XML
Inventory Enginatics, R12 only XLS XML
INV Organization Parameters Inventory Enginatics, R12 only XLS XML
INV Period Close Pending Transactions
Summary report to display the pending transaction counts as found in the Inventory Account Periods Close form, checking open receipts, pending shipments, failed inventory, WIP, etc The Period Count shows the pending transactions occurring within the specified period. The Period Close Count shows the count of pending transactions as at the scheduled period close date of the specified period. The Period Close Count are the counts displayed in the Pending Transactions Inventory Account Periods Close Form. This is the accumulated count of pending transactions upto the shceduled close date of…
full description
Inventory Enginatics, R12 only XLS XML
INV Transaction Register
Imported from BI Publisher Description: Transaction register Application: Inventory Source: Transaction register (XML) Short Name: INVTRREG_XML DB package: INV_INVTRREG_XMLP_PKG
Inventory Enginatics, R12 only XLS XML
INV Cycle count unscheduled items
Imported Oracle standard Cycle count unscheduled items report Source: Cycle count unscheduled items report (XML) Short Name: INVARUIR_XML DB package: INV_INVARUIR_XMLP_PKG
Inventory Enginatics, R12 only XML
INV Item Cross Reference Upload
Creates, updates and deletes item cross references - the Cross Reference Types form (Inventory > Setup > Items > Cross-Reference Types), also reached from the Item form via Tools > Cross References. A cross reference is either organization independent (Applicable To All Organizations is set and Org is blank) or specific to one organization (Org is entered). The organization must be one the item is assigned to. Revision and Unit of Measure only apply to the GTIN cross reference type named by the profile option INV: GTIN Cross Reference Type, and Revision additionally requires an…
full description
Inventory Enginatics, R12 only, Upload XML
INV Item Subinventory Upload
Create, update and delete item-to-subinventory assignments (plus their optional item-subinventory-locator ties) across accessible inventory organizations. Each row is one (Organization, Item, Subinventory, Locator?) combination. When the Locator column is blank, only the item-subinventory header is processed. When the Locator column is populated, the item-subinventory header (if not already processed in this run) AND the locator tie are processed. When multiple rows share the same Organization/Item/Subinventory triple, the header is processed only on the first row of the triple (siblings…
full description
Inventory Enginatics, R12 only, Upload XML
INV Lot Upload
Creates and updates lots as in the Lot Numbers form (Inventory > On-hand, Availability > Lots). A row updates the lot when Organization Code, Item and Lot Number exist, and creates it otherwise. A new lot takes the item defaults for status, grade, origination type and the dates left blank, and copies the parent lot attributes where the item or organization is set up to copy them. A blank Origination Date on a new lot defaults to the current date. Parent Lot can only be entered for a new lot. Expiration Date, Expiration Action Date and Retest Date can be changed only for items under shelf…
full description
Inventory Enginatics, R12 only, Upload XML
INV Movement Statistics
Imported from BI Publisher Description: Movement Statistics Report (INTRASTAT Report) Application: Inventory Source: Movement Statistics Report (XML) Short Name: INVSTMVT_XML DB package: INV_INVSTMVT_XMLP_PKG Reports movement statistics for EU Intrastat compliance including arrivals, dispatches, and adjustments with detailed commodity, territory, and trader information.
Inventory Enginatics, R12 only XML
INV Physical Inventory Purge Upload
This upload supports the purging of existing Physical Inventories. For each Physical Inventory to be purged the user can select to purge the tags only, or to purge the full Physical Inventory. On upload, the upload process will submit the standard 'Purge physical inventory information' concurrent program for each Physical Inventory to be purged. To improve performance of the upload process, the upload does not wait for completion of the purge concurrent requests before completing. The ‘Create, Update’ upload mode can be used to first download the Physical Inventories to be purged for…
full description
Inventory Enginatics, R12 only, Upload XML
INV Subinventory Upload
Create and update Subinventories across accessible inventory organizations. Accounts and Default Cost Group are tightly linked; the behavior depends on the organization's configuration: - WMS=No + Standard cost method (with no on-hand or transaction history): the accounts drive the Cost Group. Enter any valid GL detail accounts and the upload auto-resolves the Cost Group — switching to an existing Cost Group whose 7 accounts match, or creating a new one when none matches. The Cost Group action taken is reported in the success message. - WMS=Yes (any cost method): the Cost Group drives the…
full description
Inventory Enginatics, R12 only, Upload XML
INV Transaction Historical Summary
Application: Inventory Description: Transaction Historical Summary Report This report provides equivalent functionality to the Oracle standard Transaction historical summary (XML) report. Templates Quantity/Value Template – for use with the Quantity and Value Selection Option Balance Template – for use with the Balance Selection Option The templates provide a summary pivot based on the selected sort option parameter with drill down to the detail data. Sort Option Category: Pivot by Category, Subinventory/Cost Group All Others: Pivot by Subinventory/Cost Group, Category Source:…
full description
Inventory Enginatics, R12 only XML
INV Unit Of Measure Upload
INV Unit Of Measure Upload ====================== Note: This upload can only be used in R12.2 or later. This upload can be used to create and update Unit of Measure Classes and Units of Measures
Inventory Enginatics, R12 only, Upload XML