系统出现了职责丢失的现像，登陆后不显示相关职责，进入Form后职责也没有。以前没有过，只是在打过HR的Patch后才出现在，后来在网上查找发现有一种解决办法，记录如下，
1.select ura.user_name, ura.role_name
from wf_local_user_roles ur, wf_user_role_assignments ura
where ur.user_name = ura.user_name
and ur.role_name = ura.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)) ;
2.UPDATE WF_USER_ROLE_ASSIGNMENTS
set effective_end_date = to_date(null)
where rowid in (select ura.rowid
from wf_local_user_roles ur, wf_user_role_assignments ura
where ur.user_name = ura.user_name
and ur.role_name = ura.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)));
3.然后做如下动作
System Administrator responsibility 》request 》 Workflow Directory Services User/Role Validation concurrent program.
CIO之家 www.ciozj.com 微信公众号:imciow