Written by Anil Passi   
Monday, 30 October 2006
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"
Image

 

Step 2
Ensure that Notification Mailer is running, and then click on icon as below
Image

 

Step 3
Click on "View Details"
Image



Step 4.
Click on "Set Override Address"
Image



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

Comments (37)add
...
written by Narayana Reddy , November 10, 2006
Hi,

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

Thanks,
Narayana Reddy
...
written by Anil Passi , November 15, 2006
Hi Narayan

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

Thanks
Anil
...
written by Anil Passi , December 06, 2006
Hi Sachin,

Are you on 11.5.10?

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

Thanks,
Anil Passi
...
written by Vishal , December 07, 2006
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.
Vishal.
...
written by Vishal , December 07, 2006
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.
Vishal.
...
written by Anil Passi , December 08, 2006
Hi Vishal,

Firstly 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.

Thanks
Anil
...
written by vijay reddy , December 11, 2006
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
vbhaskar_Apps@yahoo.com
...
written by Anil Passi , December 11, 2006
Hi Vijay

I already have a article on timeouts.

http://oracle.anilpassi.com/oracle-workflow-notifications-timeouts-with-bank-holidays-weekends.html

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://oracle.anilpassi.com/or...kends.html

Thanks
Anil Passi
...
written by Vishal , December 11, 2006
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.

Thanks,
Vishal.
...
written by vijay reddy , December 11, 2006
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
vbhaskar_Apps@yahoo.com
...
written by Anil Passi , December 11, 2006
Hi Vijay

I already have a article on timeouts.

http://oracle.anilpassi.com/oracle-workflow-notifications-timeouts-with-bank-holidays-weekends.html

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://oracle.anilpassi.com/or...kends.html

Thanks
Anil Passi
...
written by Vishal , December 11, 2006
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.

Thanks,
Vishal.
...
written by Sachin Jedhe , December 17, 2006
Hi Anil,
we are on 11.5.10.2.

Thanks
Sachin
...
written by Anil Passi , December 18, 2006
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.

Thanks,
Anil Passi
...
written by Anil Passi , December 18, 2006
Hi Sachin,

The screenshots posted by me are from 11.5.10 CU2 too. Please email me your screenshots on anilpassi@gmail.com

Thanks
Anil Passi
...
written by Anil Passi , December 18, 2006
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.

Thanks,
Anil Passi
...
written by Anil Passi , December 18, 2006
Hi Sachin,

The screenshots posted by me are from 11.5.10 CU2 too. Please email me your screenshots on anilpassi@gmail.com

Thanks
Anil Passi
...
written by Anil Passi , January 09, 2007
.
.
.
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]

thanks,
anil
...
written by Ramachandran , January 09, 2007
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.

Regards,
Ram
...
written by Anil Passi , January 09, 2007
.
.
.
Ram,

I guess you have raised this question against wrong article.

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

Thanks
Anil
...
written by Ramachandran , January 09, 2007
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.

Regards,
Ram
...
written by Anil Passi , January 09, 2007
.
.
.
Ram,

I guess you have raised this question against wrong article.

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

Thanks
Anil
...
written by Anil Passi , January 12, 2007
.
.
Hi Al,

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

Please can you email me Application Manager screenshot on 11.5.8 to revive my memory. My Email Address is comments.anilpassi@gmail.com
...
written by Anil Passi , January 12, 2007
.
.
Hi Al,

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

Please can you email me Application Manager screenshot on 11.5.8 to revive my memory. My Email Address is comments.anilpassi@gmail.com
...
written by Swapnil , April 12, 2007
Hi Anil,
Its very good document,
while doing this on my application 11.5.10,
i stuck in step 2. there i get
notification Mailer - unavailable
Background Engine - down and
purge- down then what should i do?


Thanks
Swapnil
...
written by mohummad fahad , May 02, 2007
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.
notification 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.
...
written by rahul pardeshi , May 18, 2007
i need to send the notification to outside email like
rahul_pardeshi@yahoo.com
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
...
written by shameer Hussain , June 18, 2007
Hi Anil,

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

Thanks

Shameer
...
written by rafi , August 26, 2007
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,
rafi.
...
written by Vijaya , September 12, 2007
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
...
written by vivek , September 22, 2007
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.
...
written by Anil Passi , September 23, 2007
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,
Anil Passi

...
written by Chandra123 , November 17, 2007
Hi Anil, Yet another nice article from you. You are asktom in Oracle Apps domain.

However, 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.
Chandra

...
written by Anil Passi , November 18, 2007
Hi CHandra

The layout/navigation 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

Thanks,
Anil
Override button is not available
written by Chandra123 , November 18, 2007
Hi Anil,
But I am using 11.5.10. I feel this button is disabled some where by AppsDBA.

...
written by Anil Passi , November 19, 2007
Chandra

Please use the SQL below

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

Do not run this on production environment

Additionaly, are you on latest CU4 of 11.5.10?
Perhaps the changes mentioned took place in later CU of 11.5.10

Thanks,
Anil
last logon date
written by Avishek , January 31, 2008
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?

Regards,
Avishek Chakrabarti

You must be logged in to a comment. Please register if you do not have an account yet.

busy