Error ORA-20002: [WF_INVAL_USER_ROLE] has been detected in while assigning new or modifying old responsibilities

We were getting below errors while assigning or modifying user responsibilities.




Oracle error-1502: ORA-01502: index
APPLSYS.WD_LOCAL_USER_ROLES_U1 or partition of such index
is in unusable state.
ORA-20002: [WF_INVAL_USER_ROLE] has been detected in
FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT.


Solution.


It has 2 solutions, for the time being you can rebuild the below indexes then this error will disappear.

Solution # 1.


select * from dba_indexes di
where di.index_name in ('WF_LOCAL_USER_ROLES_N2',
'WF_LOCAL_USER_ROLES_N4', 'WF_LOCAL_USER_ROLES_N5',
'WF_LOCAL_USER_ROLES_N6', 'WF_LOCAL_USER_ROLES_N7',
'WF_LOCAL_USER_ROLES_U1')


alter index applsys.WF_LOCAL_USER_ROLES_N4 rebuild online;
alter index applsys.WF_LOCAL_USER_ROLES_N2 rebuild online;
alter index applsys.WF_LOCAL_USER_ROLES_N5 rebuild online;
alter index applsys.WF_LOCAL_USER_ROLES_N6 rebuild online;
alter index applsys.WF_LOCAL_USER_ROLES_N7 rebuild online;
alter index applsys.WF_LOCAL_USER_ROLES_U1 rebuild online;


Solution # 2 (which is permanent one)


But after some time you will see this error again while assigning new responsibility or modifying to particular user in sysadmin so for permanent solution follow the below option:-

Stop this Concurrent request permanently because it was causing issue that was bug in 11i and it was mandatory to run below request while synchonization of workflow table but it is fixed in R12 so it is not harmful to stop below request.

Synchronize WF LOCAL tables