Adpatch Errors While Running Hrcretrg.sql: ORA-20000: do_sql:ORA-4095: "Trigger xxxxx Already Exists On Another Table, Cannot Replace It"

(Doc ID 453202.1)

Last updated on JULY 14, 2016

Applies to:

Oracle HRMS (Australia) - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

While applying AUSTRALIAN CUMULATIVE RELEASE AU.V, adpatch fails when running hrcretrg.sql.  Error details:

ERROR at line 1: 
ORA-20000: do_sql:ORA-4095(ORA-04095: trigger   'PAY_ORG_PAYMENT_METHODS_F_WHO'
already exists on another table, cannot replace it) do_sql: create or replace
trigger PAY_ORG_PAYMENT_METHODS_F_WHO
before insert or update on PAY_ORG_PAYMENT_METHODS_F_BKP
for each row
declare
l_sysdate DATE := sysdate;
begin
-- Trigger generated by hrcretrg.sql at 2007/07/10 23:10:38.
if hr_ge
ORA-06512: at line 123
ORA-06512: at line 267

 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms