Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Oracle Workflows - All Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Very often on a Oracle Apps Test or Development environment, you would like all the Workflow Email notifications to be sent to your email address.

Please  find the steps required to assign your email address. This is of tremendous help when testing Oracle Workflows based applications.
These steps have been tried and tested on 11.5.10 environment.
As a developer, please do not try these steps on Production Environment, or else you will end up doing users work !

Step 1
Login to "Workflow Administrator Web Applications"

Once logged in to Oracle Applications, we first need to click on responsibility named "Workflow Administrator Web Applications".

If you do not have access to " Workflow Admnistrator Web Administrator Web Applications", then you need do assign this via System Administrator respnsibility.

In Workflow Administrator responsibility, click on Menu 'Workflow Manager". The Screen where we can set the override Email Address will be accessed from this menu.

Step 2
Ensure that Notification Mailer is running, and then click on icon .

Firstlyensure that the Notification Mailer is up and running. This is Evident from the green tick box against the Notification Mailers.

We need to configure notification mailer such as that all the emails will be sent to This email address is being protected from spambots. You need JavaScript enabled to view it.

In order to accomplish this, click on Green Tick besides Notification Mailers.

Step 3
Click on "View Details"

In this screen, you can see that the service Component " Workflow Notification Mailer" is running. Click on the button "View Details"

Step 4.
Click on "Set Override Address" button.. its getting close isn't it?

 

Step 5.
Finally you can change the email address here. Please read the instructions in red carefully.

Now, finnaly, we change the email address and click on submit.

Note : Please do not leave this field blank on a development environment. 

Override template

 

Create a custom version of the Standard System Mailer Workflow

 

Open the System: Mailer

Save it as XXSYSML

Open its wft in textpad and search and repace WFMAIL by XXSYSML

Now open this XXSYSML.wft file and change the Name of Workflow from "System: Mailer" to "XX System: Mailer"

Now you can modify the templates within this workflow as desired.



Now, go back to your PO Approval Workflow and attach a new attribute of name for FYI, #WFM_OPEN_MAIL_FYI

 

 

Make the value of this attribute point to custom version of "System: Mailer" template


Anil Passi

Comments   

0 #1 Narayana Reddy 2006-11-10 00:00
Hi,

good documnetation ,i will be asking you more questions in future

Thank s,
Narayana Reddy
Quote
0 #2 Anil Passi 2006-11-15 00:00
Hi Narayan

Plea se feel free to ask, I am here to respond, that is if I know the answer.

Than ks
Anil
Quote
0 #3 Anil Passi 2006-12-06 00:00
Hi Sachin,

Are you on 11.5.10?

Not e: You can do this in previous versions of 11i too, but the navigational sequence is different.

T hanks,
Anil Passi
Quote
0 #4 Vishal 2006-12-07 00:00
Hi Anil,
I have one issue related to WF links. In the std JE approval process of oracle, one submitting a JE for approval, an email gets generated which has 2 response buttons - Approve and Reject.

In my instance, the email gets to me fine, but response buttons do not work. Meaning, when i click on response buttons, it opens a new compose email page with valid mail id and mail gets sent. But JE does not get approved ?

Any ideas what could be wrong ?

Thanks in advance.
Visha l.
Quote
0 #5 Vishal 2006-12-07 00:00
Hi Anil,
I have one issue related to WF links. In the std JE approval process of oracle, one submitting a JE for approval, an email gets generated which has 2 response buttons - Approve and Reject.

In my instance, the email gets to me fine, but response buttons do not work. Meaning, when i click on response buttons, it opens a new compose email page with valid mail id and mail gets sent. But JE does not get approved ?

Any ideas what could be wrong ?

Thanks in advance.
Visha l.
Quote
0 #6 Anil Passi 2006-12-08 00:00
Hi Vishal,

Firs tly you need to establish whether the issue is with your specific notificiation or all response type notifications.

If other notification reposnses fail too, then it is a workflow config issue.

If other notification responses are working, then check if there are any unclosed HTML tags in notification content. Also, try sending a notification of type response with static text,and see if that works.

