MRP Item Forecast Upload – Oracle EBS SQL Report

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

Overview

MRP Item Forecast Upload ================================

Prerequisites/Restrictions

Upload Modes

Create

Opens an empty spreadsheet where the user can enter new Forecast Entries against any accessible Forecast.

Use the Organization Code, Forecast Set, Forecast Name parameters to restrict the Organizations, Forecast Sets, and Forecasts LOVs in the spreadsheet.

Create and Update

Create new Forecast Entries and/or Modify Existing Forecast Entries.

Allows the user to

This mode allows the creation of Forecast Entries against Forecasts not included in the download. This mode can be used for downloading Forecast Entries from an existing Forecast and copying them to a different Forecast.

Update

Modify (Add/Update/Delete) Forecast Entries against the downloaded Forecasts only.

Allows the user to

This mode does not allow the creation of Forecast Entries against Forecasts not included in the download.

Parameters that control the upload behaviour:

Delete Existing Forecast

Select ‘DELETE all existing forecast entries and replace’ if this upload will replace all existing entries in the forecast. In this case all existing forecast entries are deleted before the new forecast entries are loaded. Select ‘KEEP existing forecast entries and update’ if this upload is creating new entries to add to the forecast and/or updating/deleting specific forecast entries. In this case the existing forecast entries are retained. The option to delete the existing forecast is only available when the upload is run in the Create upload mode.

Default Bucket Type

This is the default bucket type used for the forecast entries if not specified in the upload spreadsheet. It will default from the selected forecast name, selected forecast set or will default to Days if a Forecast Set or Forecast Name is not specified. This can be overridden in the Upload spreadsheet for individual forecast entries.

Default Workday Control

This parameter determines the default behaviour for handling a non-workday forecast date or forecast end date. The options are Reject the forecast entry, shift the date backwards to the previous working bucket date, or shift the date forward to the next working bucket date.
This can be overridden in the Upload spreadsheet for individual forecast entries.

Report Parameters

Upload Mode, Delete Existing Forecast, Default Bucket Type, Default Workday Control, Organization Code, Forecast Set, Forecast Name, Planner, Item, Project, Forecast Date From, Forecast Date To

Oracle EBS Tables Used

pa_projects_all, pjm_seiban_numbers, pa_tasks, wip_lines, mtl_parameters, mrp_forecast_designators, mrp_forecast_items_v, mrp_forecast_dates, mtl_system_items_vl

Report Categories

Enginatics, R12 only, Upload

MRP Item Forecast, MRP Pegging, WIP Entities, INV Safety Stocks

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 Upload - Default 04-May-2025 154504.xlsm
Blitz Report™ XML Import MRP_Item_Forecast_Upload.xml
Full SQL on Enginatics www.enginatics.com/reports/mrp-item-forecast-upload/

MRP Item Forecast Upload - Case Study & Technical Analysis

Executive Summary

The MRP Item Forecast Upload is a data management tool designed to streamline the maintenance of demand forecasts. Instead of manually entering forecast quantities line-by-line in the Oracle forms, planners can use this tool to upload, update, or delete forecast entries in bulk via Excel.

Business Challenge

Managing forecasts for thousands of items is tedious and error-prone when done manually.

Solution

The MRP Item Forecast Upload provides a bi-directional interface for forecast data.

Key Features:

Technical Architecture

The tool uses a WebADI-style approach (Blitz Report Upload) to interface with the MRP forecast tables.

Key Tables and Views

Core Logic

  1. Download (Optional): Retrieves existing forecast data based on parameters (Organization, Forecast Set).
  2. Validation: Checks that the Item, Organization, and Forecast Name exist and are valid.
  3. Processing:
    • Insert: Creates new records in MRP_FORECAST_DATES.
    • Update: Modifies existing records matching the primary key (Forecast, Item, Date, Bucket).
    • Delete: Removes records where the uploaded quantity is 0.

Business Impact

© 2026 Enginatics