My Oracle Support Banner

How To Resolve the Error "Arithmetic overflow error converting numeric to data type numeric" when Running the 'Complete Putaway' Cobol Process (INPPPTWY) for an InterUnit Transfer and a Standard Costed Item (Doc ID 1365892.1)

Last updated on APRIL 06, 2018

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.1 and later
Information in this document applies to any platform.

Goal

When receiving an InterUnit Transfer for a new Item which is Standard Costed, the 'Complete Putaway' Cobol process (INPPPTWY) (navigation: Inventory, Putaway Stock, Complete Putaway) fails with the below error:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting numeric to data type numeric. [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated. (SQLSTATE 01000) 3621
Stored Stmt : INPPPROC_U_BUCOST
SQL Statement : UPDATE PS_BU_ITEMS_INV SET AVERAGE_COST = :1, AVERAGE_COST_M
AT = :2, DT_TIMESTAMP = GETDATE() WHERE BUSINESS_UNIT = :3 A
ND INV_ITEM_ID = :4

How to resolve it?

Solution

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

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


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