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 laterInformation 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 <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
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
Goal |
Solution |
References |