Transaction in MMT with Error CSTPAVCP.calc_average_cost ORA-1426 Numeric Overflow
(Doc ID 415072.1)
Last updated on JANUARY 11, 2017
Applies to:Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.
On R12.x in Production:
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