1. Number of Responsibilities assigned to users. Order by count desc.
============================================
select b.user_name,count(a.responsibility_id)
from fnd_user_resp_groups_direct a,
fnd_user b
where a.end_date is null and
a.user_id=b.user_id and
b.end_date is null
group by b.USER_name
order by 2 desc ;
============================================
2. Profile options changed in the last 3 days with user name, who changed that.
select
a.profile_option_id "ID",
a.profile_option_name "short_name",
c.user_profile_option_name "Full Name",
b.last_update_date "updated on",
b.last_updated_by "updated_by_ID",
d.user_name "Login_name"
from
fnd_profile_options a,
fnd_profile_option_values b,
fnd_profile_options_tl c,
fnd_user d
where
a.profile_option_id=b.profile_option_id
and
a.profile_option_name=c.profile_option_name
and
b.last_updated_by=d.user_id
and
b.last_update_date > (sysdate -3 )
order by 4 desc;
============================================
select b.user_name,count(a.responsibility_id)
from fnd_user_resp_groups_direct a,
fnd_user b
where a.end_date is null and
a.user_id=b.user_id and
b.end_date is null
group by b.USER_name
order by 2 desc ;
============================================
2. Profile options changed in the last 3 days with user name, who changed that.
select
a.profile_option_id "ID",
a.profile_option_name "short_name",
c.user_profile_option_name "Full Name",
b.last_update_date "updated on",
b.last_updated_by "updated_by_ID",
d.user_name "Login_name"
from
fnd_profile_options a,
fnd_profile_option_values b,
fnd_profile_options_tl c,
fnd_user d
where
a.profile_option_id=b.profile_option_id
and
a.profile_option_name=c.profile_option_name
and
b.last_updated_by=d.user_id
and
b.last_update_date > (sysdate -3 )
order by 4 desc;
