Oracle eBS經驗分享

Units of Measure are defined once when setting up Oracle Applications

Each	Box	Dozen (一打)

Factors to consider when defining Units of Measure for your items:

• What is the lowest Unit of Measure that you stock, cost and plan?
• What conversions do you want to use for transaction purposes?
• Are you going to define a default UOM for the primary unit of measure for an item?
• What is the process to determine the primary UOM?
• Do you need to define interclass conversions?

Defining Units of Measure encompasses three distinct areas:

Standard Conversions

Conversions that occur within the same class, without regard to the item being transacted are known as Standard conversions. An example of a Standard conversion is one within length, the conversion centimeters into meters.

Intra-class Conversions

A conversion within the same class, that is specific to the item being converted is known as an Intra-class conversion. An example of an Intra-class conversion within the UOM Class of Quantity: The Base UOM for Quantity is Ea. There are two UOMs in the Quantity Class, Each and Case. The Standard conversion for Case to Each is 1 Case = 24 Each. Item A has a mapping of 1 Case = 19 Each. All other items transacted by Case will use the 1:24 ratio, but if Item A is transacted it will use the 1:19 ratio.

Inter-class conversions

Conversions that occur across classes between UOM are known as Inter-class conversions. Inter-class conversions are item specific. For example, an inter-class conversion would be pounds to gallons and requires the identification of which items will use this mapping.

 

 

(R) Inventory Super User

(N) Setup > Units of Measure > Units of Measure

====Table=====

SELECT *
  FROM MTL_UOM_CLASSES
WHERE UOM_CLASS = 'Amount';

SELECT *
  FROM MTL_UNITS_OF_MEASURE
WHERE UOM_CLASS = 'Amount';

SELECT *
  FROM MTL_UOM_CONVERSIONS
WHERE UOM_CLASS = 'Amount';