Error "The Quantity Entered Is Lower Than The Allowed Deviation For The Item" with partial quantity Shipment line (Doc ID 1369219.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Symptoms

You can find situation where you are unable to invoice shipped order line, because the calculated conversion (dual uom) during system split does not respect the deviation rule (precision problem).

At first you have 1 line with 8000T and 4320 EA (second UOM), for which had just partially ship confirmed Qty1=3877.758T, the system split automatically the original line and recalculate a secondary quantity as Qty2 = 2093,9893MT.

The point is that your item is UOM dual with 0.54 as conversion rate and with deviation+ = 0 and deviation- = 0. So qty2 should have been Qty2 = 2093,98932MT.

The system split generated wrong qty as Qty2/Qty1 = 2093,9893/3877.758 = 0,539999995
So not exactly 0.54. and therefore the line fails in validation

Indeed When trying to fill some pricing information in Sales order line to get the final unit price, you can't do so because getting this error:

 

Summary of flow is :

Create and Book SO for qty=8000
Pick release for qty=8000
Transact the SO/move order (either via Auto pick and auto allocation during Pick release or via Transact move order)
Go to ship the SO line : in shipping enter/change the shipped qty as Primary UOM qty= 3877.758 .
The secondary quantity does get defaulted as:
Secondary qty = 2093.9893

So it is not per item setup, as it should be: 3877.758 x 0.54 meaning : Secondary qty = 2093.98932

The issue comes from here , because when back in the sales order line and trying to re-pricing (like trying to change a date field), they get the error:
"The quantity entered is lower than the allowed deviation for this item. please reenter"

Cause

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