R12.1.3 : Attempting to apply 9239090 and has failed on igisiatgr.sql ORA-04095: trigger 'IGI_SIA_
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
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:
0