Troubleshooting /Responsibilities Missing After They Have Been Assigned to a User on 11i / Release 12:

Responsibilities Missing After They Have Been Assigned to a User [ID 466135.1]

Troubleshooting Missing Responsibilities For A User [ID 429852.1]

1. Ensure both workflow services are running, the Workflow Deferred Agent Listener and Workflow Java Deferred Agent Listener.

Run the following code to get status of Listeners:

SQL> SELECT c.component_name, c.component_status from fnd_svc_components c where upper (c.component_name) in ('WORKFLOW DEFERRED AGENT LISTENER', 'WORKFLOW JAVA DEFERRED AGENT LISTENER');

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

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

Note : If the above script returns any rows then Proceed next:

3). You must take a backup of the two tables :

WF_LOCAL_USER_ROLES

and

WF_USER_ROLE_ASSIGNMENTS

Note:

SQL> create table WF_LOCAL_USER_ROLES_BKP as select * from WF_LOCAL_USER_ROLES;

SQL> create table WF_USER_ROLE_ASSIGNMENTS_BKP as select * from WF_USER_ROLE_ASSIGNMENTS;

Count both tables have same values on BKP tables

4). Run the following update script to correct the discrepancy :

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

                                                 

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

       Workflow Directory services user/role validation with argument values as 10000:Yes:Yes:No:NULL

Synchronize Workflow views

Log on to Oracle E-Business Suite with the "System Administrator" responsibility. Click Requests > Run > Single Request and the OK button. Enter the following parameters:

o             Request Name = Workflow Directory Services User/Role Validation

o             Batch Size = 10000

o             Fix dangling users = Yes

o             Add missing user/role assignments = Yes

o             Update WHO columns in WF tables = No

Click "OK" and "Submit".

+++++++++++++++++++++

1511839.1 &  548918.1

+++++++++++++++++++++