Search Results msc_sourcing_rules




Overview
Explore in AI Chat

Overview

The MSC_SOURCING_RULES table is a core data repository within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It serves as the master table for defining and storing all sourcing rules and bills of distribution. These rules are fundamental planning parameters that dictate how the planning engine fulfills demand. They specify the hierarchy of supply sources—such as specific organizations, suppliers, or transfer networks—to be used for procuring or manufacturing items. The integrity and configuration of data in this table directly govern the material flow logic within ASCP-generated plans, making it a critical object for supply chain optimization.

Key Information Stored

While the provided metadata does not list specific columns, the primary key and foreign key relationships indicate the nature of the data. The table's primary identifier is SOURCING_RULE_ID, a unique system-generated key for each sourcing rule definition. Based on its role, the table typically stores attributes that define the rule's type (e.g., sourcing rule, bill of distribution), name, description, effective dates, and assignment level. The core logic of the rule—specifying the ranked list of source organizations, supplier sites, or make-at locations—is stored in related detail tables, such as MSC_SR_RECEIPT_ORG, which are linked via the SOURCING_RULE_ID foreign key.

Common Use Cases and Queries

The primary use case is analyzing and reporting on the sourcing rules configured within the planning environment. Common queries involve joining this table to its assignment and detail tables to understand the complete sourcing setup. For instance, to list all sourcing rules and their assigned items, a query would join MSC_SOURCING_RULES to MSC_ITEM_SOURCING. Troubleshooting planning output often requires verifying the active sourcing rule for a specific item-organization combination. A typical pattern is to query the rule name and ID for a given assignment.

SELECT msr.sourcing_rule_name, msr.sourcing_rule_id
FROM msc_sourcing_rules msr,
     msc_item_sourcing mis
WHERE msr.sourcing_rule_id = mis.sourcing_rule_id
  AND mis.organization_id = :org_id
  AND mis.inventory_item_id = :item_id;

Related Objects

As per the documented foreign keys, MSC_SOURCING_RULES has several critical dependencies. The MSC_ITEM_SOURCING table stores the direct assignment of a sourcing rule to a specific item and organization. The MSC_SR_ASSIGNMENTS table manages higher-level assignments, such as to categories or entire organizations. The MSC_SR_RECEIPT_ORG table is a key child table that holds the detailed, ranked list of source organizations or supplier sites defined within the rule. These relationships form the core data model for sourcing rule definition and execution within Oracle ASCP.