Steps for getting The FND Debug Log For Concurrent request

Steps for getting The FND Debug Log For Concurrent request

1) From a System Administrator responsibility
Navigation path: Profile -> System

a) Set the following profile option at SITE level:
FND: Diagnostics -> Yes

b) Set the following profile options at USER level:
FND: Debug Log Module -> %
FND: Debug Log Enabled -> Yes
FND: Debug Log Level -> Statement

2) Run the concurrent request.

3) Upload the log and output files which can be found in the following UNIX directories:

cd $<product>_TOP/log

cd $<product>_TOP/out Both files can be found using the request_id.

4) Upload the spool file of the following script in an EXCEL spreadsheet with column headings for readability.
--- --- ---
SELECT log.module, log.message_text
FROM FND_LOG_MESSAGES LOG,
FND_LOG_TRANSACTION_CONTEXT CON
WHERE CON.TRANSACTION_ID = '&con_request_id'
AND CON.TRANSACTION_TYPE = 'REQUEST'
AND CON.TRANSACTION_CONTEXT_ID = LOG.TRANSACTION_CONTEXT_ID
ORDER BY LOG.LOG_SEQUENCE;
--- --- ---