11i: "ORA-00995: missing or invalid synonym identifier" Error When Recompiling Invalid Synonyms After Database Upgrade

(Doc ID 380480.1)

Last updated on MAY 03, 2016

Applies to:

Oracle Applications DBA - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 28-Dec-2012***

Symptoms

On 11.5.9 in Production on a 10.2.02 database, many public synonyms are invalid. When trying to recompile them, the following error is received for many of them :
...
ERROR at line 1:
ORA-00995: missing or invalid synonym identifier

...

Following SYNONYMS were identified in Status INVALID:
...
SYNONYM PUBLIC.PORTAL_CONTENT
SYNONYM PUBLIC.EMAIL_TO_RESOLUTION
SYNONYM PUBLIC.PORTAL_TAB_API
SYNONYM PUBLIC.ISUPPORT_API
SYNONYM PUBLIC.LOGOFF_PORTAL
SYNONYM PUBLIC.LAUNCH_PORTAL
SYNONYM PUBLIC.SENDMESSAGE
SYNONYM PUBLIC.DEBUG_CARTX
SYNONYM PUBLIC.CIF_ACCOUNTS_V
SYNONYM PUBLIC.CIF_COLLATERAL_MGR
SYNONYM PUBLIC.CIF_CONTACTS_V
SYNONYM PUBLIC.CIF_CUSTOMERS_V
SYNONYM PUBLIC.CIF_FND_CLIENT_INFO
SYNONYM PUBLIC.CIF_FND_GLOBAL
SYNONYM PUBLIC.CIF_FND_PROFILE
SYNONYM PUBLIC.CIF_FND_RESPONSIBILITY
SYNONYM PUBLIC.CIF_FND_USER
SYNONYM PUBLIC.CIF_MARKET_SEGMENTS_V
SYNONYM PUBLIC.CIF_MESSAGE
SYNONYM PUBLIC.CIF_MTL_SYSTEM_ITEMS_V
SYNONYM PUBLIC.CIF_ORGANIZATIONS_V
SYNONYM PUBLIC.CIF_PRICELISTS_V
SYNONYM PUBLIC.CIF_PRODUCTS_V
SYNONYM PUBLIC.CIF_PROFILE
SYNONYM PUBLIC.CIF_PROMOTION
SYNONYM PUBLIC.CIF_PROMOTIONS_V
SYNONYM PUBLIC.CIF_PROM_OFFERS_V
SYNONYM PUBLIC.CIF_PROM_OFFER_PRODUCTS_V
SYNONYM PUBLIC.CIF_QUERY_BOOKS_V
SYNONYM PUBLIC.CIF_SECURITY
SYNONYM PUBLIC.CIF_SEED_LISTS_V
SYNONYM PUBLIC.CIF_SOURCE_V
SYNONYM PUBLIC.CIF_SUBSCRIBERS_V
SYNONYM PUBLIC.CIF_USERS_V
SYNONYM PUBLIC.CIF_USER_ROLES_V
SYNONYM PUBLIC.DISCOVERER_SEQ
SYNONYM PUBLIC.DISCOVERER_ALL_DOCS
SYNONYM PUBLIC.DISCOVERER_DOCS
SYNONYM PUBLIC.DISCOVERER_GRANTS
SYNONYM PUBLIC.EUL$ACCESS_PRIVILEGES
SYNONYM PUBLIC.EUL$APPLICATION_PARAMETERS
SYNONYM PUBLIC.EUL$JOIN_COMBINATIONS
SYNONYM PUBLIC.EUL$KEY_CONSTRAINTS
SYNONYM PUBLIC.EUL$NMSDO_JC_USAGES
SYNONYM PUBLIC.EUL$OBJECT_DEPENDENCIES
SYNONYM PUBLIC.EUL$OBJECT_GROUPS
SYNONYM PUBLIC.EUL$OBJECT_JOIN_USAGES
SYNONYM PUBLIC.EUL$OBJECT_SQL_SEGMENTS
SYNONYM PUBLIC.EUL$OBJS
SYNONYM PUBLIC.EUL$OG_OBJ_LINKS
SYNONYM PUBLIC.EUL$PLAN_TABLE
SYNONYM PUBLIC.EUL$QPP_ITEM_STATISTICS
SYNONYM PUBLIC.EUL$QPP_STATISTICS
SYNONYM PUBLIC.EUL$SUB_QUERIES
SYNONYM PUBLIC.EUL$SUB_QUERY_CORRELATIONS
SYNONYM PUBLIC.EUL$SUMMARY_BITMAPS
SYNONYM PUBLIC.EUL$SUMMARY_DESIGN_ELEMENTS
SYNONYM PUBLIC.EUL$SUMMARY_ELEMENT_EXCLUSIONS
SYNONYM PUBLIC.EUL$SUMMARY_ITEM_USAGES
SYNONYM PUBLIC.EUL$SUMMARY_OBJECTS
SYNONYM PUBLIC.EUL$SUMMARY_REFRESH_INTERVALS
SYNONYM PUBLIC.EUL$SUMMARY_REFRESH_SETS
SYNONYM PUBLIC.EUL$SUMMARY_TABLE_DEFINITIONS
SYNONYM PUBLIC.EUL$VBH_IT_LINKS
SYNONYM PUBLIC.EUL$VERSIONS
SYNONYM PUBLIC.EUL$FUNCTION_CATEGORIES
SYNONYM PUBLIC.EUL$FUN_FC_LINKS
SYNONYM PUBLIC.EUL$GET_FOLDER_NAME
SYNONYM PUBLIC.EUL$HIERARCHIES
SYNONYM PUBLIC.EUL$HIERARCHY_NODES
SYNONYM PUBLIC.EUL$HIERARCHY_SEGMENTS
SYNONYM PUBLIC.EUL$ID_SEQ
SYNONYM PUBLIC.EUL$IG_EXP_LINKS
SYNONYM PUBLIC.EUL$JC_JOIN_LINKS
SYNONYM PUBLIC.EUL$BA_BA_LINKS
SYNONYM PUBLIC.EUL$DATE_HIERARCHY_NODES
SYNONYM PUBLIC.EUL$DOMAINS
SYNONYM PUBLIC.EUL$DOMAIN_VALUES
SYNONYM PUBLIC.EUL$EUL_USERS
SYNONYM PUBLIC.EUL$EXPRESSIONS
SYNONYM PUBLIC.EUL$EXPRESSION_DEPENDENCIES
SYNONYM PUBLIC.EUL$FUNCTIONScompile;
SYNONYM PUBLIC.EUL$FUNCTION_ARGUMENTS

...

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