Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts
Last updated on AUGUST 21, 2016
Applies to:Oracle Inventory Management - Version 11.5.10 to 11.5.10.CU2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
FORM:RCVRCERC.FMB - Enter Receipts GUI
FORM:RCVTXERT.FMB - Enter Receiving Transactions GUI
FORM:RCVTXERE.FMB - Enter Returns GUI
FORM:RCVTXECO.FMB - Enter Corrections GUI
In Enter Receipts form for Lot controlled item and destination_type 'INVENTORY', when entering transaction quantity, the quantity is restricted to 6 decimal places then rounded to 5 decimal places in lot-entry form. The Lot Quantity will be greater than the transaction Quantity leading due to residual quantity issues and the error message:
"You have exceeded the transaction quantity"
Note: Internal error message may indicate this message: INV_QUANTITY_TOO_BIG
- Go to Receiving Screen
- Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005)
- Go to Lot/Serial form
- Enter lot number and qty as 7200.00001 (which was rounded to 5 digits)
- Message "you have exceeded the transaction quantity "
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms