Error while applying patch 5903765

 Hi,

Apps 11.5.10.2

applying patch 5903765 for extended support.  

Originally they were getting AD Worker error:

ORA-12801: error signaled in parallel query server P000

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

occurred while executing the SQL statement:

CREATE UNIQUE INDEX ICX.ICX_TRANSACTIONS_U1 ON ICX.ICX_TRANSACTIONS

 (TRANSACTION_ID) LOGGING  PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE

 STATISTICS PARALLEL TABLESPACE APPS_TS_TX_IDX

Resolved this with Note 430673.1.

Now the adworkers fails again with errors including 

select on GV$LOGFILE to em_oam_monitor_role 

AD Worker error:

The following ORACLE error:

ORA-01031: insufficient privileges

Provided solution in Note 467944.1 Applying a CPU Patch 2010