INV Item Demand History – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Imported from BI Publisher Description: Item demand history report Application: Inventory Source: Item demand history report (XML) Short Name: INVPRFDH_XML DB package: INV_INVPRFDH_XMLP_PKG
Report Parameters
Organization Code, Category Set, Categories From, Categories To, Items From, Items To, Bucket Type, History Start Date
Oracle EBS Tables Used
mfg_lookups, org_organization_definitions, gl_sets_of_books, fnd_currencies, mtl_system_items_kfv, mtl_demand_histories, mtl_item_categories, mtl_categories_kfv
Report Categories
Related Reports
CST Supply Chain Indented Bills of Material Cost, CST Item Cost Reports, CAC New Standard Item Costs, CAC Standard Cost Update Submissions, CAC Last Standard Item Cost
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 Item Demand History - Default Pivot 03-Jun-2023 213208.xlsx |
| Blitz Report™ XML Import | INV_Item_Demand_History.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-item-demand-history/ |
INV Item Demand History - Case Study & Technical Analysis
Executive Summary
The INV Item Demand History report provides a historical view of item usage (demand) over time. It aggregates transaction data to show how much of an item was issued or sold in specific time buckets. This data is the foundation for Inventory Forecasting and Min-Max Planning.
Business Use Cases
- Forecasting: Planners use this history to predict future demand (e.g., “We used 100 units last December, so we should stock up for this December”).
- Min-Max Calculation: The “Calculate Min-Max Planning” program uses this history to suggest new minimum and maximum stock levels.
- Slow Mover Analysis: Identifies items with zero demand over the last 12 months.
Technical Analysis
Core Tables
MTL_DEMAND_HISTORIES: The summary table populated by the “Compile Demand History” concurrent program.MTL_SYSTEM_ITEMS_KFV: Item details.
Key Joins & Logic
- Compilation: This report relies on the
MTL_DEMAND_HISTORIEStable being up-to-date. This table is NOT real-time; it is populated by a background process that summarizesMTL_MATERIAL_TRANSACTIONS. - Bucketing: Demand is aggregated into buckets (Day, Week, Month) based on the compilation settings.
- Transaction Types: Only specific transaction types (e.g., Sales Order Issue, WIP Issue) are typically considered “Demand”.
Key Parameters
- Bucket Type: Daily, Weekly, or Monthly.
- History Start Date: The lookback period.
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
© 2026 Enginatics