LSH 2.5 Upgrade Patch 28529507- ORA-20010: Error in cdr25compidx.sql Index create script at :DME_DISC_WORKTABLIST (Doc ID 2661165.1)

1. Per adpatch.log:

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Apr 17 2020 16:23:29
APPL_TOP is set to <Path>
Done reading jobs from FND_INSTALL_PROCESSES table ...
...
Completed: file dmw247dropindex.sql on worker 2 for product cdr username CDR.
  FAILED: file cdr25predropidx.sql on worker 1 for product cdr username CDR.
 Deferred: file cdr25predropidx.sql on worker 1 for product cdr username CDR. (Deferment number 1 for this job)
...
 Deferred: file cdr25predropidx.sql on worker 1 for product cdr username CDR. (Deferment number 2 for this job)
 Assigned: file cdr25predropidx.sql on worker 1 for product cdr username CDR.
  FAILED: file cdr25predropidx.sql on worker 1 for product cdr username CDR.

ATTENTION: All workers either have failed or are waiting:
  FAILED: file cdr25predropidx.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

2. Per adwork001.log:

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Fri Apr 17 2020 16:23:29

Time when worker failed: Fri Apr 17 2020 16:23:38
Time when worker started job: Fri Apr 17 2020 16:23:38

Start time for file is: Fri Apr 17 2020 16:23:38

sqlplus -s APPS/***** <Path>/cdr25predropidx.sql &un_fnd &un_apps
Connected.
DECLARE
*
ERROR at line 1:
ORA-20010: Error in cdr25compidx.sql Index create script at :DME_DISC_WORKTABLIST. Error: ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-06512: at line 3168

Time when worker failed: Fri Apr 17 2020 16:23:38