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...