Pages

OracleEBSpro is purely for knowledge sharing and learning purpose, with the main focus on Oracle E-Business Suite Product and other related Oracle Technologies.

I'm NOT responsible for any damages in whatever form caused by the usage of the content of this blog.

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs. I invite people to read and suggest ways to improve this blog.


Friday, April 12, 2013

Responsibilities assigned to the users are not shown

When a user is added a new responsibility or existing responsibility is end dated, it does not reflect immediately. One of the main reason is wf_local_user_roles and wf_user_role_assignment tables are not in sync. 
You can check the same by running the following query,
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));
If the above query returns any rows then the tables are not in sync. You can run the following update to correct the same(make backup of both the tables before udpating),
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)));
and then run the "Workflow Directory Services User/Role Validation" CP. 
This will fix the issue.
Reference: Metalink Note:466135.1

1 comment:


  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete