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 AUGUST 04, 2016

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

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 hundreds of Community platforms