What is uom in oracle

A UOM intraclass conversion specifies the conversion between a unit of measure, the From UOM , and the base unit of measure of the same class. For example, suppose you're considering converting cases of water into a base unit of each bottle of water.

The unit of measure class is Quantity. The base unit of measure is each EA. Previous Next JavaScript must be enabled to correctly display this content. Units of Measure Classes Units of measure classes represent groups of units of measure with similar characteristics such as area, weight, or volume.

Units of Measure Units of measure are used by a variety of functions and transactions to express the quantity of items. Base Units of Measure Each unit of measure class has a base unit of measure. Scenario This table lists examples of unit of measure classes, the units of measure in each unit of measure class, and base unit of measure. Standard Conversions for Units of Measure A unit of measure standard conversion specifies the conversion factor by which the unit of measure is equivalent to the base unit of measure.

Scenario This table lists examples of unit of measure classes, one unit of measure included in each class, the base unit of measure for the unit of measure class, and the conversion factor defined for the unit of measure. What's a UOM interclass conversion? What's a UOM intraclass conversion? Dozen Box each. Pound Kilogram Gram. Each unit of measure you define must belong to a unit of measure class. Each unit of measure class has a base unit of measure.

The base unit of measure is used to perform conversions between units of measure in the class. The base unit of measure should be representative of the other units of measure in the class, and must be the smallest unit.

For example, you could use cubic inches as the base unit of measure for a unit of measure class called volume. A unit of measure class is a grouping of different UOMs. For example, the unit of measure class quantity might have several associated units of measure such as, dozen, gross, or each. Each unit of measure class must have a base unit of measure.

This table lists examples of unit of measure classes, the units of measure in each unit of measure class, and base unit of measure. Note that the base unit of measure is the smallest unit of measure in its unit of measure class. A unit of measure standard conversion specifies the conversion factor by which the unit of measure is equivalent to the base unit of measure.

This table lists examples of unit of measure classes, one unit of measure included in each class, the base unit of measure for the unit of measure class, and the conversion factor defined for the unit of measure. In the first example, you're converting a unit of measure called dozen into a base unit of measure called each.

The conversion factor tells the application that for each dozen, there are 12 of the base unit each. For example, if you had 48 each of eggs, with a conversion factor of 12, you would get 4 dozen eggs.

A packaging string shows the hierarchy of units that represent how an item is packaged when shipped or used by an enterprise. It represents the UOMs involved with transactions for an item. It is possible for one or more items to share the same packaging string. Packaging strings are defined and edited using the Product Information Management work area and either the Create Item or Manage Items tasks. To define packaging strings, you select units to use in the string, define the multipliers between the packaging elements, and optionally, name the derived units that will support the packaging string when converting the item quantities in transactions.

Selected units must be ordered in the appropriate sequence in the shuttle control before the next step of specifying the multipliers. A packaging string can have no more than 10 elements. The only units displayed are the units of the same UOM class.

Multipliers show how many of the smaller packaging unit are in the current row for the next unit in the string. The standard conversion values, and item specific overrides, are used to show the default quantity of each row. The multiplier is calculated for you but you can modify, if needed. If you make any changes to any multiplier, you must click the Recalculate button before you can save your changes.

Using our example above, since your item has 10 Each in a Box, you would set the multiplier to a value of 10 Each equals a Box. Continue entering multipliers for each row in your string.

A packaging string may require a new derived unit to represent the base unit conversion to the units involved in a packaging string. Derived units are how we override a unit of measure to be used in a packaging string, without modeling it as an item specific intraclass conversion.

The derived units are given a generated short code and name, but are not intended to be seen by users in the transactional flows. Add Packaging Strings to Items. You can use dual units of measure to transact items in two unrelated units of measures.

After setting up an item to use dual UOMs, you must also set up interclass conversions for the item that relates the units in both classes for use in transactions. From the Product Information work area, select the Create Item task. Define your primary UOM. This is the stocking and selling unit of measure. Any necessary conversions are based on this unit of measure. Select a value for the Tracking Unit of Measure field. This attribute controls how on-hand balances are tracked.

