Recently we'd an issue with one of EBS user who receiving high volume of Emails from workflow around 4000 Emails. Hence we dig the issue deeper by logged in to workflow accout and identified bunch of Undeliverable emails in process folder. Below we could see the message.
Undeliverable: Closed: Aacksonville Aviation Sector- Standard Purchase Order 39535, 0"
So We opened email attachments and found few emails are invalid as below and and NID::442082 mail_status is INVALID and and status is CLOSED.The issue is caused by the mailer processing INVALID responses for CLOSED notifications.
Your message to samathar.b.kaakkt@ciecouldn't be delivered
Your message to mike.c.kakkat@cie.com couldn't be delivered.
Your message to pallu.p.deckler@cie.com couldn't be delivered.
SQL> select RECIPIENT_ROLE,STATUS,MAIL_STATUS,FROM_USER,TO_USER from wf_notifications where NOTIFICATION_ID =442082;
The supplier "Join Controver INC" having 4-Emails to which notifications are being sent.
The EBS user who having valid Email and other 3 emails are invalid. So workflow is retrying 2-3 minutes to resend the undeliverable emails and hence volume. Since one EBS user email is correct. He/She receiving bunch of undelierable email notifications every couple of minutes.
To over come the issue, we set mail_status to NULL. However we need to ask client those emails should be corrected by payable / Procurement team. Otherwise any further Purchase Orders that are communicated to that supplier without invalid emails to be corrected will cause this issue again.
Solutions
=====
Mark Mail_status to NULL in wf_notifications for particular NID which having issue.
update wf_notifications set mail_status='NULL' where notification_id=442082
OR please follow solutions that refers in below document.
