Reservation Shows Different Quantity And Secondary Qty Even Though Both Are The Same UOM
Last updated on MARCH 27, 2017
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Inventory Convergence
Autodetail is run in a batch to create a detailed reservation using Picking Rules.
The item is dual UOM controlled, and is used in the batch in its secondary UOM.
The reservation created shows the following:
Secondary Qty: 30.43139
Secondary UOM: LB
The reserved qty and secondary qty differ, even though they are both in LB.
Looking at the reservation data, the primary reserved quantity appears to be stored as 3.1872, rounded to four decimals, instead of 3.187196272026822. Rounding to five decimals gives 3.18720, and when 3.18720 is converted back to secondary, (3.18720 / 0.10473397572) = 30.4313855946879, which rounds to 30.43139.
If you enter the reservation manually instead, the Quantity and Secondary Qty match, both 30.43135 LB
UOM conversion between GL and LB is 1 LB = 0.10473397572 GL
This was not happening prior to applying some recent patches.
Expect both quantities to be the same.
The issue can be reproduced at will with the following steps:
1. Run Autodetail Line or Autodetail Batch on an OPM batch.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms