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 APRIL 04, 2025
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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |