Error: The Quantity Entered Is Lower Than The Allowed Deviation For The Item. (Doc ID 2732506.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Symptoms

When calling API oe_order_pub.process_order to attach lot to a Sales Order following error occurs

 ERROR
-----------------------
Error message: Error: The quantity entered is lower than the allowed deviation for the item. Please re-enter.ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.OE_VALIDATE_LOT_SERIAL", line 763
ORA-06510: PL/SQL: unhandled user-defined exception in Package OE_Order_PVT Procedure Lot_Serials

Example  Inventory log shows:
 INV_CONVERT.within_deviation: p_quantity : 24
 INV_CONVERT.within_deviation: p_uom_code1 : CA  --> Primary UOM
 INV_CONVERT.within_deviation: p_quantity2 : 288
 INV_CONVERT.within_deviation: p_uom_code2 : PR  ---> Secondary UOM
 INV_CONVERT.within_deviation: p_unit_of_measure1 :
 INV_CONVERT.within_deviation: p_unit_of_measure2 :
 INV_CONVERT.within_deviation: p_split_check :
 INV_CONVERT.within_deviation: l_converted_sec_qty : 3456
 INV_CONVERT.within_deviation: secondary_default_ind : D
 INV_CONVERT.within_deviation: dual_uom_deviation_high : 3%
 INV_CONVERT.within_deviation: dual_uom_deviation_low : 3%
 INV_CONVERT.within_deviation: Is 288 between 3352.32 and 3559.68?  ---> It should have compared if 3456  is between 3352.32 and 3559.68
OE_Validate_Lot_Serial.entity - tolerance error 1
LEAVING OE_MSG_PUB.ADD_TEXT
The quantity entered is lower than the allowed deviation for the item. Please re-enter.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call Process order API to attach lot to the RMA line

Changes

Cause

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