During Database Upgrade ALTER_PROCEDURE:"APPS"."COMPILE_ORG_RATES_5081830" Failed To Create (Doc ID 2009702.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On 12.1.3 version, after upgrading the database from 11.2.0.4 to 12.1.0.2, get the following errors:

ALTER_PROCEDURE:"APPS"."COMPILE_ORG_RATES_5081830" failed to create

ORA-39083: Object type ALTER_PROCEDURE:"APPS"."COMPILE_ORG_RATES_5081830" failed  to create with error:
ORA-01775: looping chain of synonyms
Failing sql is:

ALTER PROCEDURE "APPS"."COMPILE_ORG_RATES_5081830" COMPILE PLSQL_OPTIMIZE_LEVEL= 2 PLSQL_CODE_TYPE= INTERPRETED PLSQL_DEBUG= FALSE PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2013-11-16 05:40:43'
  Completed 16 ALTER_PROCEDURE objects in 4 seconds


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import the data base.


BUSINESS IMPACT
-----------------------
Due to this issue, users cannot complete the upgrade steps.

Changes

Attempting to upgrade the database to version 12.1.0.2 from 11.2.0.4.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms