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

835 reports

DescriptionDownload
FND User Login Summary
Active application user count per month
System Enginatics XML
FND User Upload
Listing and updating all EBS users and their responsiblities
System Enginatics, Upload XML
FSG Drilldown Diagnostic
Troubleshooting report for FSG journal drilldown issues. Checks gl_balances, posted/unposted journals, period status, account properties, and flex value security for a given account and period. Use the GL segment parameters to filter to the specific account combination that is not drilling down.
Enginatics XML
GL Account Analysis (Drilldown)
** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. ** Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. For drilldown to the transaction screen please ensure the column View Transaction is present in the Displayed Columns View Transaction
General Ledger Enginatics, R12 only XML
GL Account Analysis (Drilldown) (with inventory and WIP)
** This report is used by the GL Financial Statement and Drilldown report, to show Subledger details. ** Detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency. This also has inventory and WIP details.
General Ledger Enginatics, R12 only XML
GL Account Analysis 11g
Backwards compatible version (for 11g databases) of the detail GL transaction report with one line per transaction including all segments and subledger data, with amounts in both transaction currency and ledger currency.
General Ledger Enginatics XML
GL Account Distribution Analysis
Detailed GL transaction report with one line per distribution including all segments and subledger data, with amounts in both transaction currency and ledger currency. The report includes VAT tax codes and rates for AR and AP transactions.
General Ledger Enginatics, R12 only XML
GL Account Upload
This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations.
General Ledger Enginatics, Upload XML
GL Account Upload 11i
This upload allows creation of new GL code combinations and update of existing ones. For creation of new code combinations, the upload requires the setup to allow dynamic inserts for code combinations.
General Ledger Enginatics, Upload XML
GL Balance Drilldown
Shows GL balance details by code combination. Uses gl_balances for standard queries, gl_je_lines when filtering by journal source/category or using JED balance types.
General Ledger Enginatics XML
GL Balances (Drilldown)
** This report is used by the GL Financial Statement and Drilldown report, to show Balance details per code combination. ** Shows GL balance amounts (Opening Balance, Debit, Credit, Net, Closing Balance) grouped by code combination, with drill-to-journal capability. Supports all balance types: PTD, YTD, QTD, PJTD, FYS, FYE, CTD. The Drill To Journal column allows further drilldown into journal details.
General Ledger Enginatics XML
GL Budget Amounts Upload
GL Budget Amounts Upload =================== This can be used to upload GL Budget Amounts
General Ledger Enginatics, Upload XML
GL Daily Rates Upload
GL Daily Rates Upload ================== Use this upload to upload new or update existing GL Daily Exchange Rate Conversions. If exchange rates do not already exist for the entered data, they will be created. If exchange rates do already exist for the entered data, they will be updated.
General Ledger Enginatics, Upload XML
GL Journals (Drilldown)
** This report is used by the GL Financial Statement and Drilldown report, to show Journal details. ** GL batches and journals report, including amounts and attachments.To enable next level drilldown below columns should be present in Display columns of the custom templates Drill To Subledger Drill To Journal Attachment Drill To Full Journal
General Ledger Enginatics, R12 only XML
GL Journals (Drilldown) 11g
GL batches and journals report, including amounts and attachments.This report is used by the GL Financial Statement and Drilldown report, to show subledger details.
General Ledger Enginatics XML
GL Journals 11i
GL batches and journals report, including amounts and attachments
General Ledger Enginatics XML
GL Oracle FSG Converter 11g
** This report is used by the GL Financial Statement and Drilldown report, to migrate financial statement reports from Oracle FSG. ** The GL Oracle FSG Converter is used for migration of financial statement reports from Oracle Financial Statement Generator (FSG) into the GL Financial Statement and Drilldown (FSG) report. This converter simplifies the process of transferring the existing Oracle FSG reports, allowing users to leverage advanced reporting and drilldown capabilities with minimal setup. This version supports DB versions 11g and 12c. To apply the converter, the profile 'Blitz FSG…
full description
General Ledger Enginatics XML
GL Period Status
Accounting period status of all application modules for all or a selected list of ledgers, operating units and inventory organizations. To see if an accounting period should be opened, use the CAC Accounting Period Status report, as it has more reporting options and features.
General Ledger Enginatics XML
GL Setup Upload
Create and update the General Ledger setup entities that the GL Setup menu maintains, replicating the Calendars (GLXSTCAL), Period Types (GLXSTPTY), Journal Sources (GLXSTSRC), Journal Categories (GLXSTCAT), Encumbrance Types (GLXSTENC), Statistical Units of Measure (GLXSTUOM), Ledger Sets (GLXSTLST), Data Access Sets (GLXSTACC), Journal Reversal Criteria (GLXSTARV) and AutoPost Criteria (GLXSTAPO) forms, plus ledger options. Each row is one of fifteen entity types, chosen in the Row Type column. Only the columns belonging to that entity are read; all other columns are ignored. A template is…
full description
General Ledger Enginatics, R12 only, Upload XML
GL Summary Account Upload
This upload can be used to import Summary Account Templates.
General Ledger Enginatics, R12 only, Upload XML
IEX Collection Note Upload
Creates and updates Collection Notes in Oracle Collections (IEX) - the same notes shown in the Collections work area. Each note is attached at a single Note Level: Customer (party), Account, Bill To, or Collections Transaction. The Note column is limited to 2,000 characters. The upload will reject the row if the note exceeds this. The Note Detail column is limited to 4,000 characters. Note details exceeding this will be truncated. Party Level Notes: Pary Name is required Party Number is required only when the Party Name is not unique. Account Level Notes: Party Name and Account Number…
full description
Enginatics, R12 only, Upload XML
IGI Dossier Maintenance Upload
Upload to create and maintain dossier transactions (budget transfers) for Oracle Public Sector Financials International (IGI). Supports header creation with source and destination budget lines using the seeded IGI Dossier Maintenance APIs.
Enginatics, R12 only, Upload XML
INV Customer Item Cross References
Customer item cross references to the item master, as maintained in the Customer Item Cross References form. One row per cross reference. A customer item without a cross reference shows with blank item columns. Address category and site columns are populated for customer items defined at address category or address level.
Inventory Enginatics XML
INV Cycle count listing
Imported Oracle standard cycle count listing report Source: Cycle count listing (XML) Short Name: INVARCLI_XML DB package: INV_INVARCLI_XMLP_PKG
Inventory Enginatics XML
INV Cycle count open requests listing
Imported Oracle standard Cycle count open requests listing report Source: Cycle count open requests listing (XML) Short Name: INVARORE_XML DB package: INV_INVARORE_XMLP_PKG
Inventory Enginatics XML
INV Cycle count schedule requests
Imported Oracle standard Cycle count schedule requests report Source: Cycle count schedule requests report (XML) Short Name: INVARRTA_XML DB package: INV_INVARRTA_XMLP_PKG
Inventory Enginatics 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 Cycle counts pending approval
Imported Oracle standard Cycle counts pending approval report Source: Cycle counts pending approval report (XML) Short Name: INVARCPA_XML DB package: INV_INVARCPA_XMLP_PKG
Inventory Enginatics XML
INV Item Catalog Descriptive Elements
Report showing item catalog group descriptive elements with their values, descriptions, required and default flags
Inventory Enginatics XML
INV Item Category Assignment
Imported from BI Publisher Description: Item categories report Application: Inventory Source: Item categories report (XML) Short Name: INVIRCAT_XML DB package: INV_INVIRCAT_XMLP_PKG
Inventory Enginatics 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 Default Transaction Locators
Master data report of Inventory Items and the default locators for shipping, receiving or move order receipt transactions
Inventory Enginatics 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 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