SQL> select count(*),status from wf_notifications group by status;
COUNT(*) STATUS
———- ——–
1530 CANCELED
1627 CLOSED
15266 OPEN
SQL> select count(*),status, MAIL_STATUS from wf_notifications group by
2 status, MAIL_STATUS order by status;
COUNT(*) STATUS MAIL_STA
———- ——– ——–
5 CANCELED ERROR
1031 CANCELED MAIL
427 CANCELED SENT
67 CANCELED
1 CLOSED ERROR
40 CLOSED SENT
1586 CLOSED
1 OPEN ERROR
1131 OPEN MAIL
3101 OPEN SENT
11033 OPEN
update wf_notifications
set mail_status = ‘SENT’
where status = ‘OPEN’;
commit;
$FND_TOP/sql/wfrmitms.sql (to delete status information in Oracle Workflow runtime tables for a particular item type),
$FND_TOP/sql/wfrmitt.sql (to delete all data in all Oracle Workflow design time and runtime tables for a particular item type).
and $FND_TOP/sql/wfrmall.sql (to delete all data in all Oracle Workflow design time and runtime tables for all item type).
