Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts (Doc ID 464983.1)
Error "You have exceeded the transaction quantity".
Applies to:
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
"You have exceeded the transaction quantity"
Symptoms:
"You have exceeded the transaction quantity"
Note: Internal error message may indicate this message:
INV_QUANTITY_TOO_BIG
Steps:
- 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 "
Cause Can Be-:
a) Restriction of precision support up to 6 decimal places were added for the quantity field
b) Comparing the transaction qty entered in receiving forms and the lot quantity entered in lot-entry form after rounding to 5 decimal precision.
Quantity Precision support from now on will be as follows:
Receiving supports unlimited precision in Receiving forms.
Core Inventory's lot entry block still supports only 5 decimal precision.
Important: The revised Quantity Precision support affects any quantities entered in all of the receiving forms (not just LOT based items).
Solution:
1. Download and review the readme for Patch 5880504
2. Apply Patch 5880504 on a non-Production instance
3. Confirm the following file version:
$AU_TOP/resource/RCVRCERL.plx 115.157.11510.45
$AU_TOP/resource/RCVTXECO.plx 115.67.11510.20
$AU_TOP/resource/RCVTXERT.plx 115.110.11510.22
$PO_TOp/forms/US/RCVTXERE.fmb 115.79.11510.9
You can use the commands like the following:
strings -a $AU_TOP/resource/RCVRCERL.plx | grep 'Header:'
4. Retest the issue
5. If the issue is resolved, migrate the solution as appropriate to other instances
References:
BUG:6000073 - RECEIVING, INVENTORY AND PO SHOULD ALL SUPPORT 15 DECIMAL PRECISION
BUG:7626008 - DECIMAL POSITIONS NOT CONSISTENT ON RCV FORMS; CANNOT RETURN SMALL QTY
BUG:5880504 - ONDEMAND: OUT TO 9-10 DECIMAL PLACES, RECEIVING TRANSACTIONS ROUNDING ONLY TO 5
Note- All Reference Taken from Oracle Forum and manipulate then to make better understandable for Oracle Apps Technical and Oracle Apps Functional Developer .
For More Information Visit on www.OracleAppsGuide.comOr Subscribe your email-id on OracleAppsGuide. For live issue discussion, Solution and Error in Oracle Apps R12 and in Oracle Apps 11I ;Please visit on Oracle Apps Guide.
