The worker failed with "A Different index with same column name exists".

Hi Experts,
  We are doing upgrade from R12.1.1 to R12.1.3 the worked failed with below error.

Index PA_PROG_ACT_BY_PERIOD_TEMP_N1 does not exist in PA.

 

CREATE INDEX "PA"."PA_PROG_ACT_BY_PERIOD_TEMP_N1" ON "PA"."PA_PROG_ACT_BY_PERIOD_TEMP" ("STRUCTURE_VERSION_ID", "RESOURCE_ASSIGNMENT_ID", "TXN_CURRENCY_CODE")

Start time for statement above is Thu Jan 16 17:39:31 IST 2014

A Different index with same column name exists.

I followed the doc id  1514897.1

select index_owner,index_name,column_name from all_ind_columns where column_name in ('STRUCTURE_VERSION_ID','RESOURCE_ASSIGNMENT_ID','TXN_CURRENCY_CODE');