Actual Cost Process Error Number: -127 ORA-01400: cannot insert NULL into ("GMF"."CM_CMPT_DTL"."COST_ANALYSIS_CODE") (Doc ID 2038007.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Actual Cost Process

When running actual costing, get:

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

This seems to be the same issue that was reported in bug 20616572 - ACP ORA-01400: CANNOT INSERT NULL (CM_CMPT_DTL.COST_ANALYSIS_CODE) and similar to bug 20549104 - UNEXPECTED ORA-01400: CANNOT INSERT NULL INTO GME_BATCH_STEP_RESOURCE

in which there was a problem with the 12.2 upgrade and editioning.

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

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