Thank s
Anil
Quote
0 #7 vijay reddy 2006-12-11 00:00
hi Anil,

I created a stadlaone work flow, i need to send a notificaton to a person for every 15 min based on the condition.so i kept a wait function but it is refreshing for every sec.
can you plz advice me.
thank you

vijay reddy
Quote
0 #8 Anil Passi 2006-12-11 00:00
Hi Vijay

I already have a article on timeouts.

http://www.google.com/search?q=site:apps2fusion.com+oracle-workflow-notifications-timeouts-with-bank-holidays-weekends

You can use a wait function, that reads an item attribute. That Item Attribute can have a default value of 15

See the link http://www.google.com/search?q=site:apps2fusion.com+oracle-workflow-notifications-timeouts-with-bank-holidays-weekends

Thanks
Ani l Passi
Quote
0 #9 Vishal 2006-12-11 00:00
Hi Anil,
Thanks for your responses. I have a issue with all notifications. Response buttons do not work in any of these.

Any thoughts on what could be wrong with workflow config ? What should I check.

Thank s,
Vishal.
Quote
0 #10 vijay reddy 2006-12-11 00:00
hi Anil,

I created a stadlaone work flow, i need to send a notificaton to a person for every 15 min based on the condition.so i kept a wait function but it is refreshing for every sec.
can you plz advice me.
thank you

vijay reddy
Quote
0 #11 Anil Passi 2006-12-11 00:00
Hi Vijay

I already have a article on timeouts.

http://www.google.com/search?q=site:apps2fusion.com+oracle-workflow-notifications-timeouts-with-bank-holidays-weekends

You can use a wait function, that reads an item attribute. That Item Attribute can have a default value of 15

See the link http://www.google.com/search?q=site:apps2fusion.com+oracle-workflow-notifications-timeouts-with-bank-holidays-weekends

Thanks
Ani l Passi
Quote
0 #12 Vishal 2006-12-11 00:00
Hi Anil,
Thanks for your responses. I have a issue with all notifications. Response buttons do not work in any of these.

Any thoughts on what could be wrong with workflow config ? What should I check.

Thank s,
Vishal.
Quote
0 #13 Sachin Jedhe 2006-12-17 00:00
Hi Anil,
we are on 11.5.10.2.

T hanks
Sachin
Quote
0 #14 Anil Passi 2006-12-18 00:00
Hi Raghu,

I very much doubt that workflow configuration can be setup at Module Level.

Given that you are using Java-based Workflow Notification Mailer, you can debug the Mailer using steps in Metalink Note 242941.1.

Th anks,
Anil Passi
Quote
0 #15 Anil Passi 2006-12-18 00:00
Hi Sachin,

The screenshots posted by me are from 11.5.10 CU2 too. Please email me your screenshots on

Thanks
Ani l Passi
Quote
0 #16 Anil Passi 2006-12-18 00:00
Hi Raghu,

I very much doubt that workflow configuration can be setup at Module Level.

Given that you are using Java-based Workflow Notification Mailer, you can debug the Mailer using steps in Metalink Note 242941.1.

Th anks,
Anil Passi
Quote
0 #17 Anil Passi 2006-12-18 00:00
Hi Sachin,

The screenshots posted by me are from 11.5.10 CU2 too. Please email me your screenshots on

Thanks
Ani l Passi
Quote
0 #18 Anil Passi 2007-01-09 00:00
.
.
.
aha, i understand your question now. You are trying to reference attribute column in notification body.

before you can do so, simpl drag and drop the attribute10 into the message body [in object navigator]

t hanks,
anil
Quote
0 #19 Ramachandran 2007-01-09 00:00
Dear Anil,
Thanks, please refer my email, where I have given the Attachments, the Attribute10 is already to the Message.

You may refer my email, as I cannot attach the screen shot in the blog.

Regard s,
Ram
Quote
0 #20 Anil Passi 2007-01-09 00:00
.
.
.
Ram,

I guess you have raised this question against wrong article.

Any how, at what stage of the workflow is your activity being called.

