ORA-01400: Cannot Insert NULL During IP2016 Db Initialization

(Doc ID 2347012.1)

Last updated on JANUARY 09, 2018

Applies to:

Siebel CRM - Version 16.18 [IP2016] and later
Information in this document applies to any platform.


On : 16.18 [IP2016] version, Remote / Replication / Anywhere

ORA-01400: cannot insert NULL during IP2016 Db Initialization

DBCLog DBCLogError 1 000000045a2687fc:0 2017-12-05 14:28:59 SQL Warning, SQL State 23000, 1400, [tp][ODBC Oracle driver][Oracle]ORA-01400: cannot insert NULL into ("SIEBEL"."S_PARTY"."ROOT_PARTY_FLG")

Customer upgraded IP2013 environment to IP2016 and completed the Db-extract jobs in server. When starting the initialization process it fails at step 6 when it tries to load User data.

The issue has the following business impact:
Due to this issue, users cannot initialize local database


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