LIST OF ALL ACTIVE USERS ALONG WITH THEIR ACTIVE RESPONSIBILITIES
Introduction: This query is used to get all active users along with their active responsibilities.
SQL Query:
Execute the below query into EBS database:
Select fu.user_name,fu.EMAIL_ADDRESS,fu.DESCRIPTION,
fu.start_date USER_START_DATE,
fu.END_dATE USER_END_dATE,frt.responsibility_name,
furg.START_DATE RESP_START_DATE,
furg.END_DATE RES_END_DATE
from fnd_user_resp_groups_direct furg,
fnd_user fu, fnd_responsibility_tl frt
where furg.user_id = fu.user_id
and furg.responsibility_id = frt.responsibility_id
AND ((furg.END_DATE IS NULL or furg.END_DATE>sysdate)
AND (fu.END_DATE IS NULL or fu.END_DATE>sysdate))
AND frt.language=’US’
order by fu.user_name;
Conclusion: This SQL query provides information about all active users along with their active responsibilities.
