My Oracle Support Banner

ORA-4095: Trigger Already Exists On Another Table, Cannot Replace It - When Running Hrcretrg2.sql (Doc ID 2424542.1)

Last updated on MARCH 14, 2022

Applies to:

Oracle Human Resources - Version 12.2.4 and later
Information in this document applies to any platform.


The who columns of the PER_PERSON_ANALYSES table not populated and as per "Who Triggers Missing from Some HRMS Tables <Note 299740.1> "

Tried to execute the script hrcretrg2.sql in a test env.

It is failing however on clashes with existing triggers, against different objects, views as opposed to tables for eg:

     "failing to create trigger PER_ANALYSIS_CRITERIA_WHO for table PER_ANALYSIS_CRITERIA as it has already been created for view PER_ANALYSIS_CRITERIA#."

Similarly for PER_PERSON_ANALYSES_WHO, failing to create for table PER_PERSON_ANALYSES as it already exists for view PER_PERSON_ANALYSES#


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.