By using the following query we can get number of profile option changed along with new values in given number of daysConnect as apps user to instance
SELECT '***Profile Option Name ***'
a.user_profile_option_name
'*** Was Updated with value '
'"'
b.profile_option_value
'"'
' In The Last '
&p_no_of_days ' days'
' by '
(SELECT user_name
FROM apps.fnd_user u
WHERE u.user_id = b.last_updated_by) mesg
FROM apps.fnd_profile_options_vl a
,apps.fnd_profile_option_values b
,apps.fnd_user c
WHERE a.profile_option_id = b.profile_option_id
AND b.last_updated_by = c.user_id
AND ( b.last_update_date > SYSDATE - &p_no_of_days
OR b.creation_date > SYSDATE - &p_no_of_days)
