Results for “mrp_load_parameters”

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

Overview

MRP_LOAD_PARAMETERS is a table in the MRP schema (Master Scheduling/MRP product) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores forecast and master schedule load parameters — the runtime configuration records that control how forecast and schedule data are loaded between sources and destinations during planning activity. Each row represents one load request, capturing the source and destination designators, the load direction, processing status, and any error information returned by the load process. In the MRP data model, this table functions as the transactional control record that the forecast/schedule load concurrent programs read and update as they execute.

The supplied metadata classifies this object heuristically as a link under a Data Vault model. This is a reasonable modeling suggestion: rows in MRP_LOAD_PARAMETERS reference multiple external entities — schedule designators, forecast designators, and selection lists — through foreign keys, and the table's identity is largely determined by the combination of the organization and the designators it joins. It therefore behaves more like a relationship-bearing record than a pure hub or a descriptive satellite.

Key Information Stored

MRP_LOAD_PARAMETERS contains 18 documented columns. The most significant are:

• QUERY_ID — the surrogate identifier for each load invocation record.
• PROCESS_STATUS — indicates the current state of the load request (for example, pending, running, completed, or errored).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS "WHO" audit columns that track creation and modification of the record.
• ORGANIZATION_ID — the inventory organization context for the load.
• SCHEDULE_DESIGNATOR and FORECAST_DESIGNATOR — the destination master schedule and forecast designators being loaded into.
• LOAD_SOURCE and LOAD_DESTINATION — the direction and endpoints of the load (for example, source schedule to destination schedule, or forecast to schedule).
• SOURCE_ORGANIZATION_ID, SOURCE_SCHEDULE_DESIGNATOR, SOURCE_FORECAST_DESIGNATOR — the source-side counterparts identifying where data is read from.
• SELECTION_LIST_NAME and SELECTION_LIST_TYPE — the selection criteria identifying which items are included in the load.
• ERROR_MESSAGE — diagnostic text captured when the load process fails.

No unique index columns are documented in the supplied metadata, so no formal business-key candidate is identified here; the foreign keys to the designator and selection tables act as the principal logical references.

Common Use Cases and Queries

Typical uses include monitoring forecast and schedule load runs, auditing source-to-destination transfers, diagnosing failures recorded in ERROR_MESSAGE, and reporting on selection criteria applied during planning. A representative query retrieves outstanding or failed loads for an organization:

• SELECT query_id, process_status, schedule_designator, forecast_designator, load_source, load_destination, error_message FROM mrp.mrp_load_parameters WHERE organization_id = :org_id AND process_status = 'ERROR';
• Joining to MRP_LOAD_SELECTIONS by SELECTION_LIST_NAME and ORGANIZATION_ID reconciles the parameters with the concrete item selection used in each run.
• Grouping by LOAD_SOURCE and LOAD_DESTINATION supports trend reporting on load volumes and destinations over time.

Related Objects

The documented foreign keys connect MRP_LOAD_PARAMETERS to the following primary reference tables:

• MRP_SCHEDULE_DESIGNATORS — referenced via SCHEDULE_DESIGNATOR (with ORGANIZATION_ID) and via SOURCE_SCHEDULE_DESIGNATOR (with SOURCE_ORGANIZATION_ID).
• MRP_FORECAST_DESIGNATORS — referenced via FORECAST_DESIGNATOR (with ORGANIZATION_ID) and via SOURCE_FORECAST_DESIGNATOR (with ORGANIZATION_ID).
• MRP_LOAD_SELECTIONS — referenced via SELECTION_LIST_NAME together with ORGANIZATION_ID and SELECTION_LIST_TYPE.

These relationships make MRP_LOAD_PARAMETERS the central junction for forecast/schedule loading configuration, linking designator definitions to the selection lists and organizations that drive planning data movement in Oracle EBS.