Oracle - Find which users have FND Diagnostic profile value set

/ Published in: SQL
Save to your folder(s)

A slight adaptation on the sql in the Oracle Forum

Copy this code and paste it in your HTML
  1. SELECT fp.level_id, fp.level_value, fp.profile_option_value,
  2. fu.description
  3. ,user_profile_option_name, fpo.profile_option_name
  4. FROM fnd_profile_options_vl fpo
  5. ,fnd_profile_option_values fp
  6. ,fnd_user fu
  7. WHERE fpo.APPLICATION_ID = fp.application_id
  8. AND fpo.PROFILE_OPTION_ID = fp.profile_option_id
  9. AND fu.user_id = fp.last_updated_by
  10. --and fpo.profile_option_name = 'AFLOG_ENABLED'
  11. AND fpo.user_profile_option_name = 'FND: Debug Log Enabled';


Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.