To Get Application User Login Session Details From Backend

SELECT

SUBSTR(d.user_name,1,30) "User Name"

,to_char(c.start_time,'DD-MON-RRRR HH:MI:SS AM') start_time

,to_char(c.end_time,'DD-MON-RRRR HH:MI:SS AM') end_time

FROM

fnd_logins c

, fnd_user d

WHERE 1=1

AND d.user_id = c.user_id

AND d.user_name IN ('RCHINTHAPATLA')

and c.START_TIME >= sysdate - 1

order by d.user_name, c.START_TIME desc

;

SELECT

SUBSTR(d.user_name,1,30) "User Name"

, a.pid

, b.sid

, b.serial#

, to_char(c.start_time,'DD-MON-RRRR HH:MI:SS AM') start_time

, to_char(c.end_time,'DD-MON-RRRR HH:MI:SS AM') end_time

FROM

  v$process a

, v$session b

, fnd_logins c

, fnd_user d

WHERE a.pid = c.pid

AND d.user_name = UPPER('RCHINTHAPATLA')

-- AND TO_DATE(c.start_time) = TO_DATE('&START_DATE')

AND d.user_id = c.user_id

AND a.addr = b.paddr

-- AND c.end_time IS NULL

;