Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
SQL Query to get the username in Fusion Applications - Printable Version

+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips (http://www.oraerp.com/forum-12.html)
+--- Thread: SQL Query to get the username in Fusion Applications (/thread-71453.html)



SQL Query to get the username in Fusion Applications - Zishan Ali - 08-06-2015

1
select  FND_GLOBAL.USER_GUID, FND_GLOBAL.USER_NAME from dual
2
select sysdate, count(*), fsu.user_name, gvs.machine
from fusion.FND_SESSION_USERS fsu,
fusion.FND_SESSIONS fs, gv$session gvs
where fsu.USER_GUID=fs.USER_GUID
and fsu.user_name = gvs.client_identifier
and fs.last_connect > sysdate-1/3
group by fsu.user_name, gvs.machine;

3
How To Find Active User Sessions In Oracle Fusion Applications ? (Doc ID 1937418.1)