How to purge Old Email Notification from workflow data in R12.2
SQL> select count(*),status from wf_notifications group by status; COUNT(*) STATUS ---------- -------------- 2018 CLOSED 35607 CANCELED 7390 OPEN SQL> select count(*),status, MAIL_STATUS from wf_notifications group by status, MAIL_STATUS order by status; COUNT(*) STATUS MAIL_STA ------------------------------------------------ 3 CANCELED ERROR 35604 CANCELED 12 CLOSED ERROR 1921 CLOSED SENT 86 CLOSED 444 OPEN ERROR 2 OPEN FAILED 40 OPEN MAIL 895 OPEN SENT 6008 OPEN 10 rows selected. SQL> update WF_NOTIFICATIONS set status = 'CLOSED', mail_status = 'SENT', end_date = sysdate where recipient_role='SYSADMIN'; SQL> Commit; Reference: How To Purge E-Mail Notifications From The Workflow Queue So The E-Mail Is Not Sent (Doc ID 372933.1) How to s