Workflow Notification Mailer Trouble Shooting in Oracle APPS

Workflow Notification Mailer Trouble Shooting in Oracle APPS


Hi Friends, in this post we will discuss about Workflow Notification mailer debugging steps and trouble shooting steps in Oracle Apps.

Step1:- We can see all workflow notification in This below Tables.

Select * From Wf_Notifications

If you want to see the open notifications which are pending for user action then you can use below query.


Select * From Wf_Notifications
WHERE STATUS=’OPEN’


If you want to see the open notifications which are pending for user action and those Email notification still pending to deliver then you can use this below query

Select * From Wf_Notifications
WHERE STATUS=’OPEN’
AND mail_status = ‘MAIL’

if you want to see the open notifications which are pending for user action and those Email notification are delivered then you can use this below query


if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.


Select * From Wf_Notifications
WHERE STATUS=’OPEN’
AND mail_status = ‘SENT’

if you want to see the open notifications whose Email notifications Failed to get delivered then you can use below query.

Select * From Wf_Notifications
WHERE STATUS=’OPEN’
AND mail_status = ‘FAILED’


If mail_status is MAIL, it means the email delivery is pending for workflow mailer to send the notification
–If mail_status is SENT, its means mailer has sent email
–If mail_status is Null & status is OPEN, its means that no need to send email as notification preference of user is “Don’t send email”

Verify whether the message is processed in WF_DEFERRED queue

select * from applsys.aq$wf_deferred a where a.user_data.getEventKey()= :NOTIFICATION_ID

2. If the message is processed successfully message will be enqueued to WF_NOTIFICATION_OUT queue, if it errored out it will be enqueued to WF_ERROR queue

select wf.user_data.event_name Event_Name, wf.user_data.event_key Event_Key,
wf.user_data.error_stack Error_Stack, wf.user_data.error_message Error_Msg
from wf_error wf where wf.user_data.event_key =

If user is not receiving the emails from system then check the preferences in this below tables for the user_name

select Name,DISPLAY_NAME,EMAIL_ADDRESS,NOTIFICATION_PREFERENCE,STATUS
from wf_users where DISPLAY_NAME=’TEST_USER’ ;

Status – Active
Notification_preference-> Should be Email
Email Address should not be null


To see the workflow log you can use this below query.

Workflow log’s: FNDCPGSC*.txt under $APPLCSF/$APPLOG directory


 If you want to see Other OAF Related Posts , Please visit Below URL.
https://rpforacle.blogspot.in/2013/03/oaf_10.html

If you want to see  Oracle Fusion Related Posts , Please visit Below URL.
https://rpforacle.blogspot.in/2018/01/oracle-fusion-learning-tutorial.html
If you want to Learn Oracle Workflow Builder, Please visit Below URL.
https://rpforacle.blogspot.in/2018/01/oracle-workflow-learning-tutorial-1.html