12/5/2019 · Find that in some cases, Purchase Order (PO) notifications to suppliers end up with MAIL_STATUS = FAILED in the WF_NOTIFICATIONS table. It is not known the exact pattern when these cases occur. STEPS—–The issue can be reproduced at will with the following steps.
11/13/2019 · Workflow notification table wf_notifications workflow status open but if we check the mail_status failed ,but before it was working fine. Found solution on oracle support Getting A Failed Mail Status On Workflow Notifications For Purchase Order Emails to Suppliers (Doc ID 1101820.1), 9/28/2013 · Workflow Notifications Status ‘FAILED’ checking status. 1. Check workflow mailer service current status . sqlplus apps/ select running_processes from apps.fnd_concurrent_queues where concurrent_queue_name = ‘WFMLRSVC’ Number of running processes should be greater than 0. 2.
12/3/2019 · Why Notifications in WF_NOTIFICATIONS have mail_status NULL and Status OPEN (Doc ID 1549691.1) Last updated on DECEMBER 03, 2019. Applies to: Oracle Workflow – Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2], 6/26/2012 · 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’.
2/26/2018 · Query to check Failed WF Notifications. SQL>Select NOTIFICATION_ID, MESSAGE_TYPE, MESSAGE_NAME, STATUS, MAIL_STATUS, FROM_USER, TO_USER from wf_notifications where MAIL_STATUS = ‘FAILED’ SQL> Query to find the ‘Pending’ WF Notifications waiting to be processed, Here is a more robust script for monitoring the wf_notifications table: select message_type, mail_status, count(*) from wf_notifications where status = ‘OPEN’ GROUP BY MESSAGE_TYPE, MAIL_STATUS messages in ‘FAILED’ status can be resent using the concurrent.
5/10/2013 · select *–distinct trunc (begin_date) from wf_notifications. where 1=1. and trunc (begin_date) mail_status = ‘FAILED’. and status = ‘OPEN’. order by trunc (begin_date) desc. 3> Run the concurrent program ‘Resend Failed/Error …
