You are html tracking Visitor

Wednesday, August 6, 2008

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
)

No comments: