Oracle Apps Guide Logo

Error: "You have exceeded the transaction quantity"

A guide to resolving quantity precision errors in Oracle R12 Receiving.

Back to Learning Center

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

Apply Patch 5880504

To resolve this inconsistency, Oracle has provided a patch. Follow these steps carefully.

  1. 1Download and review the readme for Patch 5880504.
  2. 2Apply Patch 5880504 on a non-Production (test) instance first.
  3. 3Confirm the file versions are updated as listed below.
  4. 4Retest the issue to ensure it is resolved.
  5. 5If resolved, migrate the solution to other instances as appropriate.

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