Than ks
Anil
Quote
0 #21 Ramachandran 2007-01-09 00:00
Dear Anil,
Thanks, please refer my email, where I have given the Attachments, the Attribute10 is already to the Message.

You may refer my email, as I cannot attach the screen shot in the blog.

Regard s,
Ram
Quote
0 #22 Anil Passi 2007-01-09 00:00
.
.
.
Ram,

I guess you have raised this question against wrong article.

Any how, at what stage of the workflow is your activity being called.

Than ks
Anil
Quote
0 #23 Anil Passi 2007-01-12 00:00
.
.
Hi Al,

I have sincerely forgotten the navigation path for 11.5.8 Notif Override.

Pl ease can you email me Application Manager screenshot on 11.5.8 to revive my memory. My Email Address is
Quote
0 #24 Anil Passi 2007-01-12 00:00
.
.
Hi Al,

I have sincerely forgotten the navigation path for 11.5.8 Notif Override.

Pl ease can you email me Application Manager screenshot on 11.5.8 to revive my memory. My Email Address is
Quote
0 #25 Swapnil 2007-04-12 00:00
Hi Anil,
Its very good document,
while doing this on my application 11.5.10,
i stuck in step 2. there i get
notificati on Mailer - unavailable
Ba ckground Engine - down and
purge- down then what should i do?


Thanks
Swapnil
Quote
0 #26 mohummad fahad 2007-05-02 00:00
Hi Anil,

I really appreciate your effort.

I am new to workflow and require your help.
I have to find out the email address of a person who responds to the notification.

suppose someone rejects the request then i need to keep track of the preson who has rejected the request.
notif ication is going to the pool of people not only to single person and i need to implement this in ORACLE(Pl/SQl).

I did some research from my side that there are few API that can be used like RESPONDER and RESPOND but not sure how to implement these.

I will be really thankful if you reply to me ASAP.
Quote
0 #27 rahul pardeshi 2007-05-18 00:00
i need to send the notification to outside email like

with a response type of control

so if i approve the notification in yahoo
the workflow should propogate
on the applications side

is it possible
Quote
0 #28 shameer Hussain 2007-06-18 00:00
Hi Anil,

Its really nice to see u sharing knowledge on this site.It will definetly pay back...

Than ks

Shameer
Quote
0 #29 rafi 2007-08-26 13:28
hey,
is there any way to use the wf mailer java api for my own selection of email-sending from the database ?
actually we want to send the emails from workflow but to adresses differnt from the users in the database.
would appriciate the help,
thanx,
ra fi.
Quote
0 #30 Chandra Thangavelu 2007-09-12 00:33
Hi anil,
could you please let me know the regarding HR (HRSSA) workflow. I have customized one of the process(change payment method process).. How to find out where this process is called from. Can you please help me on this.

Thanks,
Vijaya
Quote
0 #31 Juliet 2007-09-22 12:50
Hi Anil,

In our Project we are having Arabic as the other language
installed apart from English.
We have developed a Custom Workflow by making a copy from the seeded one, and added our own Custom message to the
Notifications.
In the Custom Messages we have added our text in English.
What we see is, if we are using the seeded workflow Notifications with Seeded
Message body, then in the wf_messages_tl table the Column -- Body,
Description,
Subject, Display Name everywhere the wf_messages_tl table is updated in both 'US' as well as 'AR' Language.
But this doesn't happen when we are making a Custom message in English, in our case the table is updated in
only English for both the languages.
------------
we need to see the text of the custom message in Arabic when a user logs through Arabic Version and in English when a User logs in through English Version.

Thanks,
Vivek .
Quote
0 #32 Anil Passi 2007-09-23 07:53
Hi Vivek

When saving the WF using WF Builder, try the following:-

1. Open the .wft file in text pad editor or vi editor
2. Change the WFLOAD language from English to Arabic. This should be in the sixth line of wft file
3. Upload the wft using WFLOAD

