5 Important Steps to debug Inbound Workflow Notification Issues in Oracle Apps

5 Important Steps to debug Inbound Workflow Notification Issues in Oracle Apps

In this post , We will be discuss about Inbound Workflow Notifications in oracle apps. Oracle Workflow Mailer is divided in to two parts 1) Inbound and 2) Outbound. For Outbound workflow , Oracle System sends email notifications  outside the system and In bound Responses against the Outer Notifications gets back to the oracle system through Inbound Workflow Mailer. Here today I will help to share some of the steps which will help to debug the inbound notification issues in the Oracle System.

Debugging Steps for Inbound Workflow Mailer

Step1:- Tracing the responded notification

The responded notification processing can be traced in the below sequence.

Check the STATUS column in WF_NOTIFICATIONS table  

 

Step2:- The notification status will be changed to CLOSED once the control returns back to the worklist and a message will be queued to WF_NOTIFICATION_IN queue with READY state          

            
select notification_id, status from wf_notifications where notification_id = <nid>;

Step3:- Check the message state in WF_NOTIFICATION_IN queue 

 

Step4:- The 'Workflow Inbound Notification Agent Listener' component processes the messages in WF_NOTIFICATION_IN queue and the message state will be changed to PROCESSED   

 

select win.user_data.GET_STRING_PROPERTY('NOTIFICATION_ID') NID, msg_state, enq_time, deq_time from applsys.aq$wf_notification_in win where win.user_data.GET_STRING_PROPERTY('NOTIFICATION_ID') = <nid>;

Ste5:- Check the notification activity status in WF_ITEM_ACTIVITY_STATUSES table                

 

The notification activity status will be COMPLETE once the message is processed by the 'Workflow Inbound Notification Agent Listener' component    

            

SELECT notification_id, activity_status FROM wf_item_activity_statuses where notification_id = <nid>;

Handling Errors

 

When there is any error occurs during the deferred response processing, WFERROR/NTF_DEFER_RESP_PROCESS_ERROR workflow process will be launched and an error notification will be sent to the Workflow Administrator role. The ERROR notification contains the information about the Error notification details, Error message and Error stack.