My Oracle Support Banner

Upgrade to 12.2.12 - Invalid Object PA_OLAP_PVT Errors With ORA-01775 Looping Chain of Synonyms (Doc ID 3008964.1)

Last updated on MARCH 19, 2024

Applies to:

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

Symptoms

Upgrade from 12.2.6 to 12.2.12 which failed during AD Online Patching (ADOP).  PA_OLAP_PVT is invalid.  Compiling the object errors with ORA-01775: looping chain of synonyms.

1. Followed note, Note 2471892.1 (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').  The solution in the note did not resolve the issue.

2. Performed the following steps manually, but did not resolve the issue.

a. Run this script from sqlplus as sysdba:

?/olap/admin/olap.sql SYSAUX TEMP

b. Run the olapiboo.plb as in note 2471892.1.

L>conn / as sysdba
SQL>spool fixolap.log
SQL>@?/olap/admin/olapiboo.plb;
SQl>spool off

c. Recompile the package 'PA_OLAP_PVT'. 

SQL> alter package PA_OLAP_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY PA_OLAP_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-01775: looping chain of synonyms

 

Replication steps:
1. Upgrade from 12.2.6 to 12.2.12 using AD Online Patching (ADOP).
2. Invalid object, PA_OLAP_PVT, appears.

Changes

Upgrade from 12.2.6 to 12.2.12.

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
Changes
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.