Search Results msc_item_suppliers




Overview
Explore in AI Chat

Overview

The MSC_ITEM_SUPPLIERS table is a core data repository within the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) module. It functions as the master table for supplier-specific sourcing and procurement parameters used by the planning engine. Its primary role is to store critical lead time, order quantity, and delivery scheduling information that defines the operational relationship between a planned item and a specific supplier at a specific site. This data is essential for generating accurate and feasible procurement plans, as it directly influences order release dates, lot sizing, and the scheduling of expected receipts within the planning horizon.

Key Information Stored

The table's structure is centered on the unique combination of an item, a supplier, and a planning context. Key columns include identifiers that link to the item master (INVENTORY_ITEM_ID, ORGANIZATION_ID, SR_INSTANCE_ID, PLAN_ID) and to the supplier master (SUPPLIER_ID, SUPPLIER_SITE_ID). The critical planning parameters stored typically encompass PROCESSING_LEAD_TIME, which defines the total lead time from order placement to receipt; FIXED_LOT_MULTIPLIER and FIXED_ORDER_QUANTITY for order modifiers; and references to delivery calendars (e.g., DELIVERY_CALENDAR_CODE) that specify valid receiving days. This enables the planning engine to calculate precise need-by dates and generate planned purchase orders that adhere to business rules.

Common Use Cases and Queries

A primary use case is the analysis and validation of supplier sourcing rules prior to running a planning cycle. Planners often query this table to ensure lead times and order modifiers are correctly defined for critical items. Common SQL patterns include joining to item and supplier master tables for reporting. For example, to list all supplier sourcing details for a specific item in a plan:

  • SELECT mis.*, msi.item_name, mtp.partner_name FROM msc_item_suppliers mis, msc_system_items msi, msc_trading_partners mtp WHERE mis.inventory_item_id = msi.inventory_item_id AND mis.plan_id = msi.plan_id AND mis.sr_instance_id = msi.sr_instance_id AND mis.organization_id = msi.organization_id AND mis.supplier_id = mtp.partner_id AND msi.item_name = '<ITEM_NAME>' AND mis.plan_id = <PLAN_ID>;

Another critical use is troubleshooting planning output, where unexpected planned order dates or quantities can be traced back to the foundational data in this table.

Related Objects

MSC_ITEM_SUPPLIERS maintains defined foreign key relationships with several fundamental ASCP base tables, as documented in the ETRM. These relationships are crucial for data integrity and query joins:

This table is also a likely source for various planning-focused views and is heavily referenced by the ASCP planning engine itself when evaluating sourcing options during the plan run.