Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

R12.1.3 : Attempting to apply 9239090 and has failed on igisiatgr.sql ORA-04095: trigger 'IGI_SIA_

edited Jun 25, 2018 10:14AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓
Hi,
Attempting to apply 9239090  and has failed on igisiatgr.sql

worker log states

sqlplus -s APPS/***** @$APPL_TOP/igi/12.0.0/patch/115/sql/igisiatgr.sql
Connected.

Trigger created.


Trigger created.


Trigger created.


Trigger created.


Trigger created.

CREATE OR REPLACE TRIGGER igi_sia_ap_holds_t1
                         *
ERROR at line 1:
ORA-04095: trigger 'IGI_SIA_AP_HOLDS_T1' already exists on another table,
cannot replace it


The trigger does indeed exist on another table ..

select owner, table_owner, table_name from dba_triggers where trigger_name='IGI_SIA_AP_HOLDS_T1';

OWNER                          TABLE_OWNER
------------------------------ ------------------------------
TABLE_NAME
------------------------------
APPS                           AP
AP_HOLDS_OBS
Tagged:

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