My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.