Delivery of Goods Errors With 'geAttributes:java.sql.SQLException: Numeric Overflow' (Doc ID 1610642.1)

Last updated on MARCH 01, 2024

Applies to:

Symptoms

When attempting to deliver goods into inventory through the Receipt or Receiving Transactions form
the following error occurs:

ERROR
-----------------------

RVTII-060: Subroutine INV_TXN_MANAGER_PUB.process_Transactions() returned error
RVTVT-065: Subroutine afdname() returned an internal error
EX IN GETATTRIBUTES: JAVA.SQL.SQLEXCEPTION: NUMERIC OVERFLOW

Additionally, debugging shows:

INV_TRX_MGR: Setting Single Savepoint
INV_TRX_MGR:  Ex.. in geAttributes:java.sql.SQLException: Numeric Overflow
INV_TRX_MGR: Get Attributes. Rollbacking all changes: java.sql.SQLException: Numeric Overflow
INV_TRX_MGR:  error expl :null
INV_TRX_MGR: TrxUtil: stacked message - null
INV_TRX_MGR:  error msg :null
INV_TRX_MGR:  error msg2 :Unhandled Exception
INV_TRX_MGR:  Mssg peeked :Unhandled Exception
INV_TRX_MGR: ** Error .. :updated MMTT. ERR code :Transaction processor error,msg:Unhandled Exceptionrcnt=1
INV_TRX_MGR: PostUpd: wms_atsk_type=0
INV_TRX_MGR: **Ex: Ex in getAttributes:java.sql.SQLException: Numeric Overflow
INV_TRX_MGR: Ex.. in createTrx  ..:oracle.apps.inv.transaction.utilities.InvTrxException
INV_TRX_MGR: **ERROR in creating new Transaction

Cause

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