Active users from fnd_user in Ebiz R12 and 11i

You can find active users from fnd_user who has end_date greater than today’s date by issuing below query:

SELECT USER_NAME, EMAIL_ADDRESS, END_DATE FROM apps.fnd_user WHERE trunc(SYSDATE) BETWEEN trunc(start_date) AND * nvl(end_date,trunc(SYSDATE));