Search Results msc_uom_conversions_u1

Overview

MSC.MSC_UOM_CONVERSIONS is an Advanced Supply Chain Planning (ASCP) schema table that stores item-specific unit-of-measure conversion factors between a non-base unit of measure and the base unit of measure for a given item. In Oracle EBS 12.1.1 and 12.2.2, it functions as the planning-side cache of conversion rates that the MSC engine uses to normalize demand, supply, and on-hand quantities into a consistent planning unit of measure for an inventory item. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10 and is owned by the MSC schema.

From a dimensional modeling perspective, the metadata's heuristic classification suggests this object behaves as a satellite. Its natural business grain is the item/conversion-unit combination, and the bulk of its non-key attributes (conversion rate, disable date, class, descriptive flexfield segments, Who columns) are descriptive, non-identifying attributes that change over time. The key columns themselves derive from other entities—the inventory item and the unit of measure—rather than being generated internally, which is consistent with a satellite attached to those parent hubs.

Key Information Stored

The table's primary key is MSC_UOM_CONVERSIONS_PK (INVENTORY_ITEM_ID, UNIT_OF_MEASURE). The two documented unique indexes serve as business-key candidates: MSC_UOM_CONVERSIONS_U1 (INVENTORY_ITEM_ID, UNIT_OF_MEASURE) and MSC_UOM_CONVERSIONS_U2 (INVENTORY_ITEM_ID, UOM_CODE). The most important columns are:

• INVENTORY_ITEM_ID — the inventory item the conversion applies to.
• UNIT_OF_MEASURE — the primary (source) unit of measure long name.
• UOM_CODE — destination unit-of-measure short name.
• UOM_CLASS — destination conversion class.
• CONVERSION_RATE — numeric rate from the conversion unit to the base unit of the class.
• DISABLE_DATE — date the conversion is no longer valid for transactions.
• DEFAULT_CONVERSION_FLAGS — indicates whether the factor is item-specific or the standard conversion factor.
• SR_INSTANCE_ID — source application instance identifier for multi-instance planning.
• REFRESH_NUMBER — refresh/build identifier from the planning collection.
• Standard Who and Concurrent Who columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID, etc.).
• Descriptive flexfield columns ATTRIBUTE_CATEGORY and ATTRIBUTE1..ATTRIBUTE15.

Common Use Cases and Queries

Analysts and developers query this table to validate that an item's planning conversions are correctly populated, to troubleshoot quantity discrepancies between units in ASCP plans, or to report which conversions have expired. A representative query retrieving active conversions for an item is:

SELECT inventory_item_id, unit_of_measure, uom_code,
       conversion_rate, default_conversion_flags
  FROM msc.msc_uom_conversions
 WHERE disable_date IS NULL
   AND inventory_item_id = :p_item_id;

Auditing stale or superseded conversion rows is another frequent task:

SELECT inventory_item_id, unit_of_measure, uom_code, disable_date
  FROM msc.msc_uom_conversions
 WHERE disable_date < SYSDATE;

Reporting scenarios typically join to item masters or unit-of-measure definitions to produce human-readable item descriptions and class names, and the REFRESH_NUMBER column is used to isolate the most recent planning collection cycle.

Related Objects

The most significant related objects include:

• MSC.MSC_UNITS_OF_MEASURE — referenced by the foreign key on UNIT_OF_MEASURE; supplies unit-of-measure definitions joined on UNIT_OF_MEASURE.
• INV.MTL_SYSTEM_ITEMS_B — the inventory item master, joined on INVENTORY_ITEM_ID to obtain item names and descriptions.
• INV.MTL_UOM_CLASS_CONVERSIONS — the source of standard class-level conversion factors reflected here.
• MSC.MSC_SYSTEM_ITEMS — the planning item table joined on INVENTORY_ITEM_ID.
• MSC.MSC_ITEM_ATTRIBUTES — related item attribute store sharing the INVENTORY_ITEM_ID key.
• FND.CONCURRENT_PROGRAMS / FND.CONCURRENT_REQUESTS — Concurrent Who columns (PROGRAM_ID, REQUEST_ID) link rows back to the collection program that populated them.