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 JULY 18, 2018

Applies to:

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

Goal

The who columns of the PER_PERSON_ANALYSES table not populated and as per "Who Triggers Missing from Some HRMS Tables (Doc ID 299740.1)"

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

It is failing however on clashes with existing triggeres, 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

To view full details, 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 a vibrant support community of peers and Oracle experts.