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 JANUARY 08, 2020
Applies to:PeopleSoft Enterprise SCM Inventory - Version 9.1 and later
Information in this document applies to any platform.
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:
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?
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