This discussion is archived
1 Reply Latest reply: Sep 2, 2012 11:10 PM by 654739 RSS

Canceled Notifications

800816 Newbie
Currently Being Moderated
Hi,

In R11.5.10.2 we are having difficulty in getting notification response in a custom workflow. Both the notification and its message uses standard 'APPROVAL' result type.

Here is the situation;

The workflow status is completed. But the workflow route is totally wrong. When i check activity history on status monitor; some steps are skipped.

The client claims that he responded Approve for the selected notification.

But when i check the wf_notifications table the status is 'CANCELED' and MAIL_STATUS is SENT, but the responder column is empty.
Result type seems 'FORCE'. As I check the notification there is no XML error, and the performer is valid.

He said that they are facing this issue especiialy with responses from their mail accounts not from their worklist. Are they any patches or some other columns i should check ?

Thank you.
  • 1. Re: Canceled Notifications
    654739 Newbie
    Currently Being Moderated
    Hi,

    Can you please provide us with the output of following scripts:

    1. $FND_TOP/sql/wfmlrdbg.sql for the notification having problem.
    Usage: sqlplus apps/apps @wfmlrdbg.sql <nid>

    2. $FND_TOP/sql/wfstat.sql
    Usage: @wfstat <item_type> <item_key>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points