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
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.
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?
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