EBS系统关于职责丢失的问题

EBS版本：11.5.10.2

使用户帐户终止然后再去掉终止日期，这样一折腾这个用户的某些职责就看不到了。这个问题可以通过一下方法来解决：

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.

这种方法治标不治本，ORACLE也提供了相关的PATCH。patch 4719658。