User's GUID and OID update

                          Steps to update user's GUID

1. Find the current GUID of the user:

 

SQL> set lines 200
SQL> col USER_NAME for a40
SQL> select user_name,user_guid from fnd_user where user_name='Name';

USER_NAME                                USER_GUID
---------------------------------------- --------------------------------
Name                                              CB71E24AE410CF01E040020A1F8123AE

2. Check if there is a mismatch by running the script appusrguid.sql

SQL> @appusrguid.sql;

EBS / OID USER GUID

Enter value for description: <input user desc from front end>
old  20:        u.DESCRIPTION like '%&Description%'
new  20:        u.DESCRIPTION like '<user desc is displayed>'

EBS User        DESCRIPTION                    EBS GUID                            OID GUID
--------------- ------------------------------ -----------------------------------

Name               <desc>                                     C5DD6187FF                        CB71E24AE

3. Update the GUID

SQL> update fnd_user set user_guid='CB71E24AE' where user_name='Name';

SQL> Commit;

4. Now check if there is a mismatch:

 

SQL> @appusrguid.sql;

EBS / OID USER GUID

Enter value for description: <input user desc from front end>
old  20:        u.DESCRIPTION like '%&Description%'
new  20:        u.DESCRIPTION like '<user desc is displayed>'

EBS User        DESCRIPTION                    EBS GUID                            OID GUID
--------------- ------------------------------ -----------------------------------

Name               <desc>                                CB71E24AE                       CB71E24AE