Search Results msc_allocation_rules




Overview
Explore in AI Chat

Overview

The MSC_ALLOCATION_RULES table is a core data object within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It serves as the master repository for defining the rules that govern how available supply is allocated to demand across the supply chain during a planning run. These rules are fundamental to the fair-share and allocation planning processes, enabling planners to model and enforce business policies for prioritizing customer orders, channels, or markets when supply is constrained. The table's primary key is the allocation rule name, making each rule a uniquely identifiable entity within the planning server.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the table's primary purpose is to store the definitional attributes of each allocation rule. Based on standard ASCP functionality, key columns typically include ALLOCATION_RULE_NAME, a descriptive column, and flags controlling the rule's behavior. These behavioral controls often determine the rule's type (e.g., fair-share, fixed percentage), the scope of its application (e.g., by item, customer, channel), and its processing sequence. The table acts as a header, with detailed time-phased parameters and specific assignments stored in related child tables.

Common Use Cases and Queries

This table is central to configuration and reporting for allocation-based planning. Common operational scenarios include auditing the list of defined rules, verifying rule assignments before a planning run, and troubleshooting allocation results. A fundamental query retrieves all active rules for review:

SELECT allocation_rule_name, description, enabled_flag FROM msc.msc_allocation_rules WHERE enabled_flag = 'Y' ORDER BY 1;

Another critical use case involves joining to assignment tables to identify which items, organizations, or customers a specific rule governs. Analysts often run queries post-planning to understand which allocation rule was applied to a particular sales order line, which requires navigating from planning output tables back to this rule definition table via the assignment and time-phase structures.

Related Objects

The MSC_ALLOCATION_RULES table has defined foreign key relationships with several important child tables, as documented in the ETRM metadata:

  • MSC_ALLOCATION_ASSIGNMENTS: Links allocation rules to specific entities like items, customers, or shipping methods. The join column is MSC_ALLOCATION_ASSIGNMENTS.ALLOCATION_RULE_NAME.
  • MSC_ALLOC_RULE_TIME_PHASES: Stores the effective dates and detailed time-phased parameters (e.g., percentages, priorities) for each rule. The join column is MSC_ALLOC_RULE_TIME_PHASES.ALLOCATION_RULE_NAME.

These relationships form a hierarchy where MSC_ALLOCATION_RULES is the parent definition, its time phases are detailed in MSC_ALLOC_RULE_TIME_PHASES, and its specific scoping assignments are held in MSC_ALLOCATION_ASSIGNMENTS.