Search Results msc_system_items
The MSC_SYSTEM_ITEMS
table is a critical data structure in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically within the Oracle Advanced Supply Chain Planning (ASCP) and Manufacturing modules. This table serves as a repository for item master data that is synchronized between Oracle Inventory (MTL_SYSTEM_ITEMS_B
) and the planning engine. Below is a detailed breakdown of its purpose, structure, and key attributes:
Purpose and Context
The MSC_SYSTEM_ITEMS
table stores item definitions used by Oracle ASCP for demand forecasting, supply planning, and inventory optimization. It acts as a staging area where item data from source systems (e.g., Oracle Inventory) is transformed and enriched for planning purposes. The table is populated during the "Snapshot" process, which extracts data from transactional systems into the planning engine's schema (MSC
). Key use cases include:
- Item attribute synchronization between inventory and planning modules.
- Support for multi-organization planning by storing organization-specific item properties.
- Integration with Bills of Materials (BOM) and routings for manufacturing planning.
Key Columns and Attributes
The table contains over 100 columns, but the most significant ones include:
Column Name | Data Type | Description |
---|---|---|
PLAN_ID |
NUMBER | Foreign key to MSC_PLANS , linking items to specific plans. |
SR_INSTANCE_ID |
NUMBER | Source system instance identifier (e.g., Inventory instance). |
ORGANIZATION_ID |
NUMBER | References HR_ORGANIZATION_UNITS for org-specific data. |
INVENTORY_ITEM_ID |
NUMBER | Matches MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID . |
ITEM_NAME |
VARCHAR2(240) | Item description from the source system. |
PLANNING_MAKE_BUY_CODE |
NUMBER | Determines if an item is planned as Make (1) or Buy (2). |
FIXED_LEAD_TIME |
NUMBER | Lead time used in planning calculations. |
Technical Considerations
In EBS 12.1.1 and 12.2.2, the table's behavior is influenced by:
- Snapshot Process: Data is refreshed via concurrent programs like "Refresh Snapshot" (
MSCSCREP
). - Indexing: Key indexes include
MSC_SYSTEM_ITEMS_N1
(onPLAN_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID
) for query performance. - Partitioning: In large implementations, the table may be partitioned by
PLAN_ID
for scalability.
Integration Points
The table interacts with other MSC tables:
MSC_SUPPLIES
andMSC_DEMANDS
for supply-demand matching.MSC_ITEMS
for aggregated item attributes across organizations.MSC_PLAN_ORGANIZATIONS
for org-level planning parameters.
Customization and Extensions
Common extensions include:
- Adding custom columns via
MSC_EXTENSION_TABLE_NAME
tables. - Using Open Interfaces (
MSC_ITEM_OPEN_INTERFACE
) for bulk data loads. - Trigger-based validations during snapshot refreshes.
In summary, MSC_SYSTEM_ITEMS
is foundational to Oracle ASCP's item master management, enabling cross-module synchronization and complex planning scenarios. Proper maintenance of this table is essential for accurate supply chain planning in Oracle EBS 12.1.1/12.2.2 environments.
-
Table: MSC_SYSTEM_ITEMS
12.2.2
owner:MSC, object_type:TABLE, fnd_design_data:MSC.MSC_SYSTEM_ITEMS, object_name:MSC_SYSTEM_ITEMS, status:VALID, product: MSC - Advanced Supply Chain Planning , description: MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast , implementation_dba_data: MSC.MSC_SYSTEM_ITEMS ,
-
Table: MSC_SYSTEM_ITEMS
12.1.1
owner:MSC, object_type:TABLE, fnd_design_data:MSC.MSC_SYSTEM_ITEMS, object_name:MSC_SYSTEM_ITEMS, status:VALID, product: MSC - Advanced Supply Chain Planning , description: MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items planned by the planning process. Most of the columns in MSC_SYSTEM_ITEMS correspond to columns from the Oracle Inventory Item mast , implementation_dba_data: MSC.MSC_SYSTEM_ITEMS ,
-
Lookup Type: MSC_SYSTEM_ITEMS
12.2.2
product: MSC - Advanced Supply Chain Planning , meaning: For Items , description: Field Prompts used for Personal Queries ,
-
Lookup Type: MSC_SYSTEM_ITEMS
12.1.1
product: MSC - Advanced Supply Chain Planning , meaning: For Items , description: Field Prompts used for Personal Queries ,
-
APPS.MSC_X_CVMI_PLANNING dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSD_COMMON_UTILITIES_LB dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_WS_OTM_BPEL dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_ANALYSIS_SAFETY_STOCK dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_SUPPLIER_PKG dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_ITEM_PKG dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_WF_ALLOC_ATP dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_REL_WF dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_ATP_PF dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_ATP_PEG dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_PEG_UTIL dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_PQ_UTILS dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_SDA_PKG dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_DEMAND_PKG dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_ATP_REQ dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_SCE_LOADS_PKG dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_AATP_PVT dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_GET_NAME dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_WS_OTM_BPEL dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_IMPORT_UTIL dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_WF_ALLOC_ATP dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_RP_RELEASE_PUB dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSD_SRP_PROCESS_STREAM_DATA dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_REL_PLAN_PUB dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_WS_APS_DATA_SERVICES dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSD_SCE_RECEIVE_FORECAST_PKG dependencies on MSC_SYSTEM_ITEMS
12.2.2
-
APPS.MSC_POST_PRO dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_SUPPLIER_HORIZONTAL_PLAN dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSD_SALES_OPERATION_PLAN dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_ATP_SUBST dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_REL_PLAN_PUB dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_PEG_UTIL dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_GET_BIS_VALUES dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_BUDGET_DETAILS dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_DRP_HORI_PLAN dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSD_BOM_COLLECTIONS dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_GET_GANTT_DATA dependencies on MSC_SYSTEM_ITEMS
12.1.1
-
APPS.MSC_X_WFNOTIFY_PKG dependencies on MSC_SYSTEM_ITEMS
12.1.1