Pages

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