Oracle EBS: workflow通知信持續退信之解決方法

當workflow的通知信未正常完成寄送時(例如email失效), 會一直重試並退信, 最單純的解決方式, 是修正email.

另一個方法是找出notification, 修改status, 再執行script清mail queue.

1.查看資料

  select * from wf_notifications

   where notification_id =95536469

2.更改狀態
  update wf_notifications
     set mail_status = 'SENT' where notification_id =95536469
     and mail_status = 'INVALID'

3.執行script清除queue(先以sqlplus連上DB)
  @$FND_TOP/patch/115/sql/wfntfqup.sql <APPSusr> <APPSpw> <FNDusr>


註1: 第3項要telnet到server再執行
註2: FNDusr為applsys


Ref:
1.How To Purge E-Mail Notifications From The Workflow Queue So The E-Mail Is Not Sent (Doc ID 372933.1)

2.How To Purge E-Mail Notifications From The Workflow Queue So The E-Mail Is Not Sent
https://oracleappsfusion.wordpress.com/2014/09/30/how-to-purge-e-mail-notifications-from-the-workflow-queue-so-the-e-mail-is-not-sent/