Search Results msc_allocation_assignments_pk

Overview

The MSC_ALLOCATION_ASSIGNMENTS table is a core data repository within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It functions as the definitive store for allocation assignment records, which are critical for enforcing fair-share and allocation-based sourcing logic during the planning run. This table enables planners to define and manage specific rules that dictate how constrained supply is proportionally distributed among demanding organizations, customer classes, or sales channels, ensuring that business priorities are systematically reflected in the planned order output.

Key Information Stored

The table's primary structure centers on linking allocation rules to specific resource groups. The key identifier is the ASSIGNMENT_ID, which is the table's primary key. Two columns form the essential relationship: ALLOCATION_RULE_NAME, which references a defined rule in the MSC_ALLOCATION_RULES table, and the combination of SR_INSTANCE_ID and RESOURCE_GROUP, which references a specific planning instance and resource group defined in MSC_RESOURCE_GROUPS. This assignment effectively binds a high-level allocation policy (the rule) to the specific entities (the resource groups) that will be subject to that policy during supply planning.

Common Use Cases and Queries

The primary use case is the configuration and auditing of allocation setups prior to a planning run. Planners utilize this data to verify that all intended product families or customer segments are correctly associated with the appropriate allocation percentages or priorities defined in the rule. A common diagnostic query involves listing all assignments for a given rule to validate coverage.

• Sample Query: Retrieving all resource groups assigned to a specific allocation rule.
  SELECT assignment_id, sr_instance_id, resource_group
FROM msc_allocation_assignments
WHERE allocation_rule_name = '&RULE_NAME'
ORDER BY resource_group;
• Reporting Use Case: Generating a summary report that joins with MSC_ALLOCATION_RULES and MSC_RESOURCE_GROUPS to provide a complete view of the allocation setup, showing rule details alongside their assigned groups.

Related Objects

MSC_ALLOCATION_ASSIGNMENTS sits at the intersection of two key planning entities, as defined by its foreign key constraints.

• MSC_ALLOCATION_RULES: This is the parent table containing the definition of the allocation rule itself (e.g., rule name, type, percentages). The ALLOCATION_RULE_NAME in MSC_ALLOCATION_ASSIGNMENTS references this table.
• MSC_RESOURCE_GROUPS: This table defines the resource groups, which are collections of items, customers, or organizations. The composite foreign key (SR_INSTANCE_ID, RESOURCE_GROUP) in MSC_ALLOCATION_ASSIGNMENTS references this table, linking the rule to the specific group of entities it governs.
• The table's primary key constraint, MSC_ALLOCATION_ASSIGNMENTS_PK, ensures the uniqueness of each ASSIGNMENT_ID, maintaining data integrity for this critical configuration.