Search Results mrp_designators




Overview
Explore in AI Chat

Overview

The MRP_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 storing plan names, which are referred to as "compile designators." A compile designator is a unique identifier for a specific production or material plan within an organization. This table is fundamental to the planning engine, as every MRP, DRP, or MPS plan executed within the system must be associated with a defined entry in this table. Its primary role is to provide a validated list of available plans, ensuring referential integrity and consistency across the planning suite.

Key Information Stored

The table's structure is designed to uniquely identify a plan within the context of a specific inventory organization. The primary key constraint MRP_DESIGNATORS_PK enforces uniqueness on the combination of two critical columns: COMPILE_DESIGNATOR and ORGANIZATION_ID. The COMPILE_DESIGNATOR column stores the name of the plan (e.g., 'MASTER_PLAN', '2024_Q1_MRP'). The ORGANIZATION_ID column links the designator to a specific inventory organization, as defined in INV_ORG_PARAMETERS. This relationship is enforced by a foreign key to the MRP_PARAMETERS table, which holds organization-level planning parameters.

Common Use Cases and Queries

This table is primarily referenced for plan setup, maintenance, and reporting. Common operational scenarios include validating available plans before launching a planning run, generating lists of plans for a given organization, and auditing plan usage. A typical query would join with organization details for a comprehensive report:

  • Listing all defined plans with organization code:
    SELECT md.compile_designator, hou.name org_name
    FROM mrp_designators md,
    hr_operating_units hou
    WHERE md.organization_id = hou.organization_id
    ORDER BY org_name, compile_designator;
  • Checking for a specific plan's existence:
    SELECT 'Plan Exists'
    FROM mrp_designators
    WHERE compile_designator = '&PLAN_NAME'
    AND organization_id = &ORG_ID;

Related Objects

The MRP_DESIGNATORS table has integral relationships with several key planning tables, as indicated by its foreign key constraints. It is the parent table for MRP_PLANS, which stores the detailed output of a planning run; the foreign key ensures every plan record is tied to a valid designator. It is also referenced by MRP_PLAN_SCHEDULES, which holds schedule data for planned orders. The relationship with MRP_PARAMETERS ensures that a designator can only be created for an organization with established MRP parameters. These relationships underscore the table's role as a cornerstone of the planning data model.