Query To Get Enabled Trace/Log/Debug Profile Options (Version 11.5.10.0 to 12.2 )
1. This will display values of profile options "FND: Debug Log Enabled" (AFLOG_ENABLED) and "Initialization SQL Statement - Custom'" (FND_INIT_SQL) at each level. If the values are respectively 'Y' and/or contains sql statement for these profile options then log and/or trace are enable for that level (which could be at site, user, ... level): set pagesize 200 col NAME for a25 col LEV for a6 col CONTEXT for a25 col VALUE for a50 col USER_PROFILE_OPTION_NAME for a37 select po.profile_option_name "NAME", po.USER_PROFILE_OPTION_NAME, decode(to_char(pov.level_id), '10001', 'SITE', '10002', 'APP', '10003', 'RESP', '10005', 'SERVER', '10006', 'ORG', '10004', 'USER', '???') "LEV", decode(to_char(pov.level_id), '10001', '', '10002', app.application_short_name, '10003', rsp.responsibility_...