EBS用户禁用后再启用，无法出现职责的处理办法

最新推荐文章于 2021-09-30 22:52:27 发布

kikiwhq

最新推荐文章于 2021-09-30 22:52:27 发布

阅读量728

点赞数

EBS运维同时被 3 个专栏收录

64 篇文章 5 订阅

订阅专栏

Oracle

34 篇文章 1 订阅

订阅专栏

30 篇文章 0 订阅

订阅专栏

摘自：http://blog.csdn.net/samt007/article/details/13288299

Applies to:

Oracle Application Object Library - Version: 11.5.10 to
11.5.10.2
Information in this document applies to any platform.

Goal

Why is assigned responsibility not appearing in the navigator page
during login?

Solution

User data in the FND_USER, FND_RESPONSIBILITY,
WF_LOCAL_USER_ROLES, and WF_USER_ROLE_ASSIGNMENTS tables is not
valid. To synchronize data follow the steps
below:

1.  Navigate to the define
user form (FNDSCAUS).
2.  Query up the user (that is having the issue)
and insure the responsibility is NOT end dated.
3.  END DATE the USER (not the responsibility)
and save the record.
4.  UNEND DATE the USER and save
the record.
5.  Run the request 'Sync responsibility role data
into the WF table'.
6.  Run the request "Synchronize WF LOCAL
tables".
7.  Run the request "Workflow Directory Services
User/Role Validation" (with parameters 10000, yes, yes, yes).
8.  Have the user log off and
back on and verify that the responsibility appears.

转：http://www.xujiansheng.cn/2010/03/the-ebs-users-disable-and-then-enable-not-appear-duties-approach/

貌似这个是11i的处理办法。R12，第五步的请求不存在。

另外，如果职责没出现，那也有可能是职责被失效了。

SELECT * FROM FND_CONCURRENT_PROGRAMS_TL
WHERE 1=1
AND CONCURRENT_PROGRAM_ID IN (42845,46790)

另外一篇很好的文章：

http://hutianci.iteye.com/blog/1422545