Show me all active ebiz users who have logged into a forms based responsibility in the last 6 months.....

Show me all active ebiz users who have logged into a forms based responsibility in the last 6 months.....

If you are upgrading JREs, or just want to know who uses forms based responsibilities, here's a sample SQL. Note, it assumes you have auditing switched on at the form level.

SELECT lower(user_name)
  FROM fnd_user e
 WHERE trunc(sysdate) < nvl(end_date,sysdate+1) 
   AND EXISTS
    (SELECT 'x'
       FROM apps.FND_USER_RESP_GROUPS_DIRECT a,
            apps.fnd_responsibility_tl b,
            fnd_responsibility b1,
            FND_LOGIN_RESPONSIBILITIES fl,
            FND_LOGINS U
      WHERE a.end_date is null --active responsibility
        AND b.language = 'US'
        AND a.responsibility_id = b.responsibility_id
        AND b1.responsibility_id = b.responsibility_id
        AND b1.application_id = b.application_id
        AND b1.version = '4'  --forms based responsibilities
        AND e.user_id = a.user_id 
        AND fl.responsibility_id = b.responsibility_id
        AND fl.login_id = u.login_id
        AND fl.resp_appl_id = b1.application_id
        AND trunc(fl.start_time) > trunc(sysdate-185)) -- 6 months