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.

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.