My Oracle Support Banner

Reservation Shows Different Quantity And Secondary Qty Even Though Both Are The Same UOM (Doc ID 2248467.1)

Last updated on OCTOBER 08, 2021

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:

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.