Workflow Log file and troubleshoot

Workflow Log file location:
 -----------------------------------
Logs on CM Node at $APPLCSF/$APPLLOG/FNDC*.txt

To identify the 4 more recent log files for Workflow Mailer and Agent Listener services, run the following command:

# ls -lrt $APPLCSF/$APPLLOG/FNDCPGSC*.txt

Troubleshoot of WorkFlow:
===========================


Note:
How to Troubleshoot when the Workflow Services Go Down [ID 564394.1]
Troubleshooting Workflow Issues in Applications 11i [ID 266614.1]

1. Please advise at which time did mailer go down for the last time.

2. Upload the 4 more recent log files from $APPLCSF/$APPLLOG/FNDCPGSC*.txt

To identify the 4 more recent log files for Workflow Mailer and Agent Listener services, run the following command:

# ls -lrt $APPLCSF/$APPLLOG/FNDCPGSC*.txt

then upload the files.

3. Upload wfver.sql results
a. Go to $FND_TOP/sql
b. Start sqlplus connected as APPS schema user.
c. Run these commands:
spool wfver.txt
sta wfver.sql
spool off
d. Upload wfver.txt file generated.

4. For a notification that is not emailed:

a. Go to $FND_TOP/sql
b. Start sqlplus connected as APPS schema user.
c. Run this command:
start wfmlrdbg.sql <NID> <APPLSYS schema user> <APPLSYS's Pwd> where,
<NID>.................: Notification ID
<APPLSYS schema user>.: Default APPLSYS
<APPLSYS's Pwd>.......: Same password as APPS schema user
password.
d. Upload html file that is generated by the command execution.

If you don't know the notification id please execute:

SQL> select max(notification_id) from wf_notifications where status='OPEN'
and mail_status in
('MAIL', 'ERROR');