To audit the changes in Profile Options in given number of days:-
---------------------------------------------------------------------------
If you want to know who made the changes to any profile option in certain days. Then use the following query.
SELECT 'Profile Option Name -->"'
|| a.user_profile_option_name
|| '"<-- Was Updated with value ' || '"' || b.profile_option_value || '"' || ' In The Last ' || &p_no_of_days || ' days' || ' by ' || (SELECT user_name FROM apps.fnd_user u WHERE u.user_id = b.last_updated_by) mesg FROM apps.fnd_profile_options_vl a, apps.fnd_profile_option_values b, apps.fnd_user c WHERE a.profile_option_id = b.profile_option_id AND b.last_updated_by = c.user_id AND ( b.last_update_date > SYSDATE - &p_no_of_days
OR b.creation_date > SYSDATE - &p_no_of_days
)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment