Hi Suboh, I would go with Luis suggested direction. You might run the following query to find out a user email and notification properties: SELECT u.user_name, r.notification_preference, r.email_address FROM fnd_user u, wf_local_roles r WHERE r.name = u.user_name and u.user_name = '<username>'; The notification_preference shouldn't be in QUERY or DISABLED, email_address should point to the valid email address. Notice that Mailer checks wf_local_roles for an email address to be used (instead of FND_USER). The interesting bit from my memories is that up to a certain patch level in 11i Notification mailer wouldn't set MAIL_STATUS to SENT. Instead it just update it from MAIL to NULL after sending a notification. Just wonder is the BEGIN_DATE for your suspicious notification is long time back in history or not? If it is far from today then it might be that this notification has been processed by old version of the Mailer. BTW: I have posted a second part of "Notification Mailer troubleshooting" articles http://appsdbalife.wordpress.com/2009/09/10/notification-mailer-troubleshooting-part-ii/ I would really appreciate your feedback. ;) If you do some question on how WF Mailer is working let discuss those and I will continue posting on that topic based on our discussions. Yury. On Tue, Sep 15, 2009 at 1:25 AM, Luis Freitas <lfreitas34@xxxxxxxxx> wrote: > Suboh, > > If this is happening for only some user, then probably these users dont > have e-mails on WF_USERS. > > Regards, > Luis > > --- On Mon, 9/14/09, Subodh Deshpande <subodh_deshpande@xxxxxxxxx> wrote: > >> From: Subodh Deshpande <subodh_deshpande@xxxxxxxxx> >> Subject: in wf_notifications mail status is null >> To: ora-apps-dba@xxxxxxxxxxxxx >> Date: Monday, September 14, 2009, 10:09 AM >> hi, >> >> in wf_notifications i found that one of >> notification_id has mail_status null instead of >> ERROR,FAILED,MAIL,SENT. >> >> Just wanted to know what are the possible causes that >> can make the mail_status as null. >> >> we have not applied any patches, any changes to imap >> server,user, password and or any >> customisation.. >> >> >> Thanks! >> Subodh >> >> >> >> >> > > > > > -- Yury Oracle Certified Master Mobile number: +61 405728926 ============================================ http://otn.oracle.com/ocm/jvelikanovs.html