Symptom:
ATTENTION: All workers either have failed or are waiting:
FAILED: file ap_undo_event_log.xdf on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log showed below error
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
Fix:
Follow below Action plan to rename the table in APPS Schema and proceed with patch application. This way the table will not be checked and later if needed the data can be moved to the new table.
1. Rename the table
sqlplus apps
rename AP_UNDO_EVENT_LOG to AP_UNDO_EVENT_LOG_R1213;
2. Restart Failed work using adctrl Option 2: /dodiapps/rgp6/rgp6apps/fs1/EBSapps/appl/admin/RGP6/log/adctrl_18712060_ap_undo_event_log.log
3. Restore the data after patch application is successful.
sqlplus apps
insert into cle.ap_undo_event_log (select * from ap_undo_event_log_r1213);
commit;
SQL> insert into cle.ap_undo_event_log (select * from ap_undo_event_log_r1213);
116 rows created.
SQL> commit;
Commit complete.
SQL>
Metalink Reference: EMEA Add-On Localization Upgrade Patch 18712060 Failed with Error “ORA-00955: name is already used by an existing object” (Doc ID 2883489.1)
Orama.blog 