查詢 form session timeout
資料來源:這裡
SELECT disabled_flag, TO_CHAR(first_connect, 'MM/DD/YYYY HH:MI:SS') start_time, TO_CHAR(SYSDATE, 'HH:MI:SS') current_time, user_name, session_id, ROUND((SYSDATE - last_connect) * 24 * 60) mins_idle, fnd_profile.value_specific('ICX_SESSION_TIMEOUT', a.user_id, a.responsibility_id, a.responsibility_application_id, a.org_id, NULL) timeout FROM icx_sessions a, fnd_user b WHERE a.user_id = b.user_id AND last_connect > SYSDATE - 1 / 24; |