EMEA Add-On Localization Upgrade Patch 18712060 Failed with Error "ORA-00955: name is already used by an existing object" (Doc ID 2883489.1)

Last updated on JULY 21, 2022

Applies to:

Symptoms

EMEA Add-On Localization (CLE) 12.2 Upgrade Patch 18712060 failed with error ORA-00955: name is already used by an existing object

ERROR
-----------------------
XDF file application started. Current time is: Thu Sep 03 03:14:02 CDT 2020

================================================================================
Applying XDF file : /vol2/opt/erptrn/product/fs1/EBSapps/appl/cle/12.0.0/patch/115/xdf/ap_undo_event_log.xdf
================================================================================

Table Name is AP_UNDO_EVENT_LOG
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 7
The table in the Xml file and in the target database match

Executing grants on AP_UNDO_EVENT_LOG to APPS
GRANT ALL ON CLE.AP_UNDO_EVENT_LOG TO APPS WITH GRANT OPTION
Creating synonym :CREATE SYNONYM AP_UNDO_EVENT_LOG FOR CLE.AP_UNDO_EVENT_LOG
Exception occured in createSynonym
ORA-00955: name is already used by an existing object

==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Thu Sep 03 03:14:02 CDT 2020]
Updating task with status 1

AD Worker error:
The utility FndXdfCmp returned error for the above task.

AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.

Steps To Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Followed below MOS doc id.
    EMEA Add-on Localizations - Upgrade steps to 12.2 (Doc ID 1593750.1)

2. While applying the upgrade patch 18712060, error is observed in Patch worker log.

Cause

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