INV Item Demand History – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Inventory · all Inventory reports
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
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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, INV Items, CST Item Cost Reports, INV Item Upload 11i, INV Item Upload
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
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 |
| SQL Source | INV Item Demand History.sql |
| Full Report 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
© Enginatics GmbH