Saturday, December 11, 2010

enable or disable low-level logging

Enable low-level logging

1. change system profile FND: Debug Log level from unexpected to statement
2. change system profile FND: Debug Log Enabled from No to Yes.

When testing begins, run following:

Select max(log_sequence) from apps.fnd_log_messages

When testing ends, run:
Above again.

Then run

Select * from apps.fnd_log_messages where log_sequence between {from} to {to} and messages_text like ‘PrintAM%’

Above is trouble-shooting java class PrintAM.

The other choice is to use TIMESTAMP.

Reset back to original values for the system profiles after testing as there are performance impacts.

No comments:

Post a Comment