Update Synonyms Errors with ORA-00955
(Doc ID 2006920.1)
Last updated on MAY 01, 2023
Applies to:
Oracle Demantra Real-Time Sales and Operations Planning - Version 12.2.3 and laterInformation 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 |