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.
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#
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!