Scribd
Upload
245 views3 pages

Troubleshoot Oracle Workflow Notification To Email

1. Verify the workflow notification mailer component status and check logs to identify any failed notifications. 2. Query the WF_NOTIFICATIONS table to check the status and mail status of notifications to identify any pending or failed deliveries. 3. Check the workflow queues to trace the status of pending notifications and identify any errors. 4. Review user notification preferences and email addresses to ensure they are configured correctly.

Uploaded by

kolluradiga123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
245 views3 pages

Troubleshoot Oracle Workflow Notification To Email

1. Verify the workflow notification mailer component status and check logs to identify any failed notifications. 2. Query the WF_NOTIFICATIONS table to check the status and mail status of notifications to identify any pending or failed deliveries. 3. Check the workflow queues to trace the status of pending notifications and identify any errors. 4. Review user notification preferences and email addresses to ensure they are configured correctly.

Uploaded by

kolluradiga123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Troubleshooting Workflow Notification Mailer Issues

Troubleshooting Workflow Notification Mailer Issues


Find Workflow Notification Mailer is up and Running?

SELECT component_name, component_status


FROM fnd_svc_components
WHERE component_type = 'WF_MAILER';

Workflow log’s: FNDCPGSC*.txt under $APPLCSF/$APPLOG directory

Find the Failed One’s?

Select NOTIFICATION_ID, MESSAGE_TYPE, MESSAGE_NAME, STATUS, MAIL_STATUS, FROM_USER,


TO_USER from wf_notifications where MAIL_STATUS='FAILED';

Check pending e-mail notification that was pending for process.

Sql> SELECT COUNT(*), message_name FROM wf_notifications


WHERE STATUS='OPEN'
AND mail_status = 'MAIL'
GROUP BY message_name;

Sql> SELECT * FROM wf_notifications


WHERE STATUS='OPEN'
AND mail_status = 'SENT'
ORDER BY begin_date DESC

Check the Workflow notification has been sent or not?

select mail_status, status from wf_notifications where notification_id=

--If mail_status is MAIL, it means the email delivery is pending for workflow mailer to send the
notification
--If mail_status is SENT, its means mailer has sent email
--If mail_status is Null & status is OPEN, its means that no need to send email as notification
preference of user is "Don't send email"
--Notification preference of user can be set by user by logging in application + click on preference +
the notification preference
1. Verify whether the message is processed in WF_DEFERRED queue

select * from applsys.aq$wf_deferred a where a.user_data.getEventKey()= ''


- notification id

2. If the message is processed successfully message will be enqueued to WF_NOTIFICATION_OUT queue,


if it errored out it will be enqueued to WF_ERROR queue

select wf.user_data.event_name Event_Name, wf.user_data.event_key Event_Key,


wf.user_data.error_stack Error_Stack, wf.user_data.error_message Error_Msg
from wf_error wf where wf.user_data.event_key = '
To check what all mails have went and which all failed ?

Select from_user,to_user,notification_id, status, mail_status, begin_date


from WF_NOTIFICATIONS where status = 'OPEN';

Select from_user, to_user, notification_id, status,


mail_status,begin_date,USER_KEY,ITEM_KEY,MESSAGE_TYPE,MESSAGE_NAME begin_date
from WF_NOTIFICATIONS where status = 'OPEN';

Users complain that notifications are stuck ?

Use the following query to check to see whatever the users are saying is correct

SQL> select message_type, count(1) from wf_notifications


where status='OPEN' and mail_status='MAIL' group by message_type;

E.g o/p of query -

MESSAGE_Type COUNT(1)
-------- ----------
POAPPRV 11 --- 11 mails of Po Approval not sent ---
INVTROAP 12
REQAPPRV 9
WFERROR 45 --- 45 mails have error

If Mail not received by User ?


select Name,DISPLAY_NAME,EMAIL_ADDRESS,NOTIFICATION_PREFERENCE,STATUS
from wf_users where DISPLAY_NAME=’xxx,yyy’ ;

Status – Active
Notification_preference-> Mailtext
Email Address should not be null

Notification not sent waiting to be mailed ?

SQL> select notification_id, status, mail_status, begin_date from WF_NOTIFICATIONS


where status = ‘OPEN’ and mail_status = ‘MAIL’;
To debug the notification id ?

$FND_TOP/sql
run wfmlrdbg.sql
******************************

Note: 1054215.1 - How to Check if the Workflow Mailer is Running


Note: 415516.1 - How to Check Whether Notification Mailer is Working or Not

Note: 831982.1 - 11i/R12 - A guide for troubleshoting Workflow Notification Emails - Inbound and
Outbound
Note: 1012344.7 - Notifications Not Being Sent In Workflow
Note: 560472.1 - Workflow Mailers Not Sending Notifications

Please see (Note: 753845.1 - How to Perform a Meaningful SMTP Telnet Test to Troubleshoot Java
Mailer Issues), the same error is reported in this doc.

You might also like