RE: in wf_notifications mail status is null
- From: Shyam Kumar <shyam4558@xxxxxxxxxxx>
- To: ora-apps dba <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Wed, 16 Sep 2009 18:29:33 +0000
Many users will not get email, if they don't have proper settings,
Responsibility -> Preferences SSWA -> Preferences -> Email Style (Notifications
section)
Verify this... and also proper email (in order FND_USER, PER_ALL_PEOPLE_F,
WF_LOCAL_ROLES)
Let us know
Cheers!
> Date: Tue, 15 Sep 2009 12:07:09 -0400
> From: oraapps@xxxxxxxxxxxxxxx
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: Re: in wf_notifications mail status is null
> CC: subodh_deshpande@xxxxxxxxx
>
> Hello,
>
> I've been reading your posts.
> I have frequent issues around our mailer application.. and yes your blog and
> updates are usefull.
>
> I have a purchasing superuser that has her notification preference set to
> query. She is the main purchasing person and most all of my users forward
> their PO's to her. Once she does the work they then go to the controller or
> back to the suer for updates. Many users complaine that they don't get their
> notifications and I'm not sure if her having this setting is the problem.
>
> Appreciate the help.
>
> Greg
>
>
> ---- Subodh Deshpande <subodh_deshpande@xxxxxxxxx> wrote:
> > Thanks Yuri, Luis :)
>
> am going through your blog Yuri and will be a regular visitor too :)
>
> I agree with notification mailer might be updating 'null' status instead of
> 'SENT' for some of the processed notifications.
> And what i found is, there are different mail status like
> 'SENT','ERROR','FAILED','MAIL', 'SENT' and 'NULL' till date, then in which
> case it updates to 'NULL'.
>
> yes, upto 27-AUG-09 there are some notification ids who has got mail_status
> as NULL.
> on 27-AUG-09 for the last notification id the notification mailer status in
> OAM became 'system de-activated' and the staus is still as it is..
>
> just wanted to know, can missing notification ids cause notification mailer
> to go down, will re-building wf_notification will help here.
> and what are the possible reason that makes wf_notifications to go out of
> sync.
> can IMAP user password be an issue and am sure nobody has tamperred with it..
>
> Thanks!
> Subodh
>
> ----- Original Message ----
> From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
> To: ora-apps-dba@xxxxxxxxxxxxx
> Sent: Tuesday, 15 September, 2009 18:00:04
> Subject: Re: in wf_notifications mail status is null
>
> 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
>
>
>
> >
>
>
_________________________________________________________________
News, views and inimitable perspectives – On MSN India, you get an all-round
view of things that matter.
http://in.msn.com
Other related posts: