Now you can Subscribe using RSS

Submit your Email

Sunday, 21 June 2015

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

KULDEEP CHAUHAN

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.

KULDEEP CHAUHAN / Author & Editor

"A Guide for Oracle E-business Suit" . For any Query and help Please drop your mail on - Oracleappsguide.com@gmail.com . Thanks a lot for your visit on OracleAppsGuide.com .Please Subscribe and Comment our website feed and Youtube channel.

0 comments:

Post a comment

OracleAppsGuide.com © Coprights 2016,