EBS : Changing FND User name in R12

 We can change the username for FND_USERS following below steps: 

1. Run below package to change in FND table.

/*<TOAD_FILE_CHUNK>*/
BEGIN
APPS.FND_USER_PKG.CHANGE_USER_NAME(
X_OLD_USER_NAME => 'ABHISHEK.C',
X_NEW_USER_NAME => 'ABHISHEK.G');
COMMIT;
END;
/

2. Change in Workflow tables.
exec WF_MAINTENANCE.PropagateChangedName('ABHISHEK.C','ABHISHEK.G');

select notification_id, begin_date, end_date, mail_status, status,recipient_role
from wf_notifications
where recipient_role like '%MOHAMMED.ALNASSER%'
/*<TOAD_FILE_CHUNK>*/