adpatch FND_INSTALL_PROCESSES table - ORA-00955: name is already used by an existing object

Error:
Creating FND_INSTALL_PROCESSES table...

AutoPatch error:
The following ORACLE error:

ORA-00955: name is already used by an existing object


occurred while executing the SQL statement:

CREATE TABLE AD_DEFERRED_JOBS( phase        number       not null,
file_product varchar2(10) not null, subdirectory varchar2(30) not null,
filename     varchar2(30) not null, arguments    varchar2(1996),
start_time    date, restart_time  date, elapsed_time  number,
restart_count number, defer_count number) TABLESPACE APPS_TS_TX_DATA
initrans 100 storage(initial 4K next 4K)

Error running SQL and EXEC commands in parallel

You should check the file
/oracle/thus/thusappl/admin/THUS_806_BALANCE/log/u7583801.log

for errors.



SOLUTION:

To implement the solution, please execute the following steps:

1. 1) Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS
schema
a. sqlplus applsys/<password>
b. create table fnd_Install_processes_back
as select * from fnd_Install_processes;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes_back;
select count(*) from fnd_Install_processes;

2) Backup the AD_DEFERRED_JOBS table.
a. sqlplus applsys/<password>
b. create table AD_DEFERRED_JOBS_back
as select * from AD_DEFERRED_JOBS;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;

3) Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
a. sqlplus applsys/<password>
b. drop table FND_INSTALL_PROCESSES;
c. drop table AD_DEFERRED_JOBS;

drop table applsys.fnd_Install_processes; ==> if not working
select count(*) from applsys.AD_DEFERRED_JOBS;
drop table applsys.AD_DEFERRED_JOBS;
4) start the patch again