Hi All,
Some one enabled 'Low-level Diagnostic Logging' and unable to disable it. Tried with following but still no luck.
DB: 12.1.0.2
APPS: R12.2.7
1. Login as a user with System Administrator responsibility and then navigate to: Profile > System.
Set the following profile option at the User level:
FND: Debug Log Enabled = No
2. Logout of the application. You may also want to clear the browser's cache.
3. Login again and confirm that the message no longer appears.
SQL> SELECT PROFILE_OPTION_ID,PROFILE_OPTION_NAME FROM FND_PROFILE_OPTIONS_VL
WHERE START_DATE_ACTIVE <= SYSDATE
and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
and ( SITE_ENABLED_FLAG = 'Y' or APP_ENABLED_FLAG = 'Y' or RESP_ENABLED_FLAG = 'Y' or USER_ENABLED_FLAG = 'Y' or SERVER_ENABLED_FLAG = 'Y' or SERVERRESP_ENABLED_FLAG = 'Y' or ORG_ENABLED_FLAG = 'Y')
and ( UPPER(USER_PROFILE_OPTION_NAME) LIKE '%FND%DEBUG%'
and (USER_PROFILE_OPTION_NAME LIKE '%f%' or USER_PROFILE_OPTION_NAME LIKE '%F%'))
order by user_profile_option_name;
Find value of profile:
Example:
PROFILE_OPTION_ID PROFILE_OPTION_NAME
----------------- -----------------------------------
4176 AFLOG_ENABLED
2.col profile_option_value for A20;
col profile_option_id for 999999999;
select PROFILE_OPTION_ID, PROFILE_OPTION_VALUE from FND_PROFILE_OPTION_VALUES
where profile_option_id in ('4176');
3.SQL> update FND_PROFILE_OPTION_VALUES
set PROFILE_OPTION_VALUE = 'N'
where PROFILE_OPTION_VALUE = 'Y'
and PROFILE_OPTION_ID = 4176;
For 12.2, review file: $INST_TOP/appl/admin/oacore_wls.properties.
AFLOG_ENABLED=
AFLOG_LEVEL=
AFLOG_MODULE=
AFLOG_FILENAME=
Thanks,
Ramaraju