Advanced Search

Return to Snippet

Revision: 52550
at October 26, 2011 06:51 by theonlyalterego
Updated Code 
select fp.level_id, fp.level_value, fp.profile_option_value,
fu.description 
,user_profile_option_name, fpo.profile_option_name
from fnd_profile_options_vl fpo
,fnd_profile_option_values fp
,fnd_user fu
where fpo.APPLICATION_ID = fp.application_id
and fpo.PROFILE_OPTION_ID = fp.profile_option_id
and fu.user_id = fp.last_updated_by
--and fpo.profile_option_name = 'AFLOG_ENABLED'
and fpo.user_profile_option_name = 'FND: Debug Log Enabled';

Revision: 52549
at October 26, 2011 06:40 by theonlyalterego
Initial Code 
select fp.level_id, fp.level_value, fp.profile_option_value,
fu.description
from fnd_profile_options_vl fpo
,fnd_profile_option_values fp,
fnd_user fu
where fpo.APPLICATION_ID = fp.application_id
and fpo.PROFILE_OPTION_ID = fp.profile_option_id
and fpo.profile_option_name = 'AFLOG_ENABLED'
and fu.USER_ID = fp.LAST_UPDATED_BY;
Initial URL 
https://forums.oracle.com/forums/thread.jspa?messageID=4017914
Initial Description 
A slight adaptation on the sql in the Oracle Forum
Initial Title 
Oracle - Find which users have FND Diagnostic profile value set
Initial Tags 
sql, Oracle
Initial Language 
SQL