My Oracle Support Banner

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.

Symptoms

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
-----------------------
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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use API to perform the action.

Cause

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
Symptoms
Cause
Solution
References


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