It's a kind of rare requirement to change the username in EBS. This can be accomplished by using 2 methods.
- Either by using Front end.
- Or by using the Oracle Provided Package APPS.FND_USER_PKG.
It is not recommended to update any FND_USER column by using direct UPDATE SQL. Oracle uses this column to maintain the foreign key relationship with few WF tables(For Ex: WF_LOCAL_USER_ROLES)
- By using Front end.
Login to ERP --> System Administrator --> Security --> User --> Define. It launches Java form similar to the below screenshot.
Press F11, Enter the old username and search by using Ctrl + F11. Change the User Name field to New value. Don't forget to save.
2. By using FND_USER_PKG
begin
fnd_user_pkg.change_user_name(x_old_user_name => 'oldusername', x_new_user_name => 'new_user_name');
commit;
end;
/
This is really helpful when you are integrating EBS with OID or IDAM.
Press F11, Enter the old username and search by using Ctrl + F11. Change the User Name field to New value. Don't forget to save.
2. By using FND_USER_PKG
begin
fnd_user_pkg.change_user_name(x_old_user_name => 'oldusername', x_new_user_name => 'new_user_name');
commit;
end;
/
This is really helpful when you are integrating EBS with OID or IDAM.
No comments:
Post a Comment