Oracle Inventory Unit Of Measure

UOM Tables Relationship

Units Of Measure Form

Form:INVSDUOM.fmb

Table:MTL_UNITS_OF_MEASURE

MTL_UNITS_OF_MEASUREisthedefinitiontableforboththe25-character andthe3-characterunitsofmeasure.
Thebase_uom_flagindicatesiftheunitofmeasureistheprimaryunit ofmeasurefortheuom_class.
OracleInventoryusesthistablekeeptrackoftheunitsofmeasure thancanbeusedtotransactanitem.Thistableisalsousedby OraclePurchasing,andOracleOrderEntry/Shipping.

Unit Of Measure Classes

Form:INVSDOCL.fmb
Table:MTL_UOM_CLASSES
MTL_UOM_CLASSESisthedefinitionoftheunitofmeasureclasses.A classisacategorytowhichunitsofmeasureareassigned.
OracleInventorydefinesthistable,anditisusedbyOracle PurchasingandOracleOrderEntry/Shipping.

Unit Of Measure Conversions

Form:INVSDOUC.fmb
Table1:MTL_UOM_CONVERSIONS
MTL_UOM_CONVERSIONSstoresconversionratesbetweennon-baseunitsof measureandtheirbaseunit.Thenon-baseunitsofmeasureare storedinthetable.
Thedefault_conversion_flagindicatesthattheconversionbeing definedis
1)associatedwithaspecificitemand
2)theconversion betweenunitsofmeasurehasalreadybeendefinedasastandard conversionwiththesameconversionrate.

Table2:MTL_UOM_CLASS_CONVERSIONS
MTL_UOM_CLASS_CONVERSIONSiswhereconversionsbetweenbaseunitsof measurearedefinedforanitem.Abaseunitofmeasureistheprimary unitforaclass.

Intra-Class VS Inter-Class

Under Intra-class And Standard Tab,User can only define conversation within same class;
Under Inter-class tab, you can define conversation between different base uom which in different UOM class;