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:

Goal

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#

Solution

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