Reservation Shows Different Quantity And Secondary Qty Even Though Both Are The Same UOM

(Doc ID 2248467.1)

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.

Symptoms

On : 12.1.3 version, Inventory Convergence

ACTUAL BEHAVIOR
---------------
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:

Item: W1040
Quantity: 30.43135
UOM: LB
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.

EXPECTED BEHAVIOR
-----------------------
Expect both quantities to be the same.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Autodetail Line or Autodetail Batch on an OPM batch.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms