解决WF-MAILER发送慢的问题

在工作流邮件的发送过程中，有的邮件需要一天甚至更多的时间才能发送到。针对这个问题可以用如下方案来解决：

Applies to:
Oracle Workflow Cartridge - Version: 11.5.10
This problem can occur on any platform.

 

Symptoms
The Workflow Notification Mailer performance is too slow. Notification e-mails not sent to the recipient_role in time, even the test mail is having this problem. Some e-mail notifications are sent on the next day and some are sent out some hours later. In table wf_notifications the column mail_status remains 'MAIL', while status is 'OPEN' and with end_date and due_date null. wf_notification_out queue contains invalid data.

Solution
Please proceed as follows:

1. Stop the Workflow mailer

2. Recreate the wf_notification_out queue and recreat it out of the wf_notifications table by executing:

cd $FND_TOP/patch/115/sql
sqlplus APPS/ @wfntfqup.sql APPS APPLSYS

3. Start the mailer and test again.