Trigger on an Edition view is not firing when data is inserted using Oracle Golden Gate
- Created Custom table : xxmj.xx_jj_stg (EBS12.2)
- Created trigger xx_jj_trg before insert or update or delete on xx_jj_stg
for each row………. - This created trigger on Edition View xxmj.xx_jj# - GG Setup done using 23ai OGG version
Map xx_leg_tbl (Legacy Source Mainframe table) to xxmj.xx_jj_stg
Issue is trigger not firing even after using "DBOPTIONS NOSUPPRESSTRIGGERS"
and even after using SQLEXEC 'ALTER SESSION SET EDITION = "V_APPS_00000000"'
But it trigger works if Golden gate setup uses target as Edition View xxmj.xx_jj#.
Please advise ASAP.