Below sql script to check if any Debug or Trace profile options have been set to Y in Oracle ERP application,
select distinct
a.application_short_name app_short,
user_profile_option_name optname,
decode(level_id,
10001,’SITE’,
10002,’APP : ‘||a2.application_short_name,
10003,’RESP: ‘||r.responsibility_key,
10004,’USER: ‘||u.user_name,
‘Unknown’) d_level,
profile_option_value optval,
v.last_update_date updated
from apps.fnd_profile_options_vl o,
apps.fnd_profile_option_values v,
apps.fnd_application a,
apps.fnd_application a2,
apps.fnd_responsibility r,
apps.fnd_user u
where (
o.user_profile_option_name like ‘%Debug%’ or
o.user_profile_option_name like ‘%DEBUG%’ or
o.user_profile_option_name like ‘%Trace%’ or
o.user_profile_option_name like ‘%TRACE%’
)
and a.application_id = v.application_id
and o.application_id = v.application_id
and o.profile_option_id = v.profile_option_id
— Find the associate level for profile
and r.application_id (+) = v.level_value_application_id
and r.responsibility_id (+) = v.level_value
and a2.application_id (+) = v.level_value
and u.user_id (+) = v.level_value
and profile_option_value = ‘Y’
order by 2,1,3,4;
