Purge Expired Notifications in Oracle Workflow
Hi,
I have few expired notification in my oracle e-business suite application and it is not getting purged even after running Purge Obsolete Workflow Runtime Data program. Kindly tell me how to remove the same.
SQL> select corr_id , msg_state, retry_count, count(Msg_id) "MSG Count"from applsys.aq$wf_notification_outwhere msg_state != 'PROCESSED'and trunc(ENQ_TIME) > to_date('01-SEP-2011','DD-MON-YYYY')group by msg_state,corr_id,retry_countorder by 2; 2 3 4 5 6CORR_ID MSG_STATE RETRY_COUNT MSG Count-------------------------------------------------- ---------------- ----------- ----------APPS:ENGCSTEP:REQUEST_COMMENT_REMINDER_FRM2 EXPIRED 6 3APPS:POSCHORD:NOTIFY_BUYER_OF_CHANGE EXPIRED 6 4APPS:POSCHORD:NOTIFY_SUP_CHN_FINAL_RESULT EXPIRED 6 7APPS:REQAPPRV:PO_REQ_APPROVED_JRAD EXPIRED 6 1APPS:REQAPPRV:PO_REQ_APPROVE_JRAD EXPIRED 6 3APPS:APPEWF:MESSAGE_TO_SUPPLIERS READY 18APPS:FNDCMMSG:REQ_COMPLETION_W_URL READY 3APPS:FNDCMMSG:SIMPLE_REQ_COMPLETION READY 2APPS:POAPPRV:EMAIL_PO_PDF READY 119 rows selected.
0