Search Results mrp_assignment_sets




Overview
Explore in AI Chat

Overview

The MRP_ASSIGNMENT_SETS 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 sourcing assignment sets. An assignment set is a key configuration object that defines a collection of sourcing rules and bills of distribution, which are then assigned to specific items, organizations, and categories. These rules govern how the MRP and Master Scheduling engines determine the source of supply—such as from which supplier, internal organization, or transfer-from organization—for planned orders, purchase requisitions, and internal requisitions generated during a plan run. The table's primary role is to provide a reusable, named set of these sourcing assignments that can be linked to an MRP plan.

Key Information Stored

The table's central column is the ASSIGNMENT_SET_ID, which is the primary key and uniquely identifies each assignment set definition within the system. While the provided ETRM metadata does not list all columns, typical columns in this table, based on its function, would include ASSIGNMENT_SET_NAME for the user-defined identifier and a DESCRIPTION. It would also contain standard Oracle EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track the object's lifecycle. The data in this table is primarily maintained through the application's user interface for defining assignment sets.

Common Use Cases and Queries

The primary use case is configuring and reporting on sourcing strategies for MRP plans. A planner creates an assignment set via the "Assignment Sets" form, defining specific sourcing assignments. This set is then selected when defining or running an MRP or Master Schedule plan. Common queries involve identifying which plans use a particular assignment set or listing all defined sets. For example, to find all assignment sets and any associated MRP plans, one might use a query such as:

  • SELECT mas.assignment_set_name, mp.plan_name FROM mrp_assignment_sets mas, mrp_plans mp WHERE mas.assignment_set_id = mp.assignment_set_id(+);

Another critical reporting use case is validating setup by ensuring that active MRP plans have a valid assignment set assigned, which is essential for the plan to execute correctly and generate properly sourced supply suggestions.

Related Objects

As indicated by the foreign key relationships in the metadata, the MRP_ASSIGNMENT_SETS table has direct dependencies with two other key MRP tables. The MRP_PLANS table references it via MRP_PLANS.ASSIGNMENT_SET_ID, linking a specific plan to its sourcing rule definitions. The MRP_SR_ASSIGNMENTS table references it via MRP_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID; this table holds the detailed individual sourcing assignments (linking items, categories, or organizations to specific sourcing rules and bills of distribution) that constitute the set. Therefore, MRP_ASSIGNMENT_SETS acts as the header, with MRP_SR_ASSIGNMENTS as its lines, and MRP_PLANS as a key consuming object.