Search Results mrp_sr_assignments




The MRP_SR_ASSIGNMENTS table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical repository for storing sourcing rule assignments within the Manufacturing and Supply Chain Planning modules. Sourcing rules define how items are sourced from different suppliers, organizations, or transfer networks, enabling organizations to optimize procurement, production, and distribution strategies. This table plays a pivotal role in Material Requirements Planning (MRP), Advanced Supply Chain Planning (ASCP), and Global Order Promising (GOP) processes by maintaining associations between items, organizations, and sourcing rules.

Key Attributes of MRP_SR_ASSIGNMENTS

The table contains several key columns that define sourcing relationships:
  • ASSIGNMENT_ID: Primary key uniquely identifying each sourcing rule assignment.
  • SOURCING_RULE_ID: Foreign key reference to MRP_SOURCING_RULES table defining the sourcing strategy.
  • ORGANIZATION_ID: Identifies the inventory organization to which the sourcing rule applies.
  • INVENTORY_ITEM_ID: References MTL_SYSTEM_ITEMS_B to identify the item being sourced.
  • CATEGORY_ID: Optional category assignment for category-level sourcing rules.
  • ASSIGNMENT_TYPE: Specifies whether assignment is for an item, category, or organization.
  • EFFECTIVE_DATE: Date range during which the sourcing rule is active.
  • DISABLE_DATE: Optional expiration date for the sourcing rule assignment.

Functional Integration

MRP_SR_ASSIGNMENTS integrates with multiple Oracle EBS modules:
  • MRP Planning: Determines supply sources during plan generation.
  • ASCP: Provides constraint-based sourcing alternatives in advanced planning.
  • Purchasing: Influences supplier selection in requisitions and purchase orders.
  • Order Management: Guides ATP (Available-to-Promise) checks for order promising.

Technical Implementation

The table follows Oracle EBS standards with:
  • Indexes on key columns (ASSIGNMENT_ID, SOURCING_RULE_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID) for performance.
  • Foreign key constraints to maintain referential integrity with MRP_SOURCING_RULES and MTL_SYSTEM_ITEMS_B.
  • WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, etc.) for auditing.

Business Process Flow

Sourcing rule assignments follow this typical lifecycle:
  1. Definition in MRP_SOURCING_RULES
  2. Assignment to items/categories via MRP_SR_ASSIGNMENTS
  3. Consumption by planning engines during MRP/ASCP runs
  4. Execution through procurement or manufacturing processes

Customization Considerations

While Oracle provides standard APIs for maintaining sourcing rules (MRP_SOURCING_RULE_PKG), customizations may require:
  • Additional attributes via descriptive flexfields
  • Custom validation logic for complex sourcing scenarios
  • Extension tables for supplemental data requirements

Version-Specific Notes

Between 12.1.1 and 12.2.2, the table structure remains largely consistent, with 12.2.2 potentially including:
  • Enhanced partitioning for large-scale implementations
  • Additional indexes for cloud-scale performance
  • Tighter integration with Fusion Middleware components
The MRP_SR_ASSIGNMENTS table embodies Oracle's strategic sourcing capabilities, enabling organizations to implement complex multi-tier supply chain strategies while maintaining data integrity and system performance.