1 2 Previous Next 23 Replies Latest reply on Mar 21, 2019 5:43 AM by Ramaraju

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

    Ramaraju
    Ramaraju Feb 11, 2019 2:32 AM

      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

      • 426 Views
      • Tags:
        1 2 Previous Next