COLLECTING INFORMATION TO TROUBLESHOOT EBS WORKFLOW NOTIFICATION MAILER
=============================================================================
The following steps is to collect information for troubleshooting EBS WORKFLOW NOTIFICATION MAILER
DO NOT use SYSADMIN to send a test notification .. you have to use a different user NOT the SYSADMIN
1) Log in as the SYSADMIN
System Administrator > Application Manager > Workflow
Click on the Notification mailer
Click on View Details
Click on Test Mailer Icon
On the Recipient Role field > Select the Person having the issue from the list of Values (DO NOT SELECT SYSADMIN)
Click on Send Test Message Button
2) Navigate to Workflow Administrator Web Applications > Administrator Workflow> Status Monitor
In the Type Internal Name field type WFTESTS
Click Go
Select the TESTMAILER transaction
Click on Activity History
There are 2 notificaitons sent during the WFTESTS.
a. PLSQL Notification
b. OA Framework Notification
Click on the PLSQL Notification blue link .
At the bottom of the page is the Notification ID for this notification. Write the notification # down
Go back
Click on the OA Framework Notification
At the bottom of the page is the Notification ID for this notification. Write the notification # down
3) Using notification numbers from step 2, provide output of wfmlrdbg.sql script for each notification
How to Run Script wfmlrdbg.sql and Collect its Output? (Doc ID 1364300.1)
4) Provide EXCEL output of
select WFN.NOTIFICATION_ID, WFN.MESSAGE_TYPE, WFN.ITEM_KEY, WFN.MESSAGE_NAME, WFN.RECIPIENT_ROLE, WFN.ORIGINAL_RECIPIENT, WFN.RESPONDER, WFN.FROM_USER, WFN.TO_USER, WFN.STATUS, WFN.MAIL_STATUS, WFN.BEGIN_DATE, WFN.END_DATE, WFN.SENT_DATE, WFN.ACCESS_KEY, WFN.SUBJECT
FROM WF_NOTIFICATIONS WFN
WHERE WFN.BEGIN_DATE >= ‘<current_date>’
Order by WFN.NOTIFICATION_ID desc;
5) Upload the following part of the mailer log files from $APPLCSF/$APPLLOG/FNDCPGSC*.txt.
a. cd $APPLCSF/$APPLLOG/
b. grep ‘<Mon day, yyyy’ FNDCPGSC*.txt > SRnumber_Log.txt
c. Upload the output files LogXXXX.txt
6) Please also attach the following to identify any failures with the mailer:
On the concurrent tier, please upload the logs generated from the following commands:
grep “ERROR:” $APPLCSF/$APPLLOG/FNDCPGSC*.txt > SRnumber_ERRORS.log
grep “EXCEPTION:” $APPLCSF/$APPLLOG/FNDCPGSC*.txt > SRnumber_EXCEPTIONS.log
grep “UNEXPECTED:” $APPLCSF/$APPLLOG/FNDCPGSC*.txt > SRnumber_UNEXPECTED.log
7)Review the zip output files to diagnose the issue or attach the zip file to oracle service request.
######################################################################################
