Monday, September 9, 2013

Query to find details of User Profile (who and When updated)














SET lines 160;
SET pages 1000;
  SELECT t.user_profile_option_name,
         profile_option_value,
         v.creation_date,
         v.last_update_date,
         v.creation_date,
         v.last_update_date "ChangeDate",
        (SELECT UNIQUE user_name
           FROM fnd_user
          WHERE user_id = v.created_by) "Created By",
        (SELECT user_name
           FROM fnd_user
          WHERE user_id = v.last_updated_by) "LastUpdatedBy"
    FROM fnd_profile_options o,
         fnd_profile_option_values v,
         fnd_profile_options_tl t
   WHERE o.profile_option_id = v.profile_option_id
     AND o.application_id = v.application_id
     AND start_date_active <=SYSDATE
     AND NVL(end_date_active,SYSDATE)>=SYSDATE
     AND o.profile_option_name =t.profile_option_name
     AND level_id = 10001
     AND t.LANGUAGE IN(SELECT language_code
                         FROM fnd_languages
                        WHERE installed_flag ='B'
                        UNION
                       SELECT nls_language
                         FROM fnd_languages
                        WHERE installed_flag ='B')
   ORDER BY user_profile_option_name;

0 Responses to “Query to find details of User Profile (who and When updated)”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.