RE: in wf_notifications mail status is null

Not sure what to verify.  only could see this page as sysadmn user
and it says html mail with attachments.  sysmin doesn't have a e-mail account
to work with our IMAP stuff.  Not sure what notifications sysadmin should get?

Greg

once looked at it said I' lanning a 
---- Shyam Kumar <shyam4558@xxxxxxxxxxx> wrote: 
> 
> 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: