Actual Cost Program Gives sy_etrap - FATAL_ERROR ****%N%NFunction: gmfaget_prod_batch%N%NStatement: fetch%N%NError: ORA-01455: converting column overflows integer datatype (Doc ID 2204463.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 Application Release 12.1.3:

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

ERROR
-----------------------
  **** sy_etrap - FATAL_ERROR ****%N%NFunction: gmfaget_prod_batch%N%NStatement: fetch%N%NError: ORA-01455: converting column overflows integer datatype

  Time: Wed Apr 6 08:40:32 2016

 Error number: -127

Error message: ORA-01455: converting column overflows integer datatype

  Function: gmfaget_prod_batch

  Statement: fetch

This appears to be a result of the customer extending the 'GMF_LAYER_ID_S' sequence. They had started getting an error when trying to transact in a batch:
"SQL ORA 08004: a sequência é GMF_LAYER_ID_S.NEXTVAL exceeds MAXVALUE e não pode ter instância."

In order to solve that problem, they extended the sequence. They now have:

select MAX_VALUE from dba_sequences where sequence_name = 'GMF_LAYER_ID_S'

MAX_VALUE
----------
9147483648

It appears the code cannot handle numbers this high.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run OPM Atual Cost process

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot calculate item costs.

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