My Oracle Support Banner

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

Last updated on AUGUST 09, 2018

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

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
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.