Update Synonyms Errors with ORA-00955 (Doc ID 2006920.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.3 and later
Information in this document applies to any platform.

Goal

Customer is running Update Synonyms Errors and gets the ORA-00955 error as per logs

 

Granting SELECT privilege on following tables to DEMANTRA schema.
MSC.MSC_PLANS
MSC.MSC_INT_PUBLISH_DATA
MSC.MSC_INT_SUPPORTED_API
MSC.MSC_BIS_INV_DETAIL
MSC.MSC_SYSTEM_ITEMS
MSC.MSC_PLAN_ORGANIZATIONS
MSC.MSC_TRADING_PARTNERS
MSC.MSC_TP_ID_LID
MSC.MSC_TRADING_PARTNER_SITES
MSC.MSC_TP_SITE_ID_LID
MSC.MSC_REGIONS
MSD.MSD_DEM_TIME
MSD.MSD_DEM_CTO_BOM
Profile MSD_DEM: Version has been set to '12.2' at the SITE level
Checking for plan type lookup 'Rapid Plan' in demantra
Updated Integration1CalendarLoad parameter in sys_params table to :- MSD.MSD_DEM_TIME
Check if the table EP_T_SRC_SALES_TMPL_LD is present -
Check, drop and recreate the table EP_T_SRC_SALES_TMPL_LD -
Calling CALL_DM_BUILD_PROCEDURES.
Created synonym BIIO_DSR_SALES_DATA
ORA-00955: name is already used by an existing object
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
 

Solution

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