EBS : SQL query to List the users on the system in the past N day

Solution:

select user_name,LAST_LOGON_DATE from FND_USER where USER_ID in ( select distinct user_id from icx_sessions where  last_connect > sysdate - N and user_id != '-N') order by 2;

Note: Substitute Value for N for the required number of days