MRP Item Forecast – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Master Scheduling/MRP · all Master Scheduling/MRP reports

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.

Show Consumption adds one row per sales order consumption of each forecast entry from the forecast consumption history: sales order, line, customer, ship-to, schedule date, order quantity, consumed quantity and the date the consumption was recorded. A negative consumed quantity reverses an earlier consumption, for example after an order line was cancelled or reduced.

With Show Consumption, the current and original forecast quantity are shown on the first row of each forecast entry only, so that they sum correctly. Original minus current quantity equals the consumed quantity of the entry, unless the forecast quantity was changed manually.

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

Forecast Set, Forecast, Organization Code, Planner, Item, Project, Forecast Date From, Forecast Date To, Forecast older than x days, Show Consumption

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, xxen_report_org_access

Report Categories

Enginatics

MRP Item Forecast Upload, MRP Pegging, WIP Entities, INV Items, INV Safety Stocks, WIP Job Upload, WIP Required Components, MRP Horizontal Plan

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 MRP Item Forecast 20-Jun-2018 081609.xlsx
Blitz Report™ XML Import MRP_Item_Forecast.xml
SQL Source MRP Item Forecast.sql
Full Report 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.

Solution

The MRP Item Forecast report lists the detailed forecast entries.

Key Features:

Technical Architecture

The report queries the Master Scheduling/MRP forecast tables.

Key Tables and Views

Core Logic

  1. Selection: Filters forecasts based on the Forecast Set and Item.
  2. Details: Retrieves the quantity, date, and bucket type (Day/Week/Period) for each entry.
  3. Consumption Logic: (Depending on the view used) may show the original forecast quantity versus the current (unconsumed) quantity.

Business Impact

© Enginatics GmbH