In case you find difficulties in doing so, then simply change the flow in WF process. Create a WF Activity that checks the language for current session. This can be done using USERENV('LANG')
In this case, you will have two messages, one for english and other for Arabic. Depending upon the value of USERENV('LANG') , one of the two activities will be executed. This isn't an ideal solution, hence try the first option, i.e. by changing language in .wft file

Thanks,
A nil Passi
Quote
0 #33 Chandra123 2007-11-17 23:10
Hi Anil, Yet another nice article from you. You are asktom in Oracle Apps domain.

Howeve r, I am trying this in my development area. But I can't see button "Set Override Address" in my screens. Is this disabled ? "Test mailer " button is still there.

I have SysAdmin access, what are the steps to enable this button. Please help me.

Thanks in Advance.
Chandr a
Quote
0 #34 Anil Passi 2007-11-18 07:18
Hi CHandra

The layout/navigati on of this particular screen is different starting form a latter version of 11.5.10.
I do not have access to 11.5.9 innstance hence cant recollect the exact steps for that instance

Thank s,
Anil
Quote
0 #35 Chandra123 2007-11-18 23:44
Hi Anil,
But I am using 11.5.10. I feel this button is disabled some where by AppsDBA.
Quote
0 #36 Anil Passi 2007-11-19 06:06
Chandra

Please use the SQL below

update wf_resources set text = '*' where name = 'WF_ADMIN_ROLE' ;
commit;

Do not run this on production environment

Ad ditionaly, are you on latest CU4 of 11.5.10?
Perhap s the changes mentioned took place in later CU of 11.5.10

Thanks ,
Anil
Quote
0 #37 Avishek 2008-01-31 17:30
Hi Anil,

Does the last_logon_date field in fnd_user table get updated if the User approves a document using email workflow Approval without logging in to Oracle?

Regard s,
Avishek Chakrabarti
Quote
0 #38 Kashif Baksh 2008-04-24 06:47
Hi Anil

We are on R12. Currently for PO (Purchase Order) Approval we get a notification in the worklist and also an email is sent to the Approver. The email and notification has many options such as Request Information, Reassign etc apart form Approve and Reject.

In the email I have to keep only Approve and Reject buttons. And I do not want any other options to be given to the user.

I searched in the PO workflow code. But could not find. Could you please tell me which file should I modify to achieve this (Is it a workflow file or PO file)?

Thanks
Supriya
Quote
0 #39 Anil Passi- 2008-04-24 07:01
Supriya

You can use the #HIDE_MOREINFO and #HIDE_REASSIGN attributes against the Notification Message.
Please see the screenshots below







Thanks,
Anil Passi
Quote
0 #40 Kashif Baksh 2008-04-24 07:35
Hi Anil,

Thanks a lot for your quick response. Have another question. From the screenshots I understood that I need to change the .wft file (related to PO Approval). But doesn't it affect the notification also? because I want these options to be hidden only in the email notification not in the worklist notification. First of all is it possible?

Thanks
Supriy a
Quote
0 #41 Anil Passi- 2008-04-24 07:43
I am afraid that this will indeed require a change to the wft file, and also will impact both Email and Notification within worklist.
Quote
0 #42 Basavanagowda.M 2008-05-07 13:14
Hi Anil,
Thank u so much,
Requires to customize the Purchase Requisition Approval Notification,ne ed to display the additinal information like Onhand Quantity ,Quantity on Order ,Quantity in Requisition against the respective Item Code in the Approval Notification Page.
So, Please let me know how to achive this requirement.

T hanks a lot

Regards,

B.Gowda
Quote
0 #43 Anil Passi 2008-05-07 13:25
Hi B Gowda

First find out if this is a framework based notification [11.5.10 onwards]
If so, you will be able to extend your framework region itself.

Otherw ise you will have to look into the WF message, which will most likely be based on pl/sql package/procedu re
Thanks,
Anil
Quote
0 #44 Rizwan Khan 2008-10-14 08:10
Hi Anil,

We need to customize the Purchase Requisition Approval Notification on R12 which I think is framework based.
Can I get any document or note on how to do it.. ?

