Technology Stack - EBS (MOSC)

MOSC Banner

R12.2 : custom triggers on edition tables

edited Feb 21, 2019 12:00AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hello ,

We upgraded to R12.2.8 from 11i  during the weekend.    We are need to replace a trigger and it is failing with

ORA-04095: trigger 'LASERFICHE_AI_TRG' already exists on another table, cannot

replace it

The command is CREATE OR REPLACE TRIGGER LASERFICHE.LASERFICHE_AI_TRG ..     BEFORE INSERT ON LASERFICHE.APX_LASERFICHE_STAGING

in DBA_Triggers , the table is editoned views.

1  select table_name, trigger_name from dba_triggers

  2* where trigger_name = 'LASERFICHE_AI_TRG'

SQL> /

TABLE_NAME

--------------------------------------------------------------------------------

TRIGGER_NAME

--------------------------------------------------------------------------------

APX_LASERFICHE_STAGING#

LASERFICHE_AI_TRG

question is should we replace the trigger in editon views or should we drop and recreate the trigger on table.

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