R12: Recreate Grants And Synonyms Fails ORA-20000: ORA-00955 Synonyms Loop:create_synonym (PA,PA_PERIODS_TEMP,APPS,PA_PERIODS_TEMP) (Doc ID 1599520.1)

Last updated on OCTOBER 24, 2016

Applies to:

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

Symptoms

Upgrading from 11.5.9 to 12.1.3 requires patch 7461070 to be installed. It has a post-install step of running Recreate Grants and Synonyms which errors:

sqlplus -s APPS/***** @/u01/app/apppi/PJAAI/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adappsgs.pls &systempwd 1 PA APPLSYS APPS TRUE FALSE TRUE
Connected.
old 2: ad_apps_private.create_grants_and_synonyms(&2,'&3','&4','&5','FALSE');
new 2: ad_apps_private.create_grants_and_synonyms(1,'PA','APPLSYS','APPS','FALSE');
begin
*
ERROR at line 1:
ORA-20000: ORA-00955: name is already used by an existing
object:create_grants_and_synonyms(1,PA,APPLSYS,APPS): create_base_gs(PA,APPS):
In Synonyms Loop:create_synonym(PA,PA_PERIODS_TEMP,APPS,PA_PERIODS_TEMP):
do_apps_ddl(APPS,CREATE SYNONYM "PA_PERIODS_TEMP" FOR PA."PA_PERIODS_TEMP"):
ORA-06512: at line 5

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