Verify that Oracle logs the values of the primary keys and unique indexes.
By default, Oracle does not log primary keys and unique indexes. For successful replication of all table values, you must log these values.
SELECT SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI FROM V$DATABASE;
SUP SUP SUP --- --- --- YES YES YES
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;