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)

Adcfgclone Fails while instantiating OHS Config - Trying to access DMZ

 /u01/TEST/R12apps/fs2/inst/apps/TEST_Mars/admin/log/clone/patch/txkSetOHSConfig_01567873/provision_01567873.log

Error :

=======

Connecting Run file system WLS domain using t3://Mars.Jayan.int:7006

WARNING: Run file system MBeanServerConnection is invalid

Looks like Run file system WLS domain MBeanServerConnection is unavailable!!!

Trying to read managed server name and host:port info from Patch context file available in fnd_oam_context_files table

For RUN file system Server Name, Listen Address:Listen Port map from database {=dmzMars.Jayan.int:, oacore_server2=dbfin

sfnyp01.Jayan.int:7207, oacore_server1=Mars.Jayan.int:7206, oacore_server3=dmzMars.Jayan.int:7215, f

orms-c4ws_server2=dmzMars.Jayan.int:7815, oafm_server2=dmzMars.Jayan.int:7615, forms-c4ws_server1=dbfinsfn

yp01.Jayan.int:7806, oafm_server1=Mars.Jayan.int:7606, forms_server1=Mars.Jayan.int:7406, forms_serv

er2=dmzMars.Jayan.int:7415}

For RUN file system Server Name, Listen Address:SSL Listen Port map from database {=dmzMars.Jayan.int:}

Populating map where key is host:port and value is managed server name

ERROR: Failed to populate map where key is host:port and value is managed server name

ERROR: String index out of range: -1

Cause :

=======

After database clone , while continuing with adcfgclone on appstier its trying to access DMZ node (dmzMars) which is not available or does not exist actually.

Solution:

==========

To overcome this error please follow the below steps.

1.  Backup the below files on Application Tier.

    create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;

    create table fnd_nodes_bk as select * from fnd_nodes;

    create table adop_valid_nodes_bk as select * from adop_valid_nodes;

    If on ADK/TXK 8 or higher please include below query also.

    create table ad_nodes_config_status_bk as select * from ad_nodes_config_status;

2.  Truncate the below tables.

    truncate table fnd_oam_context_files;

    truncate table fnd_nodes;

    truncate table adop_valid_nodes;

    If on ADK/TXK 8 or higher please include below query also.

    truncate table ad_nodes_config_status;

3.  Run autoconfig on database Tier

    cd $ORACLE_HOME/appsutil/scripts/TEST_MARS/    

    sh adautocfg.sh

4.  Run Autoconfig on Application Tier

    cd $ADMIN_SCRIPTS_HOME

    sh adautocfg.sh

    Now rerun the adcfgclone on apps Tier , It completed Normal.

Reference : How to Synchronize the AD tables FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 when adop fails. (Doc ID 2064223.1)