GoldenGate Replicat CDR Does Not Work When Target Compared Value Is Null (Doc ID 1542759.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

I am using GoldenGate CDR at replicat with following parameter:

MAP abc.test_table, TARGET abc.test_table,
COMPARECOLS (ON UPDATE KEYINCLUDING (last_update),ON DELETE KEYINCLUDING (last_update)),
RESOLVECONFLICT (UPDATEROWEXISTS,(max_resolution_method, USEMAX (last_update)));

When target LAST_UPDATE is null, replicat does not process the record correctly.

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