Transaction in MMT with Error CSTPAVCP.calc_average_cost ORA-1426 Numeric Overflow
(Doc ID 415072.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle Cost Management - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
CMCACW
Symptoms
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
COSTED_FLAG=E
ERROR_CODE=No Error
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
STEPS
1. /INV/Transactions / Material Transactions
for org=VPM
TAB Reason_Reference :
Costed=Error
error_code=No Error
error_explanation=CSTPAVCP.calc_average_cost (30): ORA-1426: numeric overflow
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |