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
ReplyDeleteRegards
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.