INV Slow Moving Inventory – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

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 their value, usage rate and months of supply, for obsolescence provisioning.

On Hand is the quantity as of the As of Date, not the current quantity. It is rolled back like Oracle’s Transaction Historical Summary report, by reversing every material transaction posted after that date. Values use the item cost of the organization’s primary cost method.

The no activity test is made per item, so an item is dropped as a whole as soon as any of its subinventories moved. Ignore Adjustment Transactions excludes cycle count adjustments, physical inventory adjustments and cost updates from that test and from Last Transaction Date. Logical transactions never count as activity.

Usage Quantity is the quantity issued out of stock over the Usage Months preceding the As of Date. Months of Supply stays empty where there was no usage at all, which identifies the items that have not moved once in the whole window.

Rows are per subinventory; Item On Hand and Item On Hand Value are the item totals across subinventories.

Report Parameters

Organization Code, As of Date, No Activity Since, Usage Months, Ignore Adjustment Transactions, Subinventory, Item, Category Set 1, Category Set 2, Category Set 3

Oracle EBS Tables Used

mtl_onhand_quantities_detail, mtl_parameters, org_access_view, mtl_material_transactions, hr_all_organization_units_vl, mtl_secondary_inventories, mtl_system_items_vl, cst_item_costs, cst_cost_types, mtl_transaction_types

Report Categories

Enginatics

INV Onhand Quantities, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Inventory Pending Cost Adjustment - No Currencies, CAC Inventory Pending Cost Adjustment, CAC Onhand Lot Value (Real-Time), CAC ICP PII Inventory Pending Cost Adjustment, CAC Inventory Lot and Locator OPM Value (Period-End), CAC ICP PII vs. Item Costs, CAC Zero Item Costs

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output INV Slow Moving Inventory 16-Aug-2026 153453.xlsx
Blitz Report™ XML Import INV_Slow_Moving_Inventory.xml
Full SQL on Enginatics www.enginatics.com/reports/inv-slow-moving-inventory/

© 2026 Enginatics