EBS 11i刪除Workflow Notifications(WF_NOTIFICATIONS)的unsent email

查出有未處理完成的mail
select notification_id, status, mail_status, begin_date
        from WF_NOTIFICATIONS
        where status = 'OPEN' and mail_status = 'MAIL';

的把WF_NOTIFICATIONS的欄位mail_status狀態update為sent
update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';

登入AP Server,執行wfntfqup.sql刪除WF_notifications_out表格裏的未處理mail
$ cd $FND_TOP/patch/115/sql/wfntfqup.sql
$ sqlplus  apps/XXXXX  @wfntfqup.sql  apps  [apps_password]  applsys;

參考資料
ID 372933.1 How to purge e-mail notifications from the workflow queue so the e-mail is not sent