Extract Not Capturing The Trigger Insert Fired As A Result Of Replicat Applying Changes (Doc ID 2233557.1)

Last updated on FEBRUARY 21, 2017

Applies to:

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

Goal

Customer had following configuration:

Database A

AEXT01 --> Configured to capture data on HEADER table
APMP01 --> Pumps HEADER data to Database B

Database B

BREP01 --> Applies changes to HEADER Table

The above is working fine. Now a trigger is placed on HEADER table in Database B which will insert data into RESPONSE table. Now this RESPONSE table will be replicated from Database B to Database A

Database A

AEXT01 --> Configured to capture data on HEADER table
APMP01 --> Pumps HEADER data to Database B
AREP01 --> Applies RESPONSE changes

Database B

BREP01 --> Applies changes to HEADER Table
BEXT01 --> Captures RESPONSE table changes
BPMP01 --> Pumps RESPONSE table changes to Database A

The problem was when a row is inserted in HEADER table in Database A, it gets replicated in Database B, there is an insert in RESPONSE table due to the trigger. But this RESPONSE table insert is not being replicated from Database B to Database A.

But a manual insert on HEADER table in Database B (Which inserts data into RESPONSE table as well), the RESPONSE data is getting replicated from Database B to Database A.

Solution

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