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.

Symptoms

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

ORA-01400: cannot insert NULL during IP2016 Db Initialization


ERROR
-----------------------
ORA-01400
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")


STEPS
-----------------------
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.


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

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