Responsibilities missing in Oracle Applications

Some Tested hints

1. Make sure that the latest ATG_RUP patch has been applied.
2. Run Concurrent Program System: Administrator Responsibility->Request->'Synchronize WF LOCAL tables'
3. Run Concurrent Program: 'Workflow Directory Services User/Role Validation'. (with the parameters 10000,Y,N,N and 10000,N,Y,N)
4. Restart the Workflow Agent Listeners: WF_DEFERRED and WF_JAVA_DEFERRED

Check the responsibilities for the user, if the issue still exist do the following steps

1). Run the following script to check if there is a discrepancy between the tables:

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 script returns any rows, proceed to the next step.

2) One must take a backup of the two tables :

WF_LOCAL_USER_ROLES
and
WF_USER_ROLE_ASSIGNMENTS

3) Run the following update script to correct the discrepancy :

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)));


4) Run the "Workflow Directory Services User/Role Validation" concurrent program to resolve the issue.

5. Re-test the issue.