Search Results mrp_schedule_designators




Overview
Explore in AI Chat

Overview

The MRP_SCHEDULE_DESIGNATORS table is a core master data table within the Oracle E-Business Suite (EBS) Master Scheduling/MRP module. It serves as the central repository for defining and managing all schedule names, known as designators, within the planning system. A schedule designator is a unique identifier for a specific master production schedule (MPS) or material requirements plan (MRP). This table's primary role is to provide a validated list of available schedules that can be referenced by numerous other planning and scheduling entities across the application, ensuring data integrity and consistency in plan execution and reporting.

Key Information Stored

The table's structure is defined by a composite primary key consisting of SCHEDULE_DESIGNATOR and ORGANIZATION_ID, enforcing uniqueness of schedule names per inventory organization. While the provided ETRM metadata does not list all columns, the core data stored includes the schedule identifier and the organizational context. The table's critical function is evidenced by its extensive foreign key relationships. It acts as a parent table, validating the schedule designator values used in key transactional and setup tables such as MRP_PLANS, MRP_SCHEDULE_ITEMS, and MRP_SCHEDULE_INTERFACE.

Common Use Cases and Queries

This table is fundamental for administrative setup, data validation, and reporting. Common operational scenarios include querying all available schedules for a specific organization, validating a user-entered designator before running a plan, or generating a list of plans for archival purposes. A typical reporting query would join this table to MRP_PLANS to get a comprehensive list of defined plans with their status. For technical support, identifying all dependent records before modifying a schedule designator is a critical use case, often involving queries that trace the foreign key relationships documented in the ETRM.

  • Listing all schedule designators for an organization: SELECT schedule_designator FROM mrp_schedule_designators WHERE organization_id = :org_id;
  • Finding plans associated with a specific designator: SELECT p.plan_id, p.compile_designator FROM mrp_plans p, mrp_schedule_designators sd WHERE p.schedule_designator = sd.schedule_designator AND p.organization_id = sd.organization_id AND sd.schedule_designator = 'MAIN_MPS';

Related Objects

As indicated by the foreign key metadata, MRP_SCHEDULE_DESIGNATORS is a hub table with dependencies across the MRP schema. Key related objects include: