Wednesday, May 21, 2014

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'
          ,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 ...

No comments:

Post a Comment