RE: in wf_notifications mail status is null
- From: Shyam Kumar <shyam4558@xxxxxxxxxxx>
- To: ora-apps dba <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Mon, 21 Sep 2009 14:25:24 +0000
Sorry for the late reply.
You need to verify the user setup - who reported that he can't get any emails.
Login to OAM - Workflow Setup - Verify by sending a test email to the user who
reported the problem. You can check the log in $APPLCSF/log/FND*.txt (Check for
latest timestamp, or grep the files with NID) - to see if the emails are sent
to the user or if they have wrong id etc...(if you don't see any issues then go
the user preferences and verify his setup (navigation path - from last email)
Let us know
> Date: Wed, 16 Sep 2009 14:59:40 -0400
> From: oraapps@xxxxxxxxxxxxxxx
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: RE: in wf_notifications mail status is null
> CC: shyam4558@xxxxxxxxxxx; subodh_deshpande@xxxxxxxxx
>
> 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
>
>
_________________________________________________________________
Begin your day with a strong dose of news, sports, entertainment and more on
MSN India
http://in.msn.com
Other related posts:
