How to check who logged in Oracle Apps(EBS) Front End ?

 It is very common for DBA to check who logged into EBS application in order to take application down for some maintenance ... etc and make sure the system is idle.

Here is the query to see who is there on the system from backend, connect to database as APPS user and run the query.

I ran this query to see who logged in last one day, based on your requirement you can change it for hours as well.

 col user_name for a40

 select USER_NAME, to_char(LAST_LOGON_DATE, 'DD-MON-YYYY HH24:MI:SS') from fnd_user where last_logon_date > sysdate -1 order by USER_NAME;

USER_NAME        TO_CHAR(LAST_LOGON_DATE,'D

-----------      --------------------------

ABC.DEF          21-JUN-2021 09:48:28

GHI.JKL          21-JUN-2021 08:51:31

MNO.PQR          21-JUN-2021 10:18:14