Results for “mrp_designators”

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

Overview

MRP_DESIGNATORS is a table in the MRP schema owned by the Master Scheduling/MRP product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the set of plan designators — the named, organization-scoped identifiers under which MRP, DRP, and MPS planning runs compile and persist their results. Each row represents a valid combination of a compile designator and an organization, and acts as the parent definition that planning engines reference when writing plan output. The table is therefore central to how Oracle Manufacturing plans are labeled, scoped, and isolated from one another.

Under a heuristic Data Vault classification mined from the foreign-key structure, MRP_DESIGNATORS is hub-leaning: its composite primary key is a stable, non-volatile business key that other planning tables reference, which is characteristic of a hub entity.

Key Information Stored

The table is documented with 34 columns. The most significant are:

• COMPILE_DESIGNATOR and ORGANIZATION_ID — the composite primary key, MRP_DESIGNATORS_PK, and also the unique business-key candidate exposed by unique index MRP_DESIGNATORS_U1. COMPILE_DESIGNATOR names the plan run, while ORGANIZATION_ID scopes it to a specific inventory organization.
• DESCRIPTION — the user-facing description of the designator.
• DISABLE_DATE — indicates when the designator is no longer active for planning.
• FEEDBACK_FLAG — controls feedback behavior during the planning cycle.
• USE_NEW_PLANNER — flag governing whether the new planner engine is applied.
• ORGANIZATION_SELECTION — defines how organizations are selected for the plan.
• DRP_PLAN — identifies whether the designator drives distribution requirements planning.
• PRODUCTION — indicates production-planning usage.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — provide concurrent-program and change-tracking context.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle descriptive-flexfield columns for extensible data.

Common Use Cases and Queries

Typical uses include identifying all designators for an organization, checking whether a designator is still active, and confirming which plans reference a given designator before cleanup.

• List active designators for an organization:
  SELECT compile_designator, description, disable_date FROM mrp.mrp_designators WHERE organization_id = :org_id AND (disable_date IS NULL OR disable_date > SYSDATE);
• Resolve the descriptive attributes of a designator referenced by a plan:
  SELECT d.compile_designator, d.description FROM mrp.mrp_designators d, mrp.mrp_plans p WHERE d.compile_designator = p.compile_designator AND d.organization_id = p.organization_id;
• Audit recently changed designators via the program-update tracking columns.

Related Objects

MRP_DESIGNATORS participates in a small but tightly coupled dependency cluster:

• MRP_PARAMETERS — referenced via MRP_DESIGNATORS.ORGANIZATION_ID; supplies organization-level planning parameters.
• MRP_PLANS — references this table through MRP_PLANS.COMPILE_DESIGNATOR and MRP_PLANS.ORGANIZATION_ID; holds the defined plans tied to each designator.
• MRP_PLAN_SCHEDULES — references this table via MRP_PLAN_SCHEDULES.INPUT_NAME and INPUT_ORGANIZATION_ID; drives scheduled-plan execution.

Because both MRP_PLANS and MRP_PLAN_SCHEDULES hold foreign keys into this hub, MRP_DESIGNATORS cannot be purged or re-keyed without first reconciling those dependent planning records.