CSTPACIR:10ORA-01400: cannot insert NULL into ("WIP"."WIP_REQ_OPERATION_COST_DETAILS"."OPERATION_SEQ_NUM") (Doc ID 1094661.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Enterprise Asset Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance 27-Oct-2013***

Symptoms

When an operation sequence number in a workorder is 0, the records get stuck for costing in the MMT Table with the following error:
CSTPACIR:10ORA-01400: cannot insert NULL into ("WIP"."WIP_REQ_OPERATION_COST_DETAILS"."OPERATION_SEQ_NUM")

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