Wednesday, February 27, 2019

Unable To Generate Fnd Debug Logfiles And No Messages Are Writing To Fnd_log_messages

Dear Folks,

One of 12.2.4 customer facing issue several times to generate fnd log messages after the FND Diagnostics Profile is Set to 'Yes' at the Site Level.

It returns no rows in fnd_log_messages.

SQL> select count(*) from apps.fnd_log_messages;

 COUNT(*)
----------
     0

SQL> select max(LOG_SEQUENCE) from fnd_log_messages;

MAX(LOG_SEQUENCE)
-----------------


As per ML:: 2007068.1, We applied patch 22563940. Then issue resolved.

Expected Behavior
Expect FND Debugging to write to the fnd_log_messages tables.

The issue can be reproduced at will with the following steps:
1. Set FND Debugging

The issue has the following business impact:
Due to this issue, dba/appsdba cannot enable fnd debugging.

Now they are able to see rows in fnd_log_messages table.

Thanks.
Sreeharsha.



No comments:

Post a Comment