My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.