RE: Is there any way to find when a WF Notification Mailer sent a particular email to the user?

You can always change the expiry time on the queue - so it does not get
purged.

In the end, all workflow ( apart from permanent entries ) will be
purged. Like with any data ... if you have a business requirement that
says you must be able to go back 1 month, then you can set that as the
expiry. If you have a requirement of 1 year, then you will have to start
looking at storing data in custom areas ( for performance purposes ).
It's the same with backups and every other piece of information in the
system. Purge or no purge ( or custom storage of specific information )
- the choice is yours.

Kent.

-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs
Velikanovs
Sent: 24 May 2006 16:47
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: Re: Is there any way to find when a WF Notification Mailer sent
a particular email to the user?


Kent,

Thank you for response,

You are right, it is place where we can get some indication then NM
dequeued and presumably sent the notification.
However messages in Wf_notification_out queue expire and oracle cleans
those out after 24 hours from dequeuing.
There is no history available older then 24 hours unfortunately.

Yury

On 5/24/06, Rolfe, Kent (GTI AIS OPS/SE) <kent_rolfe@xxxxxx> wrote:
> Wf_notification_out table, DEQ_TIME should be about right.
>
> -----Original Message-----
> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs
> Velikanovs
> Sent: 24 May 2006 16:11
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: Is there any way to find when a WF Notification Mailer sent a
> particular email to the user?
>
>
> Hello every one,
>
> Just wonder if you know the way to find time then email has been sent
> by WF Notification Mailer?
> I have traced (10046) the WFNM session and it looks like NM doesn't
> fix the time then it sent email to the user.
> can any one comment on that issue?
>
> --
> Yury
> +44 7738 013090 (GMT)
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
> --------------------------------------------------------
>
> If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy,
retain or redistribute it. Click here for important additional terms
relating to this e-mail.     http://www.ml.com/email_terms/
> --------------------------------------------------------
>
>


-- 
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html

Other related posts: