My Oracle Support Banner

Patch 24690690 Fails with ORA-01775: Looping Chain Of Synonyms (Doc ID 2471892.1)

Last updated on AUGUST 17, 2020

Applies to:

Oracle Project Planning and Control - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

<PATCH 24690690>  ORACLE E-BUSINESS SUITE 12.2.7 RELEASE UPDATE PACK  failed with below error:

sqlplus -s APPS/***** @/***/***/***/******/****/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/tst/fs1/EBSapps/appl/pa/12.0.0/patch/115/sql/paolapsyn.sql '
Connected.

PL/SQL procedure successfully completed.

BEGIN pa_olap_pvt.create_stub_synonyms; END;

*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of APPS.PA_OLAP_PVT
ORA-01775: looping chain of synonyms
ORA-06508: PL/SQL: could not find program unit being called: "APPS.PA_OLAP_PVT"
ORA-06512: at line 1

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
References


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