Unable to see roles & responsibilities on EBS Home Page

 My user name which not synced is "JASON"

There are two methods to synchronize user data.

First Method :

This one is our usual method , which will be done by all our APPS DBA.

1. End date the user in front end and activate him again.

The action plan above should automatically re-syncs user/role data in the tables mentioned above. If issue still persists, do next step.

Second Method:

2)

a)  Run the Concurrent Program with the following parameters:

     "Workflow Directory Services User/Role Validation" Parameters : 100000, Yes, No, No

  

b)  Bounce Apache.

c)  Retest the issue , if not fixed move to step 4.

4. Verify Discrepancies in User/Role Data in Workflow Tables

Run below scriot to check discrepancy

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 we get more than zero rows then follow the below steps.

a) Backup the below tables

wf_local_user_roles

wf_user_role_assignments

b) Update both the wf_local_user_roles and wf_user_role_assignments tables with null values for the roles.

update wf_user_role_assignments

set user_end_date=null,

role_end_date=null,

assigning_Role_end_Date=null,

effective_end_Date=to_date('01-01-2023','dd-mm-yyyy')

where user_name=upper('JASON');

update wf_user_role_assignments

set user_end_date=null,

role_end_date=null,

assigning_role_end_Date=null,

effective_end_Date=to_date('01-01-2023','dd-mm-yyyy')

where role_name=upper('JASON');

update wf_local_user_Roles

set user_end_date=null,

role_end_date=null,

effective_end_Date=to_date('01-01-2023','dd-mm-yyyy')

where user_name=upper('JASON');

update wf_local_user_Roles

set user_end_date=null,

role_end_date=null,

effective_end_Date=to_date('01-01-2023','dd-mm-yyyy')

where role_name=upper('JASON');

Now I have tried to Login , It works.

Reference : Guideline for fixing Missing Responsibilities (Doc ID 2508139.1)