Wednesday, November 23, 2011

Finding out if ad-oid-EBS guid mismatch

SQL> select fnd_ldap_user.get_user_guid('PRABHAT') from dual ;

FND_LDAP_USER.GET_USER_GUID('PRABHAT')
--------------------------------------------------------------------------------
AB67FBA866329263E04023D823AF1C1B

SQL> select user_guid from fnd_user where user_name='PRABHAT';

USER_GUID
--------------------------------
AB67FBA866329263E04023D823AF1C1B


If there is difference is guid in both , then update the guid in fnd_user from what u get from first query .


No comments:

Post a Comment