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 later
Information in this document applies to any platform.
This problem can occur on any platform.
Upgrading to R12 and the file hrcretrg.sql is run as part of this process, it fails with the following error:
sqlplus -s APPS/*****
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
before insert or update on HR_ORGANIZATION_INFORMATION_BK
for each row
l_sysdate DATE := sysdate;
-- Trigger generated by hrcretrg.sql at 2009/02/02 11:46:57.
ORA-06512: at line 123
ORA-06512: at line 267
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