Cost Roll Up Error ORA-01400: Cannot Insert NULL Into ("GMF"."CM_CMPT_DTL"."COST_ANALYSIS_CODE") along with signal 6 shown in the log file (Doc ID 2023381.1)

Last updated on NOVEMBER 03, 2016

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, Cost Rollup Process

Running the roll up in OPM Financials and see the error

Entered: gmfsput_cmpt_dtl_insert_all. n=1086.06-MAY-2015 13:52:49

  **** sy_etrap - FATAL_ERROR ****%N%NFunction: gmfsput_cmpt_dtl_insert_all%N%NStatement: insert_all%N%NError: ORA-01400: cannot insert NULL into ("GMF"."CM_CMPT_DTL"."COST_ANALYSIS_CODE")


  Time: Wed May 6 13:52:49 2015


  Error number: -127

 Error message: ORA-01400: cannot insert NULL into ("GMF"."CM_CMPT_DTL"."COST_ANALYSIS_CODE")

Program was terminated by signal 6


  Function: gmfsput_cmpt_dtl_insert_all

  Statement: insert_all


ERROR
-----------------------
ORA-01400: cannot insert NULL into ("GMF"."CM_CMPT_DTL"."COST_ANALYSIS_CODE")
and

Program was terminated by signal 6



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Cost Rollup.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Cost Rollup

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