Alert Notification sends multiple emails
Hi,
We have this alert that will send an email notification after an update in PO_HEADERS_ALL. This alert checks if the PO is in approved status and will send the notification but sends multiple emails with the same details. Do you have any idea to avoid this scenario? See the below conditions of the alert for your reference.
Suppress duplicate was also checked for this alert.
FROM po_headers_all pha
, po_distributions_all pda
, po_requisition_headers_all prha
, po_requisition_lines_all prla
, po_req_distributions_all prda
, ap_suppliers asp
, per_all_people_f papf