EBS User account unable to Autheticate in an SSO Integrated environment

Issue:
——
In an EBS-SSO integrated environment – The user Account is active in EBS and the SSO account is provisioned, but still unable to authenticate from the EBS-OAM login console.

Solution :
———-

1. Make sure the profile option “Applications SSO Login Types” is set to “SSO” at the “User” level.

2. Map the USER_GUID of FND_USER table in EBS with ORACLE_GUID of OID in SSO.

Extract oracle_guid from OID :

ldapsearch -h -p 3060 -D “cn=orcladmin” -s sub -L -b “cn=users,dc=xxxx,dc=com” -w “” “uid=scott” uid oracle_guid orclsamaccountname

Update in EBS:

SQL> conn apps/apps
SQL> update FND_USER set USER_GUID=”xxxxxxxxxxx” where USER_NAME=’SCOTT’;