Hello OGG experts,
We have one table which contains two extra columns to capture current_scn and sysdate in target only. The current scn is inserted via a trigger. The sysdate is defined by COLUMN mapping ( = @DATENOW()) in the replicat parameter file.
This process works very well with OGG 11g. However, after we upgraded OGG from 11g to 19c, the trigger doesn't work properly. The current scn is always NULL.
I can confirm that the trigger works properly if I insert the data manually.
Any solutions or recommendations?
Thank you,
Lina