OGG OCI Error ORA-01400: Cannot Insert NULL Into Column_Name Status = 1400

(Doc ID 1383763.1)

Last updated on JULY 20, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.1.1 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate (OGG) Replicat abended with OCI Error ORA-01400: cannot insert NULL into (<Column Name>) (status = 1400) error :

For Example :

OCI Error ORA-01400: cannot insert NULL into ("MYSCHEMA"."MYTABLE"."MYCOLUMN_DATE") (status = 1400), SQL <INSERT INTO "MYSCHEMA"."MYTABLE" ("MYCOL1","MYCOL2","MYCOL3","MYCOL4","MYCOL5","MYCOL6","MYCOLUMN_DATE",...>
Aborting transaction on ./dirdat/orap/CC beginning at seqno 107 rba 133157



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