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

70 reports

DescriptionDownload
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 Item Transaction Defaults Upload
This upload can be used to create and update Item transaction default subinventories and locators
Inventory Enginatics, Upload XML
INV Item Upload
INV Inventory Item Upload ====================== This upload can be used to create and update Inventory Items. It supports creation of Inventory Items: - by manually entering the Item details. - from a master row, with optional semicolon-separated child organization assignments - from an item template (Copy from Template) - from an existing item in the same Organization (Copy from Item) It supports update of existing Inventory Items either by: - update the details of an existing inventory items by downloading the items to be updated. Use the report parameters to select and download the…
full description
Inventory Enginatics, Upload XML
INV Item Upload 11i
INV Inventory Item Upload ====================== This upload can be used to create and update Inventory Items. It supports creation of Inventory Items: - by manually entering the Item details. - from a master row, with optional semicolon-separated child organization assignments - from an item template (Copy from Template) - from an existing item in the same Organization (Copy from Item) It supports update of existing Inventory Items either by: - update the details of an existing inventory items by downloading the items to be updated. Use the report parameters to select and download the…
full description
Inventory Enginatics, Upload XML
INV Item User Defined Attribute Upload
Item user-defined attribute (UDA) values upload for Oracle Product Information Management (PIM / Advanced Product Catalog). Creates, updates and deletes item user-defined attribute values (attribute groups defined in the item catalog) at the item, item organization and item revision data levels through the Oracle EGO user attributes API. Each upload row carries one attribute value; the rows of one attribute group row instance (same item, data level, attribute group and row number) are processed together. For multi-row attribute groups, enter a Row Number to group the attribute values…
full description
Inventory Enginatics, 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 Manufacturer Upload
INV Manufacturer Upload ====================== This upload can be used to create, update and delete Manufacturers.
Inventory Enginatics, Upload XML
INV Material Status Change History
Imported from BI Publisher Description: Material Status Change History Report Application: Inventory Source: Material Status Change History Report (XML) Short Name: INVMSCHR_XML DB package: INV_INVMSCHR_XMLP_PKG
Inventory Enginatics 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 Physical Inventory Tag Count Upload
INV Physical Inventory Tag Count Upload ================================= This upload enables the user to upload counts against the Physical Inventory Tags defined against the specified Physical Inventory. The upload supports - the update of counts against existing Tags - the generation of new tags. For clients on R12.2.14 or later, creation of manually entered tag numbers is supported For clients on earlier releases, to generate a new tag leave the tag number blank. The tag number will be automatically generated when the tag is created For clients on R12.2.3 or later - the upload also…
full description
Inventory Enginatics, Upload XML
INV Physical Inventory Upload
This upload supports the creation of new Physical Inventories and the update of existing Physical Inventories that have not yet been frozen. The upload supports the specification of the subinventories to be included in the Physical Inventory. When updating an existing Physical Inventory, the Delete Subinventory upload column allows for individual subinventories to be removed from the Physical Inventory subinventory list. Replace Existing Subinventories ========================== When the Replace Existing Subinventories report parameter is set to Yes, the existing physical inventory…
full description
Inventory Enginatics, Upload XML
INV Print Cycle Count Entries Open Interface data
Imported Oracle standard Print Cycle Count Entries Open Interface data report Source :Print Cycle Count Entries Open Interface data (XML) Short Name: INVCCIER_XML DB package: INV_INVCCIER_XMLP_PKG
Inventory Enginatics XML
INV Safety Stock Upload
INV Safety Stock Upload ================================ - Upload New Safety Stock Entries. - Update Existing Safety Stock Entries. - Delete Existing Saffety Stock Entries (Delete by setting the 'Delete This Entry' = Yes). Upload Modes ============ Create ------ Opens an empty spreadsheet where the user can enter new Safety Stock Quantities Create or Update ----------------- Create new Safety Stock entries and/or modify existing Safety Stock entries. Allows the user to - download existing Safety Stock entiries based on the selection criteria specified in the report parameters. - modify…
full description
Inventory Enginatics, Upload XML
INV Stock Locator Upload
Create, update and delete Stock Locators. Note on entering a locator as a concatenated segment value: if a segment value contains the KFF delimiter character or a backslash (\), each such character must be preceded with a backslash. For example, with delimiter '.', the segment value '1\4\4.' must be written as '1\\4\\4\.'
Inventory Enginatics, 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 Transaction Upload
INV Transaction Upload ====================== This upload can be used to create Inventory Material Transactions. The following upload modes are supported: Create – Generates an empty upload file. Transaction details must be entered manually. The Create mode always opens a blank Excel template, regardless of any parameter settings. Create, Update – Based on the selected parameters, this mode can generate a pre-populated file with details such as item, primary unit of measure, and transaction date (defaulted to today’s date). It also displays the current on-hand quantity for each item,…
full description
Inventory Enginatics, Upload XML
INV Unit Of Measure Conversion Upload
INV Unit Of Measure Conversion Upload ============================= In R12.2 and later: This upload enables the user to - upload new unit of measure conversions - update existing unit of measure conversions. The upload supports the following unit of measure conversion types: - Standard, Intra-Class and Inter-Class, Lot Specific Inter-class In R12.1: The functionality is restricted to creating new Item specific Intra-Class and Inter-Class conversions only. Update of existing unit of measure conversions is not supported in R12.1 Creation of Standard and Lot specific unit of measure…
full description
Inventory Enginatics, Upload 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