Search Results msc_units_of_measure




Overview
Explore in AI Chat

Overview

MSC_UNITS_OF_MEASURE is a table in the MSC schema owned by the Advanced Supply Chain Planning (ASCP) product within Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the planning-side repository of unit of measure definitions: each row represents a discrete unit of measure—together with its classification, base-UOM designation, and descriptive attributes—that Advanced Supply Chain Planning uses when interpreting quantities across demand, supply, inventory, and sourcing data. The table is a fundamental reference (lookup) object within the ASCP data model, providing the vocabulary of measurement against which planned quantities are normalized.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is hub-leaning. MSC_UNITS_OF_MEASURE behaves as a hub: it holds a durable, uniquely identified business concept (the unit of measure) that is referenced by dependent tables rather than merging multiple source keys. Downstream conversion logic is captured in separate link- and satellite-style structures such as MSC_UOM_CONVERSIONS and MSC_UOM_CLASS_CONVERSIONS.

Key Information Stored

The documented physical schema for 12.2.2 lists 33 columns. The most significant include:

Common Use Cases and Queries

Typical uses include validating that a planned quantity carries a valid UOM code, joining planning facts to their descriptive unit names, identifying the base unit for a class before applying conversions, and filtering active (non-disabled) units for reporting.

  • Look up a unit by its business key: SELECT unit_of_measure, uom_code, uom_class, base_uom_flag, description FROM msc.msc_units_of_measure WHERE uom_code = :code;
  • List active units within a class: SELECT uom_code, description FROM msc.msc_units_of_measure WHERE uom_class = :class AND (disable_date IS NULL OR disable_date > SYSDATE);
  • Locate the base unit per class: SELECT uom_class, uom_code FROM msc.msc_units_of_measure WHERE base_uom_flag = 'Y';
  • Join to conversion data to resolve quantity ratios via MSC_UOM_CONVERSIONS.UNIT_OF_MEASURE.
  • Scope all of the above by REFRESH_NUMBER or SR_INSTANCE_ID when analyzing a specific planning run or source instance.

Related Objects

MSC_UNITS_OF_MEASURE is referenced by several dependent ASCP tables through the UNIT_OF_MEASURE key:

  • MSC_UOM_CONVERSIONS — references MSC_UNITS_OF_MEASURE.UNIT_OF_MEASURE; supplies the direct conversion factors between unit pairs.
  • MSC_UOM_CLASS_CONVERSIONS — references the table twice, through FROM_UNIT_OF_MEASURE and TO_UNIT_OF_MEASURE; defines class-level conversion relationships.
  • Planning fact and supply/demand tables throughout the MSC schema that carry a unit of measure reference for quantity interpretation.
  • Standard concurrent collection programs that populate the table from Oracle Inventory UOM definitions during the planning data refresh.

These relationships confirm the table's role as the central reference point for measurement semantics across the Advanced Supply Chain Planning data model.