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:

1. Go to Receiving Screen
2. Enter the qty like 7200.00000489 (6 digits restriction makes it 7200.000005)
3. Go to Lot/Serial form
4. Enter lot number and qty as 7200.00001 (which was rounded to 5 digits)
5. 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:

To implement the solution, please execute the following steps:

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.