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)
- The message "you have exceeded the transaction quantity "
Cause Can Be-:
a) Restriction of precision support up to 6 decimal places was 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 - ON-DEMAND: OUT TO 9-10 DECIMAL PLACES, RECEIVING TRANSACTIONS ROUNDING ONLY TO 5
Note- All Reference Taken from Oracle Forum and manipulate than to make better understandable for Oracle Apps Technical and Oracle Apps Functional Developer.
“A GUIDE FOR ORACLE E-BUSINESS SUITE” – A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on www.OracleAppsGuide.com Or Subscribe your email-id on OracleAppsGuide.
0 comments:
Post a Comment
Note: only a member of this blog may post a comment.