Results for “mrp_horizontal_plan_sc”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.MRP_HORIZONTAL_PLAN_SC is a server-side PL/SQL package within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) / Material Requirements Planning (MRP) module. Its name—"Horizontal Plan"—reflects its central purpose: compiling and presenting the row-and-column image of a plan in which items occupy rows and time buckets (days, weeks, periods) occupy columns, arranged horizontally across the planning horizon. This horizontal layout is the canonical format users expect when reviewing supply, demand, on-hand balances and projected availability on a per-item basis over time.

Rather than serving as a data-entry API, the package is best characterized as a planning presentation and scheduling utility. It assembles the aggregate rates, calendar reference dates and material plan figures required to render horizontal plan output, and it supplies a computational routine for deriving daily production rates. It is a supporting engine invoked by other planning components rather than an end-user-callable interface.

Key Procedures and Functions

Two documented program units are exposed:

• POPULATE_HORIZONTAL_PLAN — The primary routine. It builds the horizontal plan data set, aggregating planning information into the bucket-by-bucket structure required for display and downstream use. It draws on calendar and forecast date tables to establish bucket boundaries, and on material plan and on-hand tables to supply the underlying quantities.
• COMPUTE_DAILY_RATE_T — A computational routine that derives daily rate values, supporting time-phased rate calculations (such as daily production or consumption rates) needed by the horizontal plan and related scheduling logic.

Consistent with ETRM practice, parameter lists are not reproduced here; the procedures are named and their functional roles described only.

Tables Accessed

The package references a broad set of planning tables via APPS synonyms, reflecting its aggregative role:

• Calendar and date tables — BOM_CALENDAR_DATES, BOM_CAL_WEEK_START_DATES, BOM_PERIOD_START_DATES: used to define bucket boundaries and week/period start points for the horizontal axis.
• Rate and quantity tables — MRP_AGGREGATE_RATES, MRP_ONHAND_QUANTITIES, MRP_MATERIAL_PLANS: source of rate, availability and plan figures.
• Demand and forecast tables — MRP_GROSS_REQUIREMENTS, MRP_FORECAST_DATES, MRP_FORECAST_DESIGNATORS, MRP_AVAILABLE_TO_PROMISE: supply demand and forecast context for the plan.
• Plan and parameter tables — MRP_PLANS, MRP_LOAD_PARAMETERS, MRP_PROJECT_PARAMETERS, MRP_FORM_QUERY, MRP_RECOMMENDATIONS: define the plan, its runtime parameters and query/recommendation context.

Usage Notes

MRP_HORIZONTAL_PLAN_SC is referenced by five other packages and by several views and modules, including MRP_KANBAN_ACTUAL_PROD_V, MRP_LINE_SCHEDULES_V, MRP_LINE_SCH_AVAIL_V, MRP_LINE_SCHEDULE_ALGORITHM and WIP_WS_SHORTAGE. This dependency profile indicates that the package is invoked indirectly—typically from horizontal plan display logic, line-scheduling algorithms, kanban processing and shop-floor shortage reporting—rather than being scheduled as a standalone concurrent program. Because it reads and consolidates data from the core MRP and BOM tables, it should be invoked only after a plan has been generated and its memory-based MRP tables populated; calling it outside that context yields no meaningful result. Customizations that depend on it assume plan data already exists.