RE: in wf_notifications mail status is null
- From: Luis Freitas <lfreitas34@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 22 Sep 2009 09:29:12 -0700 (PDT)
Hi,
You can check the value for a particular user on FND_USER_PREFERENCES.
Query the table for the user in question and see if he has something setup
for the mail preference, I dont remember which key it is.
This table also stores the system default value with a strange key that
starts with # if I am not mistaken.
Regards,
Luis
--- On Mon, 9/21/09, Shyam Kumar <shyam4558@xxxxxxxxxxx> wrote:
> From: Shyam Kumar <shyam4558@xxxxxxxxxxx>
> Subject: RE: in wf_notifications mail status is null
> To: "ora-apps dba" <ora-apps-dba@xxxxxxxxxxxxx>
> Cc: subodh_deshpande@xxxxxxxxx
> Date: Monday, September 21, 2009, 11:25 AM
>
>
>
> #yiv682198593 .hmmessage P
> {
> margin:0px;padding:0px;}
> #yiv682198593 {
> font-size:10pt;font-family:Verdana;}
>
>
>
> 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
> >
> >
>
> One peek at MSN India brings you up to speed
> with what’s hot in the world today Drag n’ drop
>
Other related posts:
