Monitor Profile Changes in Past 7 Days

--Script used to monitor application profile changes
--Threshold is the number of days to query for profile changes
--All profile changes that have occurred in the past 7 days
--will be displayed with the following query. -raj


select a.last_update_date
        ,(select user_name
          from fnd_user
          where user_id = a.last_updated_by) updated_by
        ,b.user_profile_option_name
        ,a.profile_option_value
        ,b.description
        ,b.application_id
from fnd_profile_option_values a,
       FND_PROFILE_OPTIONS_VL b
where a.last_update_date > (sysdate-7)
   and a.profile_option_id = b.profile_option_id
order by last_update_date desc, updated_by;