In R126.96.36.199 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 ?
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>