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