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 APRIL 18, 2024
Applies to:
Oracle Project Costing - Version 12.1.3 and laterInformation 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
Changes
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 |