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 JULY 26, 2023
Applies to:
PeopleSoft Enterprise SCM Inventory - Version 9.1 and laterInformation 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
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! |
In this Document
Goal |
Solution |
References |