Skip to content

README.md

Latest commit

 

History

History
96 lines (71 loc) · 7.02 KB

README.md

File metadata and controls

96 lines (71 loc) · 7.02 KB
layout default
title MRP Horizontal Plan | Oracle EBS SQL Report
description MRP: Horizontal Plan from the Planners Workbench. - The report can be run for multiple organizations and items within a selected plan - The report can be…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, MRP, Horizontal, Plan, mrp_material_plans, mrp_workbench_bucket_dates, table
permalink /MRP%20Horizontal%20Plan/

MRP Horizontal Plan – Oracle EBS SQL Report

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

Overview

MRP: Horizontal Plan from the Planners Workbench.

  • The report can be run for multiple organizations and items within a selected plan
  • The report can be used to explode BOMS and display the HP for all components within the BOM
  • Select a template to choose to either display the HP by individual components, or by End Assemblies, Components.

Report Parameters

Plan, Current or Snapshot Data, Buckets, Organization Code, Category Set, Category, Item Type, Exclude Item Type, Item, Item From, Item To, Item Contains, Explode BOMs, Exclude Items with No Activity, Make or Buy, Planner, Buyer, Supply/Demand Source

Oracle EBS Tables Used

mrp_material_plans, mrp_workbench_bucket_dates, table, mrp_system_items, ap_suppliers, per_people_x, mmp, mtl_system_items_vl, mtl_item_categories, mtl_categories_kfv, mtl_planners, bom_small_expl_temp, mrp_end_assemblies

Report Categories

Enginatics, R12 only

Related Reports

MRP Plan Orders, MSC Horizontal Plan, MSC Plan Order Upload, MRP Pegging, MRP Item Forecast Upload, MRP Item Forecast, MSC Plan Orders

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 Horizontal Plan 26-Jul-2021 041459.xlsx
Blitz Report™ XML Import MRP_Horizontal_Plan.xml
Full SQL on Enginatics www.enginatics.com/reports/mrp-horizontal-plan/

MRP Horizontal Plan - Case Study & Technical Analysis

Executive Summary

The MRP Horizontal Plan is the classic "spreadsheet" view of the material plan. It displays supply, demand, and projected available balance (PAB) in time buckets (days, weeks, periods) across the horizon. It is the fundamental tool for planners to visualize the supply/demand balance for an item over time.

Business Challenge

Planners need to see the "story" of an item's inventory. A simple list of orders isn't enough; they need to see how the inventory level fluctuates.

  • Trend Analysis: "Are we consistently running low on stock at the end of the month?"
  • Capacity Planning: "Do we have a huge spike in demand in Week 40 that we need to prepare for?"
  • Safety Stock Visibility: "When does our projected balance dip below the safety stock level?"

Solution

The MRP Horizontal Plan provides a time-phased view of all planning elements.

Key Features:

  • Time Buckets: Aggregates data into daily, weekly, or monthly columns.
  • Row Types: Displays separate rows for Gross Requirements, Scheduled Receipts, Planned Orders, and Projected Available Balance.
  • BOM Explosion: Can optionally explode the bill of materials to show requirements for components.

Technical Architecture

The report mimics the "Horizontal Plan" form in the Planner's Workbench.

Key Tables and Views

  • MRP_MATERIAL_PLANS: The core table storing the time-phased data (bucketed quantities) for the plan.
  • MRP_WORKBENCH_BUCKET_DATES: Defines the start and end dates for the time buckets.
  • MRP_SYSTEM_ITEMS: Stores plan-specific item attributes (like safety stock levels for that specific plan).

Core Logic

  1. Bucketing: The system aggregates individual supply/demand records into the defined time buckets.
  2. Calculation: It calculates the Projected Available Balance (PAB) for each bucket: Previous PAB + Supply - Demand.
  3. Presentation: Pivots the data so that time periods are columns and data types (Supply, Demand) are rows.

Business Impact

  • Visual Planning: Makes it easy to spot trends and potential issues at a glance.
  • Communication: Provides a clear, standard format for discussing inventory plans with suppliers or production managers.
  • Stability: Helps planners smooth out production by visualizing peaks and valleys in demand.

Useful Links

© 2026 Enginatics