问题:职责失重新启用后,登录或切换时无重启用后的职责可用
分析:
查询表 wf_local_user_roles.effective_end_date 是否有失效日期,如有失效日期将其改为9999-01-01
查询表 wf_user_role_assignments.effective_end_date 是否有失效日期,如有失效日期请其清空
处理:Update wf_local_user_roles.effective_end_date is 9999-01-01.
一、执行如下请求
1. Run the request 'Sync responsibility role data into the WF table'.
2. Run the request 'Synchronize WF LOCAL tables'.
3. Run the request 'Workflow Directory Services User/Role Validation'(with parameters 10000, yes,yes, yes).
二、检查table: ur.effective_end_date 为空,更新
4. Update wf_local_user_roles.effective_end_date is 9999-01-01.
---4.1.职责失重新启用后,登录或切换时看不到重启用后的职责
select ur.user_name,ur.role_name
,ur.effective_end_date ur_effective_end_date--***
,ur.role_end_date ur_role_end_date--***
,ura.effective_end_date ura_effective_end_date
,ura.end_date ura_end_date
,ur.effective_start_date
,ur.start_date
,ur.expiration_date
,ura.effective_start_date
,ura.start_date
,ura.relationship_id
,ura.assigning_role_end_date
from wf_local_user_roles ur ,wf_user_role_assignments ura
where 1 =1
and ur.user_name = ura.user_name
and ur.role_name = ura.role_name
and ur.user_name = '&P_USER_NAME'
and ura.role_name like '&P_ROLE_NAME'
and ura.relationship_id = -1
and ( (ur.effective_start_date is null or ur.effective_start_date <> ura.effective_start_date)
or (ur.effective_end_date is null or ur.effective_end_date <> ura.effective_end_date)
);
---4.2.查看end_date
select ur.user_name,ur.role_name
,ur.role_end_date,ur.effective_end_date
from wf_local_user_roles ur
where ur.user_name ='&P_USER_NAME'
and ur.role_name like '&P_ROLE_NAME'
and ur.effective_end_date is not null;
---4.3.更新同步
update wf_local_user_roles ur
set ur.effective_end_date = todate('9999-01-01','yyyy-mm-dd')--null
where ur.user_name = '&P_USER_NAME'
and ur.role_name like '&P_ROLE_NAME'
and ur.effective_end_date is not null;