查出有未處理完成的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
arrow
arrow
    全站熱搜

    keven 發表在 痞客邦 留言(0) 人氣()