首页 > 代码库 > EBS 用户职责 不显示
EBS 用户职责 不显示
两种情况:
1.用户添加职责后,在FORM页面的职责列表无法看到
首先,系统管理员职责运行【同步 WF 局部表】(Synchronize WF LOCAL tables)以及【工作流目录服务用户/职责验证】(Workflow Directory Services User/Role Validation)。
其次,检查Wf_Local_User_Roles.User_Name = ‘用户名‘的相关职责起始日期。
Select r.Application_Id, r.Responsibility_Id, Responsibility_Key, Responsibility_Name, u.Security_Group_Id, s.Security_Group_Key, r.Version, u.End_Date, r.End_Date From Fnd_Responsibility_Vl r, Fnd_User_Resp_Groups u, Fnd_Security_Groups s Where User_Id =0 --替换为实际用户ID And r.Application_Id = u.Responsibility_Application_Id And r.Responsibility_Id = u.Responsibility_Id And r.Version In (‘W‘, ‘4‘) And u.Security_Group_Id In (-1, s.Security_Group_Id) And s.Security_Group_Id >= 0 Order By r.Application_Id;
2. 用户添加职责后,在FORM页面可以看到该职责,但是在IE浏览器界面看不到该职责
首先,登录该用户,选择【编辑浏览器】--查询所有职责--看能否找到该职责,如果能够看到该职责,检查职责的状态是否为隐藏,将其显示。
其次,运行下列SQL看是否能找到该职责:
Select r.Application_Id, r.Responsibility_Id, Responsibility_Key, Responsibility_Name, u.Security_Group_Id, s.Security_Group_Key, r.Version From Fnd_Responsibility_Vl r, Fnd_User_Resp_Groups u, Fnd_Security_Groups s Where User_Id =0 --替换为实际用户ID And Sysdate Between u.Start_Date And Nvl(u.End_Date, Sysdate) And r.Application_Id = u.Responsibility_Application_Id And r.Responsibility_Id = u.Responsibility_Id And r.Version In (‘W‘, ‘4‘) And Sysdate Between r.Start_Date And Nvl(r.End_Date, Sysdate) And u.Security_Group_Id In (-1, s.Security_Group_Id) And s.Security_Group_Id >= 0 Order By r.Application_Id
如果能够找到则先清空IE缓存,最好清空COOKIE,然后再登录。
本文出自 “路漫漫其修远兮…” 博客,请务必保留此出处http://baser.blog.51cto.com/4153192/1551619
EBS 用户职责 不显示
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。