Actual Costing Gives Error "sy_etrap - FATAL_ERROR ORA-01426: Numeric Overflow" (Doc ID 2112604.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Actual Cost Process

When attempting to run OPM Actual Cost Program, the following error occurs:

**** sy_etrap - FATAL_ERROR ****%N%NFunction: gmfaput_insert_layer_costs%N%NStatement: insert%N%NError: ORA-01426: numeric overflow

Log file shows the following:

CM$AC_EXCLUDE_NEG_INV_BAL is 0
CM$MAX_ITERATION_LIMIT is 200
CM$COSTING_TOLRNC_LEVEL is 1
Reached maximum allowed iterations 200
cost calculation of products in circular refrence terminated26-FEB-2016 05:34:07
200 iterations performed for batches with circular reference26-FEB-2016 05:34:07
  Unconverged Costed Item no's follow ...26-FEB-2016 05:34:07
  Item# id whse Final Cost Prior Cost 26-FEB-2016 05:34:07
  BAR1001605 161715 MON 195.788235137 194.61233855926-FEB-2016 05:34:07
  BAR1001605 161715 OPS 197.916445771 196.73005257826-FEB-2016 05:34:07
  BAR1006714 483263 MON 183.47053728 182.71812312526-FEB-2016 05:34:07
  BAR1006714 483263 OPS 184.222337387 183.4705372826-FEB-2016 05:34:07
  BLT1002502 507251 OPS -0. -0.26-FEB-2016 05:34:07
  BAR1006953 511245 RBG 244.7806165 242.75383794726-FEB-2016 05:34:07
  BAR1006953 511245 OPS 246.820626248 244.780616526-FEB-2016 05:34:07
  End of Unconverged Costed Item no's26-FEB-2016 05:34:07

Customer normally has many batches with circular references but does not normally get this kind of error.

ERROR
-----------------------
**** sy_etrap - FATAL_ERROR ****%N%NFunction: gmfaput_insert_layer_costs%N%NStatement: insert%N%NError: ORA-01426: numeric overflow

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. run OPM Actual Cost Program
2. check the log file

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot determine the cost for all items.

Cause

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