Error: The Quantity Entered Is Lower Than The Allowed Deviation For The Item.
(Doc ID 2732506.1)
Last updated on NOVEMBER 29, 2020
Applies to:Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version,
When calling API oe_order_pub.process_order to attach lot to a Sales Order following error occurs.
the following error occurs. In the calculation, it shows Primary UOM being passed in for the conversion instead of Ordered UOM
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
The quantity entered is lower than the allowed deviation for the item. Please re-enter.
The issue can be reproduced at will with the following steps:
1. Call Process order API to attach lot to the RMA line
The issue has the following business impact:
Due to this issue, users cannot use API to perform the action.
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