During R12 Upgrade HRCRETRG.Sql is Failing Error - ORA-20000 ORA-4095 HR_ORGANIZATION_INFORMATIO_WHO Already Exist
(Doc ID 779841.1)
Last updated on NOVEMBER 23, 2020
Applies to:
Oracle Human Resources - Version 12.0.4 and laterInformation in this document applies to any platform.
This problem can occur on any platform.
Symptoms
Upgrading to R12 and the file hrcretrg.sql is run as part of this process, it fails with the following error:
sqlplus -s APPS/*****
declare
*
ERROR at line 1:
ORA-20000: do_sql:ORA-4095(ORA-04095: trigger 'HR_ORGANIZATION_INFORMATIO_WHO'
already exists on another table, cannot replace it) do_sql: create or replace
trigger HR_ORGANIZATION_INFORMATIO_WHO
before insert or update on HR_ORGANIZATION_INFORMATION_BK
for each row
declare
l_sysdate DATE := sysdate;
begin
-- Trigger generated by hrcretrg.sql at 2009/02/02 11:46:57.
if hr_
ORA-06512: at line 123
ORA-06512: at line 267
Cause
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
| Symptoms |
| Cause |
| Solution |