Bookmark and Share Subscribe You may face visibility problem if is blocked on your network

Wednesday, August 24, 2011

Dual UoM in Oracle R12

Lets take a case Food industry:

FG Foods Ltd. sell variety of Chicken which can have different weight. The superior quality of a chicken weighs to 4 Pound (on an average) but the deviation can be ±10%. This chicken is purchased on number basis and later it is sold on Number (Each) basis as well as on weight (Pound-Lbs) basis. So here Chicken is getting transacted based on two UOM and FG Foods want to track Qty on both UoM basis.
To satisfy this requirement we need to define an item which can be tracked on two UoM, define converser rate between these UoMs.

Item Definition:

UoM Conversion:
Also define Inter-class conversion that too item specific.
1 Unit = 4 Pound

Lets look at the transaction below, 100 Lbs comes to 25 chickens (as per tolerance), but if it goes beyond the tolerance then Oracle will not accept it.

In this case, based on tolerance defined it will accept values for secondary UoM ±2.5 (10% of 25).
So in below transactions one line is on –ve tolerance and other is on +ve tolerance.

On-hand and Availability:

Miscellaneous Issue:
Lets try doing issue transaction based on only Secondary UoM (Each). Oracle will automatically calculate quantity in other UoM based on the conversion rate.

On-hand Qty:
In above transaction, even though we did not give value in Lbs, Oracle deducted one chicken and 4 Pounds (refer the conversion).
51-1   = 50 Each
200-4 = 196 Lbs

Price List View:
Oracle accepts different price values for different UoM as shown below, and you can sell the product on any UoM.

Sales Order Lines 68097 :
Lets sell this product based on different UoM..
Oracle will pull the price based on UoM you mentioned on the Order line, also it asks to feed the secondary qty as well. But remember the final transaction will happen based on UoM added on Order line and then other qty will be calculated.

Now Process the Order: Book > Pick Release > Pick Confirm > Ship Confirm.

Observe the above shipping transactions,
Line 1.1: even though its showing Secondary Req Qty as 12 actual Secondary Shipped Qty is 11.5 (as per the conversion), as 46Lbs of chicken comes to 11.5 (46/4)
Line 1.2: Here we did not give qty in Lbs, so oracle calculated it based on conversion and populated.
At the end of this transaction the final On-Hand shall as below:
50 - (11.5+12) =  26.5
196 - (46+48)  = 102


  1. thank you so much it helped me a lot

  2. HI.. The Generated invoice for the sales order is only having the primary UOM and secondary UOM details are not present..

    Is there any option that we can see the secondary UOM details on invoice. Please advise

  3. i Created a new item in V1 and assigned to M1.
    Item name :Egg
    primary units of measure is Each.
    Secondary units of measure is dozen.
    I created miscellaneous Transaction in M1 org.
    when I select the item in miscellaneous receipt and I have given the quantity has 1200 (each) in secondary units of measure it is automatically displaying 100 Dz.
    i assign the item to corporate price list and assign price as 5Rs each.
    when iam creating sales order secondary units of measure column is not displaying .How to add the secondary units of column to sales order of order management responsibility.

  4. Hi Sudheer,
    Create price list line for secondary unit of major as well

  5. Not able to enter Dual UOM comoonent to the Bill of Material. This is not completely developed functionality for Discrete.

  6. is there a way to complete assembly in dualuom


Please add your valuable feedback / comments


This blog is purely personal and the thoughts expressed here represent only me. The purpose of this blog is to share information and knowledge about Oracle's product which I have come across with my exposure to the product, practice and observations. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. The blog has been created solely as a educational, for storing portions of the vast Oracle knowledge world. Oracle EBS is an Oracle Corp. product and you should contact Oracle directly for any specific fact or issue.

*NOTE: Few articles on this blog are not completely prepared by me, content is edited and complied after referring various sites to make visitor's job easy