Missing changes when using Integrated Replicat, with Parallel Replicat all data is replicated. (Doc ID 2934504.1)

Last updated on MAY 17, 2023

Applies to:

Symptoms

With Integrated Replicat all the data is not being replicated.   Source data does not match target data after data has been replicated.

Using Parallel Replicate the data is replicated correctly

Source :

SQL>select ADDRESS_ID,VERSION from <SCHEMA>.<SOURCE_TABLE> where ADDRESS_ID in ('#########8','#########2');

ADDRESS_ID         VERSION
----------------          ----------
#########8     4
#########2     4

Target Integrated Replicate ( Version Was Not UPDATED)

SQL> select ADDRESS_ID,VERSION from <SCHEMA>.<TARGET_TABLE> where ADDRESS_ID in ('#########8','#########2');

ADDRESS_ID         VERSION
----------------         ----------
#########8     3
#########2     3

Target Parallel Replicate (No Issues) :

SQL> select ADDRESS_ID,VERSION from<SCHEMA>.<TARGET_TABLE> where ADDRESS_ID in ('#########8','#########2');

ADDRESS_ID         VERSION
----------------         ----------
#########8     4
#########2     4

Cause

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