20090929

Filled Under:

Audit the changes in Profile Options in given number of days

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
)





0 comments:

Post a Comment