Error "You have exceeded the transaction quantity". Precision Restriction for Quantity Field Up To 6 Decimal Places Performing Lot Receipts (Doc ID 464983.1)

15:44 0 Comments A+ a-


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

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