Find FND_PROFILE's changed by specific USER

Hi All ...

Here the small sql that will help you to find which FND_PROFILE's were changed by specific USER on your EBS instance.

select fpot.user_profile_option_name , decode(fpov.level_id,10001,'SITE'

          ,10002,'APPLICATION'

          ,10003,'RESPONSIBILITY'

          ,10004,'USER') Profile_Level , fpov.profile_option_value , fpov.last_update_date

          from fnd_profile_options fpo

               , fnd_profile_options_tl fpot

               , fnd_profile_option_values fpov

          where fpo.profile_option_name = fpot.profile_option_name

          and  fpo.profile_option_id  = fpov.profile_option_id

          and fpov.last_updated_by = (select user_id from fnd_user

          where user_name  = '&USERNAME')​

Good Luck ...