SSO USER SYNC Steps

 

USER SYNC IN PRODUCTION

 

1.       Login to PRD

System Administrator -> Security -> User

2.       Query the user

F11 -> Enter username -> Ctrl F11

 

If User does not exists, Check it in ODSM

 

3.       Login to ODSM

http://x1oama01.mnao.net:7012/odsm

 

Click Data Browser -> Enter the Username & Search

In the Name section if User exists. Click on User

Attributes-> Managed Attributes -> Show all

 

Scroll down to get the GUID of the user.

Note down the orclguid

 

To manually create the user Disable the profile option Application SSO LDAP Synchronization

 

Create the user manually with default password.

DO NOT ASSIGN ANY RESPONSIBILITY

 

Make the user SSO enabled

select user_name,user_guid from fnd_user where user_name in ('RKURLE');

 

Update the guid:

update fnd_user set user_guid='C1E20DE7A37F7841E050858875EDBD76' where user_name='RKURLE';

Commit;

 

SPPPRD> @/fileserver/scripts/sso_external.sql

Commit;

 

 

Check status of User

It should be External

 

Revert the Profile option Application SSO LDAP Synchronization

 

Note: DO NOT assign any responsibility in Production. Ask RACF team to assign responsibility, if any.