Primary : The application tracks the on-hand balances by the primary unit of measure. Primary and secondary : The application tracks the on-hand balances by both the primary and secondary units of measure dual UOMs. Select a value for the Pricing field to indicate if pricing is based on the primary or secondary unit of measure. If you set the value to Secondary , the application reprices the order lines at ship confirmation. Define your secondary UOM. If the item is dual unit of measure controlled you selected Primary and secondary in the Tracking Unit of Measure field , or priced in a secondary unit of measure, you can specify a secondary unit of measure.

Default : Select if you want the application to automatically default the converted UOM value. Both : Uses both item-specific and standard unit of measure conversions.

If both exist for the same unit of measure and item combination, the item-specific conversion is used. Whenever you enter an item's quantity, the default is the primary unit of measure for the item. Transactions are performed in the unit of measure you specify. The conversion happens automatically and item quantities are updated in the primary unit of measure of the item. Important: Inventory transactions and on hand balance supports decimal precision to 5 digits after the decimal point.

Oracle Work in Process supports decimal precision to 6 digits. Other Oracle Applications support different decimal precision. As a result of the decimal precision mismatch, transactions another Oracle Application passes may be rounded when processed by Inventory.

If the transaction quantity is rounded to zero, Inventory does not process the transaction. It is therefore suggested that the base unit of measure for an item is set up such that transaction quantities in the base unit of measure not require greater than 5 digits of decimal precision. Enter the conversion factor by which the unit of measure is equivalent to the base unit of measure established for this class. For example, if one DZ this unit of measure is equivalent to 12 EA base unit , the conversion factor is Or, if EA is equal to one-twelfth of a DZ, the conversion factor is 0.

To define a conversion for a specific item within a unit of measure class Intra-class. For example, if one LB this unit of measure is equivalent to 16 OZ base unit , the conversion factor is To define a conversion for a specific item between unit of measure classes Inter-class. Select the destination base unit of measure of the class to which you are converting a unit of measure. Enter the conversion factor by which the source base unit is equivalent to the destination base unit.

For example, if one ML source base unit is equivalent to one GR destination base unit , the conversion factor is one. To make a unit of measure conversion inactive.

Lot specific conversions enable you to perform a specific inter-class conversion for a given lot that provides more granular control over the transactional quantities for a lot. For example, the standard inter-class conversion for a lot controlled item is 1 gallon equals 15 pounds; however, when you receive a particular lot of the item, 1 gallon equals 16 pounds.

You can create a lot specific unit of measure for this instance. You can create lot-specific unit of measure conversions for on-hand lots or lots with a zero balance.

If you create a lot-specific conversion for a lot with on-hand quantities, you can automatically update the quantities in the system to more accurately reflect the on-hand quantity. You can also view the history of changes made to the lot unit of measure conversion, and the corresponding quantity changes. Note: Lot-specific conversions are available only for items that are set up for dual unit of measure control.

When the lot context is not present in high level reservations, or a lot is not specified for the main transaction, then the system validates secondary quantities during lot conversion transactions. An error may occur if the item deviation settings are insufficient to accommodate the lot-specific conversion quantities. If you increase the deviation factor settings, then no error occurs.

Select the destination base unit of measure of the class to which you are converting the unit of measure. For example, if 16 pounds source base unit is equivalent to 1 Gallon destination base unit , the conversion factor is Optionally, enter an inactive date for the conversion.

This is the date when the unit of measure conversion for the lot reverts back to the standard inter-class conversion. Optionally, enter a transaction reason for the conversion. See Defining Transaction Reasons for more information. Update On-Hand Balances: This enables you to enter a new primary or secondary on-hand balance.

The system automatically recalculates the other on-hand balance as well as the transaction quantities based on the conversion factor. Recalculate Batch Primary Quantity: The system automatically recalculates the new primary on-hand quantity and process-batch quantity based on the conversion factor. The secondary quantity remains the same.

The system automatically updates additional on-hand quantities that the batch transaction did not create. If the lot was yielded only by the batch, then the system does not update the transaction quantities. Recalculate Batch Secondary Quantity: The system automatically recalculates the new secondary on-hand quantity and process-batch quantity based on the conversion factor.

The primary quantity remains the same. Recalculate On-Hand Primary Quantity: The system automatically recalculates the primary quantity based on the conversion factor. The secondary quantity remains the same, and the system updates the transaction quantities.