Workflow Notification Mailer Configuration using Autoconfig for Outbound Processing

How to make sure after configuring the Workflow Mailer , it does not send all the previous notification ?

James,
As mentioned in post http://onlineappsdba.com/index.php/2008/07/16/oracle-workflow-notification-mailer-outbound-processing

Workflow mailer sends emails only if
a) Notification status is OPEN or CANCELED and
b) Notification mail_status is MAIL or INVALID and
c) Recipient Role has a valid e-mail address and Notification Preference is in the format MAIL%
d) Workflow Deferred Agent Listener is running
e) Workflow Notification Mailer is running

If you donot want to send any previous notification
mail_status in table wf_notifications for all such notification to SENT .

Please try this on test first.

Thanks a lot.
–James

Hi James,

If you dont want to get the previous notifications in mail,find out the notifications which are waiting to be mailed.

issue the following query as apps user.

SQL> select notification_id, status, mail_status, begin_date
from WF_NOTIFICATIONS
where status = ‘OPEN’ and mail_status = ‘MAIL’;

The above query will show you the notification which are in waiting to be mailed.

If you dont want to get those notifications in mail, set MAIL_STATUS=’SENT’

sql> update WF_NOTIFICATIONS set mail_status = ‘SENT’ where mail_status = ‘MAIL’;

Once you set the mail status as ‘SENT’, Notification mailer will not pick up these records.

Hope the above helps.

Good Luck.

Regards,
Subbarao

Hi SubbaRao,
I am surprised that you remember dates. Thanks a lot for your wishes.

Thank you Atul.

Hi,

I need to change workflow from address..

I will explain every thing.

This is my current workflow mail.
From: Workflow Mailer – MLI[SMTP:NOBODY@MSWSLX04.MACSTEELUSA.COM]
Sent: Thursday, December 11, 2008 5:14:43 PM
To: Danny Cho
Subject: Action Required: Message for Testing Notification Mailer Auto forwarded by a Rule

I want to remove the From: workflow Mailer and replace our custom name. Please help me on this.

Quick reply is appriciated.

Thanks
Venkat

Hi Autul,

when Iam trying to start WF it is showing as

Name Actul Target
Workflow Agent Listener Service 0 1
Workflow Mailer 0 1
Workflow Mailer Service 0 1

Regards
Kumar

Autl,
When iam checking APPLCSF/logs iam getting following error, please help me

status=Running, de
buglevel= Error Done.wferr:
– WFXXX_DB_CONNECT CODE=1017 CONNECT=APPS

Application Object Library: Concurrent Processing version 11.5

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

Oracle Workflow Notification Mailer Concurrent Manager started : 31-DEC-2008 18:42:26

+—————————————————————————+

cpid=741379, logfile=/oraprod/oracle/finprdcomn/
admin/log/orauat_CNDAAIOEWRFR08/
WFMAILER741379.txtparams=, status=Running, de
buglevel= Error Done.wferr:
– WFXXX_DB_CONNECT CODE=1017 CONNECT=APPS
~

Kumar,
It seems you are trying to start WF from administer concurrent manager screen.

Use OAM to start/stop WF

check metalink note # 405485.1 WFXXX_DB_CONNECT CODE=1017 CONNECT=Apps when Trying to Start Workflow Mailer

Hi,
I have a requirement where i need to supress mails been sent from a particular item type.
Hence i would like to know if its possible to update the mail status immmediately to SENT for that particualr notification?
AS in once the workflow returns to my code just after sending the notification i am updating the status. WIll the window between these two events let the mailer pick up the reords and send them?

Thanks a lot
Priya

HI

I have a requirement to send output of concurrent request via mail.

Now when I set a notifcation its coming as url
like

Request number 12558616 (Active Users) completed at 09:23:25 on
09-JUN-09 with a status of Normal. This request was submitted by SYSADMIN. The report may be viewed at the following URL :
http://test.oradom.com:8000/OA_CGI/FNDWRR.exe?temp_id=1406994154.

I would like to get detailed output in the mail.

I am sure it was coming for some other clients.

But I am not sure what configuration changes are required for this setting.

I changed the Preference and tried out ..but was not working.

Any clue?

Thank

Hi,

There is a metalink note, can you check and see if it helps, I did not try this before.

How To Send Concurrent Request Output via Email?
https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=811716.1

Regards,
SubbaRao

Hi Recently change the IMAP server name through OAM. Since then Workflow mailer start to play up. We do cold backup. After the cold back Notification mailer does not start autometically. So every morning we have to start it manually. Once start it stays up all day till the next backup start.

I ran statement level trace, could not find anything unusual.

Any idead?

Regards
Kavi

Edit the configuration

Workflow Notification mailer –> edit –>. change configuration to automatic startup for IMAP server

Hi atul
i have already activated the notification mailer but how can i set email-address to send mail to user.i want to send mail to hotmail account.notification mailer is in running mode

Hi Subba Rao,

I am working on Linux servers and I have to daily check the server status by entering commands manually like df -h , prstat etc.

I just want to know that Is it possible that these stats can be shown on the GUI page in real time so without logic into server. So i can monitor these stats on GUI.

Please advise me the possibilities I am waiting for your reply. 🙂

Thanks and Regards,
Ashish Agrawal

Hello experts,

I have recently started my career as a Apps DBA, I have a few doubts regarding workflow mailer in EBS R12.

1. From which node workflow mailer service does send the mails to users, is that from conc node or SMTP server node?

2.Does the “notify” option(submit request form) not work if the Workflow mailer is not setup ?
3. can the workflow mailer send the emails outside of the company network ?

4. does workflow mailer uses Unix command “mail” or some oracle utility to send emails ?

Please clarify my doubts….

Thnks in advance
Ravi.k

Please somebody answer my doubts..?