Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: SQL Query to get the username in Fusion Applications
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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)