Results for “msc_item_categories”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MSC_ITEM_CATEGORIES is a table in the MSC schema owned by Oracle Advanced Supply Chain Planning (ASCP). It stores the assignment of inventory items to categories within a category set, providing the planning engine with the categorical groupings it requires to filter, aggregate, and analyze supply and demand data. In Oracle EBS 12.1.1 and 12.2.2, this table represents a collection of data pulled from the transactional source (typically Oracle Inventory) into the MSC staging and planning schema, where it is consumed by the planning and data collection processes.
Because the table records associations between items, category sets, and categories, and is keyed primarily by business identifiers rather than system-generated surrogate keys, the metadata's heuristic Data Vault classification suggests a satellite-leaning structure. It acts as a descriptive satellite attached to the item, category set, and category hubs, capturing the dimensional assignment context at a point in time.
Key Information Stored
The table contains 38 documented columns. The most significant are listed below.
- ORGANIZATION_ID — Identifies the inventory organization to which the item-category association belongs; part of the composite primary key.
- SR_INSTANCE_ID — Identifies the source instance from which the data was collected, enabling multi-source planning; part of the composite primary key.
- INVENTORY_ITEM_ID — The item for which the category assignment is recorded; part of the composite primary key.
- CATEGORY_SET_ID — The category set (grouping of categories) within which the item is classified; foreign key to MSC_CATEGORY_SETS; part of the composite primary key.
- SR_CATEGORY_ID — The category within the set to which the item is assigned; part of the composite primary key.
- CATEGORY_NAME — Descriptive name of the category, supporting reporting without joins.
- DESCRIPTION — Additional descriptive text for the assignment.
- ENABLED_FLAG and DISABLE_DATE — Control whether the category assignment is active and when it was disabled.
- START_DATE_ACTIVE and END_DATE_ACTIVE — Define the effective date range for the assignment.
- SUMMARY_FLAG — Indicates whether the category is a summary category.
- REFRESH_NUMBER — Tracks the data collection refresh cycle associated with the record.
- LAST_UPDATE_DATE, CREATION_DATE, LAST_UPDATED_BY, CREATED_BY, REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Standard EBS audit and concurrent program context columns.
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns reserved for extensible customer data.
The primary key is MSC_ITEM_CATEGORIES_PK, defined over ORGANIZATION_ID, SR_INSTANCE_ID, INVENTORY_ITEM_ID, CATEGORY_SET_ID, and SR_CATEGORY_ID. A unique index, MSC_ITEM_CATEGORIES_U1, covers the same business-key columns, confirming that the composite of these five attributes is the meaningful business identifier rather than a synthetic surrogate.
Common Use Cases and Queries
Planners and developers use this table to resolve an item's category membership for planning, aggregation, and reporting. A typical query joins the table to MSC_CATEGORY_SETS to retrieve category set names, or filters by ORGANIZATION_ID and CATEGORY_SET_ID to return all items in a given category.
- Retrieving all categories assigned to a specific item: filter by INVENTORY_ITEM_ID and ORGANIZATION_ID.
- Aggregating planned items by category within a category set for demand and supply analysis.
- Determining which category set and categories feed the ASCP planning engine for a given source instance (SR_INSTANCE_ID).
- Auditing active versus disabled assignments using ENABLED_FLAG and DISABLE_DATE.
- Reconciling the MSC copy against the source Oracle Inventory category assignments.
A representative pattern selects ORGANIZATION_ID, INVENTORY_ITEM_ID, CATEGORY_SET_ID, and SR_CATEGORY_ID, joining to MSC_CATEGORY_SETS on CATEGORY_SET_ID to decouple stored identifiers from user-facing category set descriptions.
Related Objects
- MSC_CATEGORY_SETS — Referenced by the foreign key MSC_ITEM_CATEGORIES.CATEGORY_SET_ID, providing the definition of each category set.
- MSC_SYSTEM_ITEMS — The MSC item master at the same ORGANIZATION_ID/SR_INSTANCE_ID/INVENTORY_ITEM_ID grain, joined to enrich category assignments with item attributes.
- MSC_CATEGORIES — Source of category definitions that populate SR_CATEGORY_ID and CATEGORY_NAME.
- MTL_ITEM_CATEGORIES — The Oracle Inventory source table from which ASCP data collection populates this table.
- MTL_CATEGORIES_B and MTL_CATEGORY_SETS_B — Inventory-side base tables for categories and category sets used during collection.
- MSC_ITEM_CATEGORIES consumers such as planning and aggregation views in the MSC schema that rely on these assignments for grouping demand and supply.
-
This table stores the item assignment to categories within a category set.
-
This table stores the item assignment to categories within a category set.
-
View: GMP_PDR_CATEGORY_V 12.1.1
Unique list of categories from msc_item_categories in each organization for an instance.
APPS.GMP_PDR_CATEGORY_V·↳ MSC_ITEM_CATEGORIES·Explore GMP module →
-
View: GMP_PDR_CATEGORY_V 12.2.2
Unique list of categories from msc_item_categories in each organization for an instance.
APPS.GMP_PDR_CATEGORY_V·↳ MSC_ITEM_CATEGORIES·Explore GMP module →
-
View: MSC_CATEGORIES_TREE_V 12.1.1
This view shows all the categories in the tree
APPS.MSC_CATEGORIES_TREE_V·↳ MSC_ITEM_CATEGORIES·↳ MSC_PLANS·Explore MSC module →
-
View: MSC_ITEMS_TREE_V 12.1.1
APPS.MSC_ITEMS_TREE_V·↳ MSC_BOM_COMPONENTS·↳ MSC_ITEM_CATEGORIES·↳ MSC_SYSTEM_ITEMS·Explore MSC module →
-
View: MSC_CATEGORIES_TREE_V 12.2.2
This view shows all the categories in the tree
APPS.MSC_CATEGORIES_TREE_V·↳ MSC_ITEM_CATEGORIES·↳ MSC_PLANS·Explore MSC module →
-
View: MSC_ITEMS_TREE_V 12.2.2
APPS.MSC_ITEMS_TREE_V·↳ MSC_BOM_COMPONENTS·↳ MSC_ITEM_CATEGORIES·↳ MSC_SYSTEM_ITEMS·Explore MSC module →
-
PACKAGE: APPS.MSC_PQ_UTILS 12.1.1