一、通过功能管理员清除高速缓存,同时通过系统管理员提交“有效用户和职责”,观察结果;
二、通过请求同步局部工作流,观察结果;
三、如果前面两步未生效,可考虑应用以下解决方案
1. Go into the responsibility: System Administrator.
2. Navigate to Request > Run.
3. Submit request 'Synchronize WF LOCAL tables'
4. Submit request 'Workflow Directory Services User/Role Validation'
5. Check result in table wf_local_user_roles via:
select role_name, effective_end_date from wf_local_user_roles
where user_name='<>';
6. If still find some records haven't been changed to null, perform:
a.) backup the records:
create table wf_local_user_roles_bak as
select * from wf_local_user_roles
where user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');
b.) update effective_end_date to null
update wf_local_user_roles
set effective_end_date=to_date('9999-01-01','RRRR-MM-DD')
where user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');
7. Retest the issue.
8. Migrate the solution as appropriate to other environments.