Run the following query to find out who are the Oracle Apps Users currently Logged into the application.<\/p>\n
SELECT DISTINCT icx.session_id,\r\n icx.user_id,\r\n fu.user_name,\r\n fu.description\r\n FROM icx_sessions icx, fnd_user fu\r\n WHERE disabled_flag != 'Y'\r\n AND icx.pseudo_flag = 'N'\r\n AND (last_connect +\r\n DECODE (fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'),\r\n NULL, limit_time,\r\n 0 , limit_time,\r\n fnd_profile.VALUE ('ICX_SESSION_TIMEOUT')\/60) \/ 24) > SYSDATE\r\n AND icx.counter < limit_connects\r\n AND icx.user_id = fu.user_id; <\/pre>\n","protected":false},"excerpt":{"rendered":"Run the following query to find out who are the Oracle Apps Users currently Logged into the application. SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description FROM icx_sessions icx, fnd_user fu WHERE disabled_flag != 'Y’ AND icx.pseudo_flag = 'N’ AND (last_connect + … Czytaj dalej