Core Workflow - EBS (MOSC)

MOSC Banner

Purge Expired Notifications in Oracle Workflow

edited Jan 25, 2018 4:02AM in Core Workflow - EBS (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center