My Oracle Support Banner

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

Last updated on APRIL 04, 2025

Applies to:

Oracle Inventory Management - Version 11.5.10 to 11.5.10.CU2 [Release 11.5 to 11.5.10]
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

Symptoms

In Enter Receipts form for Lot controlled item and destination_type 'INVENTORY', when entering transaction quantity, the quantity is restricted to 6 decimal places then rounded to 5 decimal places in lot-entry form. The Lot Quantity will be greater than the transaction Quantity leading due to residual quantity issues and the error message:

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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.