query application user end data in oracle applications 11i and R12

query application user end data in oracle applications 11i and R12


here we can not delete the user in oracle apps R12. 

instead of we can end date the user. 

we can use below query to find the end date of a user.


select user_name,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY,

START_DATE,END_DATE from fnd_user where user_name='SRIN500';

Comments

Popular posts from this blog

ORA-01565: error in identifying file '?/dbs/spfile@.ora'

Reboot Exadata Machine

How to combine Oracle .ova files