Oracle Cloud ERP – Query to find the current logged in users

by admin

SELECT 
pu.username "LOGIN_USERNAME",
        pu.SUSPENDED,
 	pu.creation_date, 
        max(fs.LAST_CONNECT) "LAST_CONNECT",
max(fs.LAST_UPDATE_DATE) "LAST_UPDATE_DATE"

   FROM per_users pu,
        FND_SESSIONS fs
  WHERE 
    1=1
    AND pu.user_guid  = fs.user_guid
    AND trunc(fs.LAST_CONNECT)=trunc(SYSDATE) 

GROUP BY 
  pu.username,
  pu.SUSPENDED,
  pu.creation_date

ORDER BY pu.username DESC

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleSaaS