How to update GUID for SSO User in Oracle EBS

Extract the GUID for User from Oracle Access Manager (OAM) or OID (ldapsearch)

verify the guid column in the fnd_user table/view with below query :

select user_name,user_id,user_guid from fnd_user where user_name like '%RAJ%';

Now update the guid column in fnd_user with the value extracted above :

update fnd_user  set user_guid='8307ABAC21DAC08BE05016AC32EC512D' where user_name like '%RAJ%';

https://oracletechies-oracleworld.blogspot.com/2018/12/how-to-search-for-ldap-user-oid-user.html

Some Additional queries to check whether the user specified is properly defined in HRMS records (proper email address etc because that's where it pulls all the basic attributes from )

select * from per_all_people_f where email_address like '%RAJ%@xyz.com%';

select * from fnd_user  , per_all_people_f
where per_all_people_f.person_party_id=fnd_user.user_id;