2 Replies Latest reply: Aug 19, 2014 8:32 AM by Shailender Thallam RSS

    how to clear and close workflow notifications.

    2606175

      Hi Oracle,

       

      Can any one help how to clear and close all the notifications.

       

       

      SQL> select n.message_type, n.MESSAGE_NAME, n.status, count(n.notification_id) COUNT

          from wf_notifications n

         where n.end_date is null and status='OPEN'

         group by n.message_type, n.MESSAGE_NAME, n.status  2    3    4

        5  /

       

       

      MESSAGE_ MESSAGE_NAME                   STATUS        COUNT

      -------- ------------------------------ -------- ----------

      WFERROR  RESET_ERROR_MESSAGE            OPEN          56721

      OMERROR  OMERROR_MSG                    OPEN            621

      MY_TAID  TAID_MESSAGE_INFO              OPEN           2374

      GLBATCH  NOTIFY_PREPARER_OF_REJECTION   OPEN              5

      APVRMDER APPROVE_REL_REMAINDER          OPEN              1

      ECXERROR INTPMESSAGE                    OPEN             10

      OECHGORD ISO_LINE_QTY_DATE_UPDATE_MSG   OPEN              1

      UMXLHELP LOGIN_HELP_MSG_UNAME           OPEN              1

      CLN_NPNP CLN_STANDARD_MESSAGE           OPEN              1

      XXHIDPOA PO_PO_HAS_BEEN_APPROVE         OPEN            198

      FNDCMMSG REQ_COMPLETION_W_URL           OPEN           1171

       

       

      MESSAGE_ MESSAGE_NAME                   STATUS        COUNT

      -------- ------------------------------ -------- ----------

      XXHIDPOA PO_EMAIL_PO_PDF_WITH_RESPONSE  OPEN              1

      FUNRMAIN FIX_ACCT_DIST_MSG              OPEN              1

      POSREGV2 APPRV_REG_USER_MSG             OPEN              2

      FUNARINT ERROR_AR_SETUP_MSG             OPEN              3

      XXHIDPOA UNABLE_TO_APPROVE              OPEN              4

      APVRMDER APPROVE_REQ_REMAINDER          OPEN            182

      OECHGORD ISO_LINE_SCH_DATE_UPDATE_MSG   OPEN            265

      OEOH     XXHID_RMA_REJECTION_MSG        OPEN              1

      OEBH     BLANKET_TERMINATED_MSG         OPEN              1

      XXHIDPOA PO_PO_APPROVE_PDF              OPEN             25

      POSASNNB NOTIFY_BUYER                   OPEN              2

       

       

      MESSAGE_ MESSAGE_NAME                   STATUS        COUNT

      -------- ------------------------------ -------- ----------

      OEBH     BLANKET_PRE_EXPIRE_MSG         OPEN              9

      OEOH     HID NOTIFY CREATOR             OPEN              8

      OECHGORD ISO_LINE_CANCEL_MSG            OPEN             18

      AZNF003  AZN_MS_ROWORD                  OPEN              1

      WFTESTS  OAFWK_MSG                      OPEN              9

      WFTESTS  PLSQL_MSG                      OPEN              8

      OMERROR  OMERROR_MSG_NO_URL             OPEN            522

      REQAPPRV PO_REQ_APPROVED_JRAD           OPEN             48

      UMXLHELP LOGIN_HELP_MSG_PWD             OPEN              7

      MY_TAID  SENT_TAID_INFO                 OPEN              5

      WFMAIL   USER_PREF_UPDATE_REPORT        OPEN            236

       

       

      MESSAGE_ MESSAGE_NAME                   STATUS        COUNT

      -------- ------------------------------ -------- ----------

      FNDCMMSG SIMPLE_REQ_COMPLETION          OPEN             18

      OEOH     XXHID_RMA_APPROVAL_MSG         OPEN             31

      OECHGORD CHGORD_MSG                     OPEN              4

      GLBATCH  NOTIFY_PREPARER_OF_APPROVAL    OPEN             91

      OECHGORD ISO_LINE_ORD_QTY_UPDATE_MSG    OPEN              3

      POERROR  DOC_MANAGER_FAILED             OPEN              3

      CTOCHORD NOTIFICATION                   OPEN           8097

      APVRMDER APPROVE_PO_REMAINDER           OPEN            286

      REQAPPRV PO_REQ_APPROVE_JRAD            OPEN             81

      GLBATCH  VERIFY_AUTHORITY_FAILED        OPEN              5

      OEBH     BLANKET_EXPIRED_MSG            OPEN              8

       

       

      MESSAGE_ MESSAGE_NAME                   STATUS        COUNT

      -------- ------------------------------ -------- ----------

      GLBATCH  NO_MANAGER_RESPONSE            OPEN             14

      FUNAPINT AP_ERROR_MSG                   OPEN              6

      REQAPPRV PO_REQ_NO_APPROVER             OPEN              1

       

       

      47 rows selected.

       

      regards,

      prathap