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.


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

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

Program was terminated by signal 6

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


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