My Oracle Support Banner

One Column not replicating to target. (Doc ID 2753758.1)

Last updated on FEBRUARY 24, 2021

Applies to:

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

Symptoms

Customer reported below error with replicat:

OCI Error ORA-01400: cannot insert NULL into ("<schema>"."<table>"."<ColumnName>") (status = 1400), SQL ....>
Aborting transaction on <trail_path>/<trail> beginning at seqno 3 rba 3110
  error at seqno 3 rba 3110
Problem replicating <schema>.<table> to <schema>.<target_table>
Mapping problem with insert record (target format)...

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.