Thanks,
Rizw an
Quote
0 #45 Priyanka_Ray 2008-11-06 02:21
Hi Anil,
I know I am posting this against the wrong article ,but I couldn't find the correst article against which I could post my query.
I have designed a workflow for 4 levels of a approval which follows the supervisor hierarchy. The workflow skips one level and get auto approved at that level and goes to its immediate supervisor for approval.
I am unable to find out the cause for this. At all other levels the worklfow works as per the desired output.
In the code I have not not kept any conditions for this skipping.
Can you please help me figure out the problem?
Quote
0 #46 Saharya 2010-04-07 14:27
Hi Anil,
Love all your articles. I have a question related to the Notification Mailer. We send lot of notifications to the vendors but sometimes due to bad email addresses the emails are overloaded in the mail box and the notification mailer goes down.
Is there a way to get some message somehow that the notification mailer is down without noticing it in the WF Manager?
Thanks .
Archana
Quote
0 #47 Anil- 2010-04-07 19:26
Do you wish to send emails without going via WF ?
If so, use implement below procedure in pl/sql

Quote:
PROCEDURE send_html_email(p_to IN VARCHAR2
,p_from IN VARCHAR2
,p_subject IN VARCHAR2
,p_text IN VARCHAR2 DEFAULT NULL
,p_html IN VARCHAR2 DEFAULT NULL
,p_smtp_hostname IN VARCHAR2
,p_smtp_portnum IN VARCHAR2) IS
l_boundary VARCHAR2(255) DEFAULT 'a1b2c3d4e3f2g1';
l_connection utl_smtp.connection;
l_body_html CLOB := empty_clob; --This LOB will be the email message
l_offset NUMBER;
l_ammount NUMBER;
l_temp VARCHAR2(32767) DEFAULT NULL;
BEGIN
/* Usage......
html_email(p_to => ''
,p_from => ''
,p_subject => 'Testing from anil'
,p_text => 'ABCD'
,p_html => 'IJKLM Testing for the HTML Format of the email'
,p_smtp_hostname => 'localhost'
,p_smtp_portnum => '25');
*/
l_connection := utl_smtp.open_connection(p_smtp_hostname
,p_smtp_portnum);
utl_smtp.helo(l_connection
,p_smtp_hostname);
utl_smtp.mail(l_connection
,p_from);
utl_smtp.rcpt(l_connection
,p_to);
l_temp := l_temp || 'MIME-Version: 1.0' || chr(13) || chr(10);
l_temp := l_temp || 'To: ' || p_to || chr(13) || chr(10);
l_temp := l_temp || 'From: ' || p_from || chr(13) || chr(10);
l_temp := l_temp || 'Subject: ' || p_subject || chr(13) || chr(10);
l_temp := l_temp || 'Reply-To: ' || p_from || chr(13) || chr(10);
l_temp := l_temp || 'Content-Type: multipart/alternative; boundary=' ||
chr(34) || l_boundary || chr(34) || chr(13) || chr(10);
----------------------------------------------------
-- Write the headers
dbms_lob.createtemporary(l_body_html
,FALSE
,10);
dbms_lob.WRITE(l_body_html
,length(l_temp)
,1
,l_temp);
----------------------------------------------------
-- Write the text boundary
l_offset := dbms_lob.getlength(l_body_html) + 1;
l_temp := '--' || l_boundary || chr(13) || chr(10);
l_temp := l_temp || 'content-type: text/plain; charset=us-ascii' ||
chr(13) || chr(10) || chr(13) || chr(10);
dbms_lob.WRITE(l_body_html
,length(l_temp)
,l_offset
,l_temp);
----------------------------------------------------
-- Write the plain text portion of the email
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.WRITE(l_body_html
,length(p_text)
,l_offset
,p_text);
----------------------------------------------------
-- Write the HTML boundary
l_temp := chr(13) || chr(10) || chr(13) || chr(10) || '--' ||
l_boundary || chr(13) || chr(10);
l_temp := l_temp || 'content-type: text/html;' || chr(13) || chr(10) ||
chr(13) || chr(10);
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.WRITE(l_body_html
,length(l_temp)
,l_offset
,l_temp);
----------------------------------------------------
-- Write the HTML portion of the message
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.WRITE(l_body_html
,length(p_html)
,l_offset
,p_html);
----------------------------------------------------
-- Write the final html boundary
l_temp := chr(13) || chr(10) || '--' || l_boundary || '--' || chr(13);
l_offset := dbms_lob.getlength(l_body_html) + 1;
dbms_lob.WRITE(l_body_html
,length(l_temp)
,l_offset
,l_temp);
----------------------------------------------------
-- Send the email in 1900 byte chunks to UTL_SMTP
l_offset := 1;
l_ammount := 1900;
utl_smtp.open_data(l_connection);
WHILE l_offset < dbms_lob.getlength(l_body_html)
LOOP
utl_smtp.write_data(l_connection
,dbms_lob.substr(l_body_html
,l_ammount
,l_offset));
l_offset := l_offset + l_ammount;
l_ammount := least(1900
,dbms_lob.getlength(l_body_html) - l_ammount);
END LOOP;
utl_smtp.close_data(l_connection);
utl_smtp.quit(l_connection);
dbms_lob.freetemporary(l_body_html);
END send_html_email;
Quote
0 #48 Anil- 2010-04-07 19:27
Or use this link
pastebin.com/McgpR60S
Quote
0 #49 abdul hameed 2010-07-22 03:45
Dear Anil Passi and Other Brothers,,

