MRP Item Forecast – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Detail report for item planning forecast, including forecast description, planner, item, bucket type, forecast start and end dates, current quantity, original qty, project related data, and confidence projection.
Report Parameters
Forecast Set, Forecast, Organization Code, Planner, Item, Project, Forecast Date From, Forecast Date To, Forecast older than x days
Oracle EBS Tables Used
org_organization_definitions, mrp_forecast_items_v, mrp_forecast_dates, mrp_forecast_designators, mtl_system_items_vl, pa_projects_all, pjm_seiban_numbers, pa_tasks, wip_lines, mtl_planners, org_access_view
Report Categories
Related Reports
MRP Item Forecast Upload, MRP Pegging, WIP Entities, INV Safety Stocks, INV Items
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 | MRP Item Forecast 20-Jun-2018 081609.xlsx |
| Blitz Report™ XML Import | MRP_Item_Forecast.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/mrp-item-forecast/ |
MRP Item Forecast - Case Study & Technical Analysis
Executive Summary
The MRP Item Forecast report details the independent demand (forecasts) that drives the planning process. It allows planners to review the specific forecast entries for an item, including the source of the forecast, quantities, and dates. This is crucial for validating the “input” side of the MRP equation.
Business Challenge
If the forecast is wrong, the plan will be wrong (“Garbage In, Garbage Out”). Planners need to validate the forecast data before running the plan.
- Forecast Accuracy: “Why is the system planning for 10,000 units? Did someone enter an extra zero?”
- Source Identification: “Is this demand coming from the Sales Forecast or the Marketing Promo Forecast?”
- Consumption: “Has this forecast been ‘consumed’ by actual sales orders, or is it still driving additional production?”
Solution
The MRP Item Forecast report lists the detailed forecast entries.
Key Features:
- Forecast Sets: Identifies which forecast set (scenario) the data belongs to.
- Granularity: Shows individual forecast entries with dates and quantities.
- Project Association: Can link forecasts to specific projects (for Project Manufacturing).
Technical Architecture
The report queries the Master Scheduling/MRP forecast tables.
Key Tables and Views
MRP_FORECAST_ITEMS_V: The primary view for forecast entries.MRP_FORECAST_DESIGNATORS: Defines the forecast names and sets.MRP_FORECAST_DATES: Stores the specific dates and quantities for each forecast entry.
Core Logic
- Selection: Filters forecasts based on the Forecast Set and Item.
- Details: Retrieves the quantity, date, and bucket type (Day/Week/Period) for each entry.
- Consumption Logic: (Depending on the view used) may show the original forecast quantity versus the current (unconsumed) quantity.
Business Impact
- Plan Accuracy: Ensures that the manufacturing plan is based on valid and verified demand signals.
- Collaboration: Facilitates discussions between Sales (who generate the forecast) and Operations (who execute it).
- Inventory Management: Prevents over-production caused by obsolete or duplicate forecast entries.
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