Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Low-level Diagnostic Logging is turned on. This may temporarily reduce performance.

RamarajuFeb 10 2019 — edited Feb 9 2021

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

This post has been answered by Ramaraju on Mar 21 2019
Jump to Answer

Comments

Processing

Post Details

Added on Feb 10 2019
23 comments
556 views