Re: in wf_notifications mail status is null
- From: <oraapps@xxxxxxxxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 15 Sep 2009 12:07:09 -0400
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
>
Other related posts:
