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.
