How to change user Name from backend

[ahmadbilal]

below is the procedure to change user name from back end
<b>
pass existing user name into From user name
pass new user name into to user name
fnd_user_pkg.change_user_name('From user name', 'to user name');</b>



begin
fnd_user_pkg.change_user_name('From user name', 'to user name');
exception
when others then
raise;
end;
/

[ghanshyamkhetan]

Hi ahmad,
After appling this procedure username will change but no responsibility is there. I want my all previous responsibilities.
I can change username also this query:
update fnd_user set username=newuser where username=oldusername;

Please advice.

[ahmadbilal]

Dear

Bug No. 4210838
Filed 28-FEB-2005 Updated 20-JUN-2006
Product Oracle Application Object Library Product Version 11.5.10
Platform AIX5L Based Systems (64-bit) Platform Version No Data
Database Version 9.2.0.5 Affects Platforms Generic
Severity Severe Loss of Service Status Closed, Duplicate Bug
Base Bug 4255173 Fixed in Product Version No Data

Problem statement:

CHANGING USERNAME LEAVES USER WITH NO RESPONSIBILITIES


secondly you can change user name by simple update query by updating fnd_user and fnd_grants

update fnd_grants
set grantee_key = x_new_user_name
where grantee_key = x_old_user_name
and grantee_type = 'USER';

but by using oracle recommended procedure you can have all updates in one go

[admin]

Dear Members,
But my request is that people should now leave thinking changing from back end in ERP's as if they will not stop doing this soon we will have to think to replace ERP's. If back end changes are required then better to have existing system don't move to any ERP. I hope message is clear. thanks