EBS Customizations (MOSC)

MOSC Banner

Trigger on an Edition view is not firing when data is inserted using Oracle Golden Gate

  1. Created Custom table : xxmj.xx_jj_stg (EBS12.2)
  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#
  3. 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center