Transaction in MMT with Error CSTPAVCP.calc_average_cost ORA-1426 Numeric Overflow
(Doc ID 415072.1)
Last updated on FEBRUARY 22, 2019
Applies to:Oracle Cost Management - Version 12.1.3 to 12.2.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Within an organization that is using average costing method, one transaction is stuck with an error in mtl_material_transactions (MMT) with the ERROR below. This same error MSG is showing in the log of the Actual Cost Worker (CMCACW), such as :
ERROR_EXPLANATION= CSTPAVCP.calc_average_cost (30): ORA-01426: numeric overflow
Logfile of CMCACW shows:
CSTPAVCP.calc_average_cost (30): ORA-01426: numeric overflow
Failing Transaction ID is xxxxx
The issue can be reproduced at will with the following steps:
1. /INV/Transactions / Material Transactions
TAB Reason_Reference :
error_explanation=CSTPAVCP.calc_average_cost (30): ORA-1426: numeric overflow
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