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

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

Leave a Reply

Your email address will not be published.