Friday, June 23, 2017

12.2 E-Business Suite - How To Enable FND: Debug / AF Logging When Login Is Not Possible


In this Document
Goal
Solution


APPLIES TO:

Oracle Applications Technology Stack - Version 12.2 to 12.2.3 [Release 12.2]
Information in this document applies to any platform.

GOAL

You may have a situation where you wish to enable FND Debug / AF Logging. The standard method to enable this type of debug is via profile options:
FND: Debug Log Enabled
FND: Debug Log Filename for Middle-Tier
FND: Debug Log Level
FND: Debug Log Module
However, in some circumstances you may be unable to login and set these profiles. This note explains the alternative method which is to enable the same level of debug via the Fusion Middleware configuration

SOLUTION

1/ Source the run file system environment file
2/ Backup file:
$INST_TOP/appl/admin/oacore_wls.properties
3/ Edit $INST_TOP/appl/admin/oacore_wls.properties and add the following lines. (adjust the variables accordingly)
AFLOG_ENABLED=true
AFLOG_LEVEL=statement
AFLOG_MODULE=%
AFLOG_FILENAME=/tmp/aflog.txt
4/ Re-start Middle tier services
5/ Reproduce the issue
6/ Collect the log file
7/ Disable logging by removing the lines which were addded to oacore_wls.properties and re-start services

No comments: