Search Results mrp_load_parameters




Overview
Explore in AI Chat

Overview

The MRP_LOAD_PARAMETERS table is a core data repository within the Oracle E-Business Suite (EBS) Master Scheduling/MRP module. It functions as a control table that stores the specific parameters and rules used to execute forecast and schedule load processes. These processes are critical for transferring master demand data—such as forecasts, sales orders, and master production schedules—into the MRP engine for planning calculations. The table's configuration directly governs how demand is sourced, aggregated, and validated during a planning run, making it essential for accurate Material Requirements Planning (MRP) and Master Production Scheduling (MPS).

Key Information Stored

The table primarily stores identifiers that link to other master data entities, defining the scope and behavior of a load operation. Key columns, as indicated by its foreign key relationships, include ORGANIZATION_ID to specify the inventory organization, and paired sets of designator columns. The SCHEDULE_DESIGNATOR and FORECAST_DESIGNATOR columns define the target master schedule and forecast, respectively, where the loaded data will be placed. Conversely, SOURCE_SCHEDULE_DESIGNATOR and SOURCE_FORECAST_DESIGNATOR identify the specific sources from which to pull demand data. The SELECTION_LIST_NAME and SELECTION_LIST_TYPE columns work in conjunction with the MRP_LOAD_SELECTIONS table to apply detailed item-level filters, controlling exactly which items are included or excluded from the load process.

Common Use Cases and Queries

The primary use case is reviewing or auditing the configuration for a specific organization's planning runs. A technical consultant or analyst might query this table to understand the data flow for a critical plan. A common diagnostic query would join to the designator tables to translate IDs into meaningful names.

SELECT mlp.organization_id,
msd.schedule_designator,
mfd.forecast_designator,
mlp.selection_list_name
FROM mrp.mrp_load_parameters mlp,
mrp.mrp_schedule_designators msd,
mrp.mrp_forecast_designators mfd
WHERE mlp.organization_id = :p_org_id
AND mlp.schedule_designator = msd.schedule_designator
AND mlp.organization_id = msd.organization_id
AND mlp.forecast_designator = mfd.forecast_designator
AND mlp.organization_id = mfd.organization_id;

This table is typically maintained via the Oracle EBS user interface (Navigator: Material Planning > Names > Load Parameters), not via direct SQL manipulation. Data changes are often part of implementing a new planning flow or modifying an existing one to incorporate a new forecast.

Related Objects

As documented by its foreign keys, MRP_LOAD_PARAMETERS has integral relationships with several key master data tables. It references MRP_SCHEDULE_DESIGNATORS twice (for target and source schedules) and MRP_FORECAST_DESIGNATORS twice (for target and source forecasts). It also references MRP_LOAD_SELECTIONS to apply detailed selection criteria. The table is central to the forecast and schedule load engine; therefore, key PL/SQL APIs and concurrent programs (e.g., the MRP Loader) will read from this table to determine execution parameters. Data from this table ultimately feeds into the MRP_RELIEF_INTERFACE and MRP_SYSTEM_ITEMS tables during a planning run.