Results for “mrp_schedule_items”

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

Overview

MRP_SCHEDULE_ITEMS is a Master Scheduling/MRP (MRP) application table in the Oracle E-Business Suite, owned by the MRP schema. It stores the master scheduled items — that is, the inventory items that participate in a given master production schedule or master scheduling run — and acts as the definitive list of items associated with a specific schedule designator within an organization. In EBS 12.1.1 and 12.2.2, the table is documented as VALID and is central to how the MRP engine distinguishes which items are governed by a particular master schedule versus those handled through other planning modes.

Under a heuristic Data Vault classification derived from its foreign key structure, MRP_SCHEDULE_ITEMS is satellite-leaning. It is not a pure reference hub; rather, it extends the combination of item, organization, and schedule into a descriptive record. Modelers may therefore treat MRP_SCHEDULE_ITEMS as a satellite attached to the item/organization hub and the schedule designator hub, since its descriptive attributes (such as MPS explosion level and capacity model) describe the relationship rather than serve as independent business entities.

Key Information Stored

The table contains 30 documented columns. Its primary key, MRP_SCHEDULE_ITEMS_PK, is composed of INVENTORY_ITEM_ID, ORGANIZATION_ID, and SCHEDULE_DESIGNATOR. A separate unique index, MRP_SCHEDULE_ITEMS_U1, covers ORGANIZATION_ID, SCHEDULE_DESIGNATOR, and INVENTORY_ITEM_ID — functionally the same set of business-key columns in a different order, confirming that the item/organization/schedule triplet is the true business key.

• INVENTORY_ITEM_ID — surrogate reference to the master scheduled item in MTL_SYSTEM_ITEMS_B.
• ORGANIZATION_ID — the inventory organization in which the item is scheduled.
• SCHEDULE_DESIGNATOR — identifies which master schedule the item belongs to.
• MPS_EXPLOSION_LEVEL — controls the level of MPS explosion applied to the item.
• CAPACITY_MODEL_ID — identifies the capacity model associated with the scheduled item.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns populated by the process that created or updated the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the descritive flexfield (DFF) columns enabling customer-defined extensions.

Common Use Cases and Queries

The most frequent use of this table is identifying which items are included in a master schedule. A typical query joins it to MTL_SYSTEM_ITEMS_B to resolve item names and to MRP_SCHEDULE_DESIGNATORS to resolve the designator description:

• Listing all items for a schedule: SELECT inventory_item_id, organization_id, schedule_designator FROM mrp.mrp_schedule_items WHERE schedule_designator = :designator;
• Resolving item detail: join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• Reporting MPS explosion or capacity model configuration by item.
• Auditing DFF attribute values populated for master scheduled items using ATTRIBUTE_CATEGORY and ATTRIBUTE1–15.
• Validating that an item is master scheduled before running an MPS/MRP plan.

Related Objects

The documented foreign keys and dependencies establish the following significant relationships:

• MTL_SYSTEM_ITEMS_B — joined on MRP_SCHEDULE_ITEMS.INVENTORY_ITEM_ID and MRP_SCHEDULE_ITEMS.ORGANIZATION_ID to resolve item and organization attributes.
• MRP_SCHEDULE_DESIGNATORS — joined on MRP_SCHEDULE_ITEMS.SCHEDULE_DESIGNATOR and MRP_SCHEDULE_ITEMS.ORGANIZATION_ID to resolve schedule metadata.
• MRP_SCHEDULE_DATES — references MRP_SCHEDULE_ITEMS on INVENTORY_ITEM_ID, ORGANIZATION_ID, and SCHEDULE_DESIGNATOR, holding the dated schedule entries for each item.

Collectively, these relationships confirm that MRP_SCHEDULE_ITEMS occupies the anchor position for master scheduled item configuration, with MRP_SCHEDULE_DATES providing the time-phased schedule data layered beneath it.