Error: "You have exceeded the transaction quantity"

When performing receiving transactions in Oracle E-Business Suite R12, particularly with lot-based items that require high precision quantities, users may encounter the error "You have exceeded the transaction quantity". This guide explains the symptoms, cause, and solution for this issue.

Symptoms

Affected Forms

This issue typically occurs in the following Oracle Forms:

• RCVRCERC.FMB - Enter Receipts GUI
• RCVTXERT.FMB - Enter Receiving Transactions GUI
• RCVTXERE.FMB - Enter Returns GUI
• RCVTXECO.FMB - Enter Corrections GUI

Steps to Reproduce

1. Go to the Receiving Screen.
2. Enter a quantity with high decimal precision, e.g., 7200.00000489 (which the system might round to 7200.000005 due to a 6-digit restriction).
3. Go to the Lot/Serial form.
4. Enter the lot number and a quantity that, after rounding to 5 decimal places (e.g., 7200.00001), is different from the receiving quantity.
5. The error message 'You have exceeded the transaction quantity' appears.

Cause

The root cause of this error is a discrepancy in how decimal precision for quantities is handled between different parts of the application.

• The receiving forms were enhanced to support quantity precision up to 6 decimal places.
• However, the core Inventory module's lot-entry form still only supported 5 decimal places.
• The system compares the transaction quantity from the receiving form and the lot quantity from the lot-entry form after rounding them both to 5 decimal places. If the initial quantity had more than 5 decimal places, this rounding could cause a mismatch, leading to the error.

Solution

strings -a $AU_TOP/resource/RCVRCERL.plx | grep 'Header:'

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