My Oracle Support Banner

"ORA-00955: name is already used by an existing object" After PFT Upgrade From 8.0.5 to 8.0.7 (Doc ID 2749796.1)

Last updated on FEBRUARY 26, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

After OFSAA PFT upgraded from 8.0.5 to 8.0.7, the installation completed with the following error message in OFSAAIUpdate.log.



ERROR
-----------------------

Log [2021-01-08 04:30:44.608] [OFSAAIUPDATE] [ERROR] - Exception while executing the query - create synonym cssms_role_mast for RPF_CNFG2_SCHEMA.cssms_role_mast
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.