End-Dating Applications User

End dating user - RAMESWARAM
---------------------------------------
1) Take backup of  fnd_user as
Login to MT server  as application user
sqlplus apps/<apps_pass>

SQL>CREATE TABLE FND_USER_BKP AS SELECT * FROM FND_USER;

SQL> select USER_NAME,CREATION_DATE,START_DATE,END_DATE from FND_USER where USER_NAME like '% RAMESWARAM%';

2) Run the below query to END_DATE user " RAMESWARAM"

SQL>update fnd_user set end_date='15-JAN-14′ where user_name like '% RAMESWARAM%';


Confirm again using the above query
-----------------------------------
SQL>select USER_NAME,CREATION_DATE,START_DATE,END_DATE from FND_USER where USER_NAME like '% RAMESWARAM%';

From FRONT END
==============
Login to Oracle Applications –
Select the System Administrator responsibility –
Security – User – Define – Query  the user name – then you can give end date in the Effectives Date To column.