While applying the RUP 7FAILED: file icxwtab.odf on worker 1 for product icx

Problem: While applying the RUP 7FAILED: file icxwtab.odf on worker 1 for product icx username ICX.Time is: Sun Sep 19 2010 00:39:53In adworker log file : /p02/oracle/prodappl/admin/PROD/log/adwork001.logCREATE UNIQUE INDEX ICX.ICX_TRANSACTIONS_U1 ON ICX.ICX_TRANSACTIONS(TRANSACTION_ID) LOGGING PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTESTATISTICS TABLESPACE APPS_TS_TX_IDXStatement executed.AD Worker error:The index cannot be created as the table has duplicate keys.Use the following SQL statement to identify the duplicate keys:SELECT TRANSACTION_ID, count(*)FROM ICX.ICX_TRANSACTIONSGROUP BY TRANSACTION_IDHAVING count(*)>1Solution:a).Metalink:icxwtab.odf is unable to create index ICX_TRANSACTIONS_U1 [ID 430673.1]Run -- SQL script under $ICX_TOP/sql (named ICXDLTMP.sql).If any error while run the above sql script like “AUDIT_USER_END” … THENYou can re-run from Patch Direcotry IT WILL BE SUCESSbash-3.00$ cd /B01/patches/RUP_7/6241631/backup/PROD/prod/icx/sql/bash-3.00$ lsICXDLTMP.sql ICXDLTMP.sql_bkpbash-3.00$ sqlplus apps/pllerpSQL> @ICXDLTMP.sql43212 rows deleted.13350 rows deleted.89319 rows deleted.0 rows deleted.0 rows deleted.0 rows deleted.0 rows deleted.0 rows deleted.Commit complete.PL/SQL procedure successfully completed.Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsbash-3.00$For restart the faild worker===================b). AD Controller Menu$cd /p02/oracle/prodappl/Source the environment$adctrlEnter a Logfile : /p02/oracle/prodappl/adctrl_190910.logEnter the ORACLE username of Application Object Library [APPLSYS] : APPLSYSEnter the ORACLE password of Application Object Library [APPS] : ***** ( apps pwd)AD Controller Menu---------------------------------------------------1. Show worker status2. Tell worker to restart a failed job3. Tell worker to quit4. Tell manager that a worker failed its job5. Tell manager that a worker acknowledges quit6. Restart a worker on the current machine7. ExitNote : option 8 is the skip the worker ( this option is disable)First select 1st option : show worker statusAd ControlWorker Code Context Filename Status------ -------- ---------------------- -------------------- --------------1 Run AutoPatch R115 icxwtab.odf FAILED2 Run AutoPatch R115 WaitThen You can select 2 nd option : Restart a failed job--- enter the failed worker number . i.e 1