How to Resend OPEN, CANCELLED Workflow Notification mails

How to Resend OPEN, CANCELLED Workflow Notification mails

• Many notification mailers stuck in the mailer queue (status=’OPEN’ and mail_status=’MAIL’)
• SQL> select count(*) from wf_notifications where status=’OPEN’ and mail_status=’MAIL’;
• select notification_id, status, mail_status, subject, from_user, begin_date from WF_NOTIFICATIONS where status = ‘OPEN’ and mail_status = ‘MAIL’;
• Oracle Workflows notifications cannot be sent due to mail server problems, network problems
• We can resend the notifications by doing the following:
• 1) stop workflow mailer
• 2) cd $FND_TOP/patch/115/sql
• 3) sqlplus APPS/<pwd> @wfntfqup.sql APPS <pwd> APPLSYS
• 4) start workflow mailer and monitor the queue