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:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |
References |