Useful OAM Info

Query for System Profile Changes:

select a.profile_option_name,
          b.profile_option_value,
          c.user_name
from apps.fnd_profile_options 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 -7;

==============================
$FND_TOP/sql/afcmrrq.sql can be executed from the admin node as apps user
============================