OGG Replicat Abends With ORA-01407: cannot update to NULL for the ZD_EDITION_NAME and ZD_SYNC columns in EBS Environment (Doc ID 2504186.1)

Last updated on DECEMBER 17, 2019

Applies to:

Symptoms

                 Oracle GoldenGate Delivery for Oracle
    Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
   Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 03:29:37

Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Replicat abends with following error

2017-08-02 18:15:34  WARNING OGG-01154  SQL error 1407 mapping <schema name>.<table name> to <schema name>.<table name> OCI Error ORA-01407: cannot update ("GG"."<table name>"."<col name>") to NULL 

Trail shows NULL values for columns <col name> & <col name> part of Source EBS Tables 

Changes

Cause

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