Error Adding Value To "Idcprofile" Information Field In Content Server (Doc ID 1438410.1)

Last updated on MAY 19, 2017

Applies to:

Oracle WebCenter Content - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms


Error when adding a value to the IdcProfile

/12 1:00 PM Event generated by user 'user' at host 'host:16200'. Unable to execute service EDIT_SCHEMA_VIEW_VALUES and function editSchemaViewValues.
Unable to execute SQL statement 'INSERT INTO ProfileTriggerValues (dProfileTriggerValue, dProfileTriggerOrder) values ('ABC_78_CET_Commitment_Trigger', null)'. ORA-01400: cannot insert NULL into ("UCM_OCS"."PROFILETRIGGERVALUES"."DPROFILETRIGGERORDER")
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("IDE_OCS"."PROFILETRIGGERVALUES"."DPROFILETRIGGERORDER"). [ Details ]

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