Re: in wf_notifications mail status is null

  • From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Tue, 15 Sep 2009 22:30:04 +1000

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 = 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
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.


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
>> 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

Oracle Certified Master
Mobile number: +61 405728926

Other related posts: