After Patch 24690690, Paolapsyn.sql Fails with 'ORA-04045: errors during recompilation/revalidation of APPS.PA_OLAP_PVT' and 'ORA-01775: looping chain of synonyms' (Doc ID 2471892.1)

Last updated on FEBRUARY 07, 2024

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

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

After Patch 24690690, Paolapsyn.sql Fails with 'ORA-04045: errors during recompilation/revalidation of APPS.PA_OLAP_PVT' and 'ORA-01775: looping chain of synonyms' (Doc ID 2471892.1)

Applies to:

Symptoms

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!