Oracle EBS Inventory Reports
53 ready-to-run SQL reports for Oracle E-Business Suite Inventory, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Inventory tables in these reports are mtl_system_items_vl, org_access_view, mtl_parameters, mtl_item_locations_kfv, org_organization_definitions, mtl_material_transactions.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
Inventory SQL Reports
| Report | Description |
|---|---|
| INV ABC assignments | Imported from BI Publisher Description: ABC assignments report Application: Inventory Source: ABC assignments report (XML) Short Name: INVARAASXML DB package… |
| 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… |
| 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… |
| INV Cycle count entries and adjustments | Imported Oracle standard Cycle count entries and adjustments report Source: Cycle count entries and adjustments report (XML) Short Name: INVARCTAXML DB… |
| INV Cycle count hit/miss analysis | Imported Oracle standard Cycle count hit/miss analysis report Source: Cycle count hit/miss analysis (XML) Short Name: INVARHMAXML DB package: INVINVARHMAXMLPPKG |
| INV Cycle count listing | Imported Oracle standard cycle count listing report Source: Cycle count listing (XML) Short Name: INVARCLIXML DB package: INVINVARCLIXMLPPKG |
| INV Cycle count open requests listing | Imported Oracle standard Cycle count open requests listing report Source: Cycle count open requests listing (XML) Short Name: INVAROREXML DB package… |
| INV Cycle count schedule requests | Imported Oracle standard Cycle count schedule requests report Source: Cycle count schedule requests report (XML) Short Name: INVARRTAXML DB package… |
| INV Cycle count unscheduled items | Imported Oracle standard Cycle count unscheduled items report Source: Cycle count unscheduled items report (XML) Short Name: INVARUIRXML DB package… |
| INV Cycle counts pending approval | Imported Oracle standard Cycle counts pending approval report Source: Cycle counts pending approval report (XML) Short Name: INVARCPAXML DB package… |
| INV Default Category Sets | Master data report that lists Inventory functional areas and their default category sets |
| INV Intercompany Invoice Reconciliation | Intercompany invoice reconciliation for inventory transactions, including shipping and receiving organizations, ordered, transacted and invoiced quantities… |
| INV Item Attribute Master/Child Conflicts | Identifies existing Item Attribute Master/Child attribute value conflicts for Item Attributes controlled at the Master Organization Level. These errors show as… |
| INV Item Catalog Descriptive Elements | Report showing item catalog group descriptive elements with their values, descriptions, required and default flags |
| INV Item Category Assignment | Imported from BI Publisher Description: Item categories report Application: Inventory Source: Item categories report (XML) Short Name: INVIRCATXML DB package… |
| INV Item Category Sets | |
| INV Item Default Transaction Locators | Master data report of Inventory Items and the default locators for shipping, receiving or move order receipt transactions |
| INV Item Default Transaction Subinventories | Master data report of inventory item relationships including the type of relationship between the item and the subinventory. |
| INV Item Demand History | Imported from BI Publisher Description: Item demand history report Application: Inventory Source: Item demand history report (XML) Short Name: INVPRFDHXML DB… |
| INV Item Import Performance | Analytical report by item to predict performance of inventory item load background processes. If the number of items processed per second is decreasing with… |
| INV Item Relationships | Master listing for Inventory item relationships |
| INV Item Reservations | Imported from BI Publisher Description: Item reservations report Application: Inventory Source: Item reservations report (XML) Short Name: INVDRRSVXML DB… |
| INV Item Statuses | Master data report of inventory items with the various status attributes, such as: is BOM allowed, Build in WIP, customer orders enabled, internal orders… |
| INV Item Supply/Demand | Inventory Item Supply/Demand data as per the standard Inventory Item Supply/Demand form |
| INV Item Templates | Inventory item templates and their item attribute values |
| INV Items | Master data report that lists item master attributes such as item type, UOM, status, serial control, account numbers and various other attributes |
| INV Kanban Cards | Kanban cards with their pull sequence, one row per card, including card type, card status, supply status and card kanban size. Replenishment Cycles and Last… |
| INV Lot Transaction Register | Imported from BI Publisher Description: Lot transaction register Application: Inventory Source: Lot transaction register (XML) Short Name: INVTRLNTXML DB… |
| INV Material Account Distribution Detail | Description: Material account distribution detail Application: Inventory Source: Material account distribution detail (XML) Short Name: INVTRDSTXML |
| INV Material Movements | Detailed report of On Hand Quantity with stock movements by Item , Org Code . Material Movements involve cumulative buckets for stock/in/mvmt and month wise… |
| 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… |
| INV Material Transactions | Detail report of Inventory transactions with item, primary qty, secondary qty, transaction type, transaction ID and total transaction qty |
| INV Material Transactions Summary | Summary report of Inventory item movement including transaction type, source type, and transaction ID’s. |
| INV Move Orders | Move order lines of all move order types (requisition, replenishment, pick wave, manufacturing component pick, put away), one row per line, with requested… |
| INV Movement Statistics | Imported from BI Publisher Description: Movement Statistics Report (INTRASTAT Report) Application: Inventory Source: Movement Statistics Report (XML) Short… |
| INV Onhand Quantities | Detail report inventory item quantities by org, sub inventory, location, unit of measure, quantity on hand, quantity reserved, quantity unpacked, lot number… |
| INV Organization Access | Inventory organization access for all responsibilities, either through hr security profile or individual orgaccess assignment. |
| INV Organization Parameters | |
| 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… |
| INV Physical Inventory Adjustments | Imported from BI Publisher Description: Physical inventory adjustments report Application: Inventory Source: Physical inventory adjustments report (XML) Short… |
| INV Physical Inventory Locator Count Sheet | Count sheet listing every active stock locator of the quantity tracked subinventories, as an alternative to printed physical inventory tags. One row per item… |
| INV Physical Inventory Tags | Imported from BI Publisher Description: Physical Inventory Tags Application: Inventory Source: Physical Inventory Tags (XML) Short Name: INVARPTPXML DB… |
| INV Physical inventory accuracy analysis | Imported from BI Publisher Description: Physical inventory accuracy analysis Application: Inventory Source: Physical inventory accuracy analysis (XML) Short… |
| 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… |
| INV Safety Stocks | Master data report for inventory safety stock with inventory org code, item, effective date, UOM,safety stock quantity, safety stock method, forecast , safety… |
| INV Serial Numbers | Serial numbers in any status (defined, in stores, issued out of stores, in transit, in receiving, in WIP), one row per serial number, with current… |
| INV Slow Moving Inventory | Slow moving, excess and obsolete inventory. Lists items still holding stock as of a chosen date that have had no material movement over a chosen period, with… |
| INV Stock Locators | Summary report for Inventory locations, showing locator number, description, type, status, subinventory, picking order, dropping order and unit, volume… |
| INV Subinventories | Profile subinventory report with subinventory name, description, status, default cost group, type, restriction attributes, and general ledger account linkages… |
| INV Transaction Historical Summary | Application: Inventory Description: Transaction Historical Summary Report This report provides equivalent functionality to the Oracle standard Transaction… |
| INV Transaction Register | Imported from BI Publisher Description: Transaction register Application: Inventory Source: Transaction register (XML) Short Name: INVTRREGXML DB package… |
| INV Transaction Source Types | |
| INV Transaction Types |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH