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

1 comment:

  1. Thanks for sharing, nice post! Post really provice useful information!

    Giaonhan247 chuyên dịch vụ vận chuyển hàng đi mỹ cũng như dịch vụ ship hàng mỹ từ dịch vụ nhận mua hộ hàng mỹ từ trang ebay vn cùng với dịch vụ mua hàng amazon về VN uy tín, giá rẻ.

    ReplyDelete