EBS系统关于职责丢失的问题2008-11-10 11:45:54
分类： Oracle
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)));
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
System Administrator responsibility 》request 》 Workflow Directory Services User/Role Validation concurrent program.
这种方法治标不治本，ORACLE也提供了相关的PATCH。patch 4719658
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10951282/viewspace-761016/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