In out Instance,, we are not getting workflow mailer notification mails... what might be the reason,,its a cloned instance..

eve r smtp and other settings are very fine,, and mails reach the WF_NOTIFICATION _OUT table.. its ready in status,,

kindl y any one tell me where is the mistake might be in my instance.

than ks in advance
Quote
0 #50 ravindra Saini 2010-12-27 07:14
Hi ,


users are not able to approve/reject the purchasing documents through mail notifications


but notification mailer is working .
Quote
0 #51 NDG 2011-01-19 00:49
Hi Anil,

I want to to configure workflow notifications on test instance(R12),
my problem is that we have only one mail server both for test and production instance so when I start the workflow notification mailer the old mails which are in que start going to mail addresses of users,so I want that these mails should be stopped and for test purpose I want the mails to go to only one user so haw it can be achieved.
Thank s,
Nilesh
Quote
0 #52 shishu paul 2011-04-28 01:47
Hi Anil,
With help of your lesson 1 on Workflow I am able to run that process successfully and it is sending the email to one address properly. But my need is to send an email to more than one email address in one run. Is it possible then how we can achieve this.

Thanks
S hishu Paul
Quote
0 #53 Kristian Azwar 2011-07-29 09:53
Hi Anil,
do you by chance have a document how to setup email notification specifically for i-expense. What I mean, I need to know from scratch, like what access do I need, the setup stage and what not.

thanks,
K ristian
Quote
0 #54 Kristian Azwar 2011-08-01 16:27
My question at this point:
what's i-expense seeded notifications, is that notifications just within i-expense or it includes the email notification? or is the email notification part of additional configuration?
Quote
0 #55 Sandeep Vemula 2011-08-18 13:53
Hi Anil,

We have an issue regarding the Email notifications, and I am working for the first time on this. I have no idea on the settings.
Our email notifications stopped working suddenly in all the instances.

So using your document I followed the steps and in the Current override email it says NONE.
so what does it means? I didn't understand.

Is it working or not?
If it is not what email should I give.?
Kindly advise me ASAP.

Thanks in advance,
Sandee p.
Quote
0 #56 Martin 2012-01-30 11:19
Hi
Can anyone tell me how to set the workflow notification override using a script? I would like to get this set as part of a cloning script when creating test environments from our Production instance.
Thank s
Quote
0 #57 Hamayun 2014-11-17 04:37
Hi Anil,
Sometimes users enter wrong email address in supplier's profile. After confirming PO, workflow keeps on sending message to wrong email address. Sometimes WF mailbox is full and WFmailer stops. How can we control it through number of retry limits .

Regards,
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner