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

130 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
INV ABC descending value
Imported from BI Publisher Description: ABC descending value report Application: Inventory Source: ABC descending value report (XML) Short Name: INVARADV_XML DB package: INV_INVARADV_XMLP_PKG
Inventory BI Publisher XLS XML
INV Account alias listing
Imported from BI Publisher Description: Account alias listing Application: Inventory Source: Account alias listing (XML) Short Name: INVSRAAL_XML DB package: INV_INVSRAAL_XMLP_PKG
Inventory BI Publisher XLS XML
INV Customer Item Commodity Codes Listing
Application: Inventory Source: Customer Item Commodity Codes Listing (XML) Short Name: INVIRCOC_XML DB package: INV_INVIRCOC_XMLP_PKG
Inventory BI Publisher XLS XML
INV Customer Items
Application: Inventory Source: Customer Items Report (XML) Short Name: INVIRCIT_XML DB package: INV_INVIRCIT_XMLP_PKG
Inventory BI Publisher XLS XML
INV Forecast rule listing
Imported from BI Publisher Description: Forecast rule listing Application: Inventory Source: Forecast rule listing (XML) Short Name: INVPRFRL_XML DB package: INV_INVPRFRL_XMLP_PKG
Inventory BI Publisher XLS XML
INV Freight carrier listing
Imported from BI Publisher Description: Freight carrier listing Application: Inventory Source: Freight carrier listing (XML) Short Name: INVSRFRT_XML DB package: INV_INVSRFRT_XMLP_PKG
Inventory BI Publisher XLS XML
INV Inactive items
Imported from BI Publisher Description: Inactive items report Application: Inventory Source: Inactive items report (XML) Short Name: INVIRSLO_XML DB package: INV_INVIRSLO_XMLP_PKG
Inventory BI Publisher XLS XML
INV Inventory Aging
Imported from BI Publisher Application: Inventory Source: Inventory Aging Report(XML) Short Name: INVAGERP_XML DB package: INV_AGERPXML_PKG
Inventory BI Publisher XLS XML
INV Inventory Packing Slip
Application: Inventory Source: Inventory Packing Slip (XML) Short Name: INVINPSR_XML DB package: INV_INVINPSR_XMLP_PKG
Inventory BI Publisher XLS XML
INV Item definition detail
Imported from BI Publisher Description: Item definition detail Application: Inventory Source: Item definition detail (XML) Short Name: INVIRITD_XML DB package: INV_INVIRITD_XMLP_PKG
Inventory BI Publisher XLS XML
INV Item definition summary
Imported from BI Publisher Description: Item definition summary Application: Inventory Source: Item definition summary (XML) Short Name: INVIRITS_XML DB package: INV_INVIRITS_XMLP_PKG
Inventory BI Publisher XLS XML
INV Item quantities summary
Imported from BI Publisher Description: Item quantities summary Application: Inventory Source: Item quantities summary (XML) Short Name: INVIRISQ_XML DB package: INV_INVIRISQ_XMLP_PKG
Inventory BI Publisher XLS XML
INV Item replenishment count
Imported from BI Publisher Description: Item replenishment count report Application: Inventory Source: Item replenishment count report (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG
Inventory BI Publisher XLS XML
INV Item statuses
Imported from BI Publisher Description: Item statuses report Application: Inventory Source: Item statuses report (XML) Short Name: INVIRDIS_XML DB package: INV_INVIRDIS_XMLP_PKG
Inventory BI Publisher XLS XML
INV Item template listing
Imported from BI Publisher Description: Item template listing xx xx Short Name INVIRTMP Itemp Template Report Application: Inventory Source: Item template listing (XML) Short Name: INVIRTMP_XML DB package: INV_INVIRTMP_XMLP_PKG
Inventory BI Publisher XLS XML
INV Locator listing
Imported from BI Publisher Description: Locator listing Application: Inventory Source: Locator listing (XML) Short Name: INVSRLOC_XML DB package: INV_INVSRLOC_XMLP_PKG
Inventory BI Publisher XLS XML
INV Locator quantities
Imported from BI Publisher Description: Locator quantities report Application: Inventory Source: Locator quantities report (XML) Short Name: INVIRILC_XML DB package: INV_INVIRILC_XMLP_PKG
Inventory BI Publisher XLS XML
INV Material account distribution summary
Imported from BI Publisher Description: Material account distribution summary Application: Inventory Source: Material account distribution summary (XML) Short Name: INVTRACS_XML DB package: INV_INVTRACS_XMLP_PKG
Inventory BI Publisher XLS XML
INV Move Order Pick Slip
Imported from BI Publisher Description: Move Order Pick List Application: Inventory Source: Move Order Pick Slip (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG
Inventory BI Publisher XLS XML
INV Organization parameters listing
Imported from BI Publisher Description: Organization parameters listing Application: Inventory Source: Organization parameters listing (XML) Short Name: INVSROPT_XML DB package: INV_INVSROPT_XMLP_PKG
Inventory BI Publisher XLS XML
INV Physical inventory counts
Imported from BI Publisher Description: Physical inventory counts report Application: Inventory Source: Physical inventory counts report (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG
Inventory BI Publisher XLS XML
INV Physical inventory tag listing
Imported from BI Publisher Description: Physical inventory tag listing Application: Inventory Source: Physical inventory tag listing (XML) Short Name: INVARPTG_XML DB package: INV_INVARPMT_XMLP_PKG
Inventory BI Publisher XLS XML
INV Physical inventory trend and summary analysis
Imported from BI Publisher Description: Physical inventory trend and summary analysis Application: Inventory Source: Physical inventory trend and summary analysis (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG
Inventory BI Publisher XLS XML
INV Planner listing
Imported from BI Publisher Description: Planner listing Application: Inventory Source: Planner listing (XML) Short Name: INVSRPLN_XML DB package: INV_INVSRPLN_XMLP_PKG
Inventory BI Publisher XLS XML
INV Purchasing Packing Slip
Application: Inventory Source: Purchasing Packing Slip (XML) Short Name: INVPOPSR_XML DB package: INV_INVPOPSR_XMLP_PKG
Inventory BI Publisher XLS XML
INV Serial number detail
Imported from BI Publisher Description: Serial number detail Application: Inventory Source: Serial number detail (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG
Inventory BI Publisher XLS XML
INV Serial number transaction register
Imported from BI Publisher Description: Serial number transaction register Application: Inventory Source: Serial number transaction register (XML) Short Name: INVTRSNT_XML DB package: INV_INVTRSNT_XMLP_PKG
Inventory BI Publisher XLS XML
INV Shortage Parameter
Imported from BI Publisher Description: Shortage Parameter report Application: Inventory Source: Shortage Parameter report (XML) Short Name: INVSRSPT_XML DB package: INV_INVSRSPT_XMLP_PKG
Inventory BI Publisher XLS XML
INV Status attributes listing
Application: Inventory Source: Status attributes listing (XML) Short Name: INVIRDST_XML DB package: INV_INVIRDST_XMLP_PKG
Inventory BI Publisher XLS XML
INV Subinventory listing
Imported from BI Publisher Description: Subinventory listing Application: Inventory Source: Subinventory listing (XML) Short Name: INVSRSUB_XML DB package: INV_INVSRSUB_XMLP_PKG
Inventory BI Publisher XLS XML