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 :


The issue can be reproduced at will with the following steps:
1. /INV/Transactions / Material Transactions
for org=VPM
TAB Reason_Reference :
error_code=No Error
error_explanation=CSTPAVCP.calc_average_cost (30): ORA-1426: numeric overflow


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