Search Results mrp_schedule_items




Overview
Explore in AI Chat

Overview

The MRP_SCHEDULE_ITEMS table is a core data structure within the Oracle E-Business Suite (EBS) Master Scheduling/MRP module. It serves as the master definition table for all items designated for planning within the system. This table establishes the fundamental link between inventory items, specific organizations, and the master production schedules (MPS) or material requirements plans (MRP) that govern their supply and demand. Its primary role is to define which items are planned by which schedule, making it the authoritative source for the universe of items considered in the planning engine's calculations.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a planned item entry. The critical columns are INVENTORY_ITEM_ID and ORGANIZATION_ID, which link to the item master (MTL_SYSTEM_ITEMS_B), and SCHEDULE_DESIGNATOR, which links to the schedule definitions (MRP_SCHEDULE_DESIGNATORS). Beyond these key identifiers, the table typically stores control attributes that govern how the planning engine processes the item for the specific schedule. While the provided metadata does not list all columns, these attributes often include planning methods (e.g., MPS, MRP, DRP), planning time fences, lot-sizing rules, and safety stock parameters. The presence of a record in this table is a prerequisite for the generation of detailed time-phased supply and demand records in the child MRP_SCHEDULE_DATES table.

Common Use Cases and Queries

This table is central to setup, reporting, and data validation for the planning function. A common use case is verifying the list of items assigned to a specific production or distribution plan. For example, to retrieve all master scheduled items for a given schedule designator in a specific organization, a query would join to the item master for descriptive information:

  • SELECT msi.segment1 item_code, msi.description, msi.primary_uom_code FROM mrp_schedule_items msi, mtl_system_items_b msi WHERE msi.inventory_item_id = msi.inventory_item_id AND msi.organization_id = msi.organization_id AND msi.schedule_designator = 'MASTER_SCHEDULE' AND msi.organization_id = 100;

Another critical scenario involves troubleshooting planning runs; if an item is not being planned as expected, consultants often first confirm its existence and attributes in MRP_SCHEDULE_ITEMS. Data fixes or mass updates to planning parameters for a set of items are also performed via this table, typically through approved APIs or carefully controlled SQL scripts.

Related Objects

The MRP_SCHEDULE_ITEMS table has defined foreign key relationships with several other key EBS tables, as documented in the metadata:

  • MTL_SYSTEM_ITEMS_B: Provides the item master definition. Joined via INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • MRP_SCHEDULE_DESIGNATORS: Defines the schedule (e.g., 'MPS', 'MRP'). Joined via SCHEDULE_DESIGNATOR and ORGANIZATION_ID.
  • MRP_SCHEDULE_DATES: This is a critical child table that holds the time-phased planned supply and demand details generated by a planning run. The relationship is maintained through the key columns INVENTORY_ITEM_ID, ORGANIZATION_ID, and SCHEDULE_DESIGNATOR.