Home 
Technical Articles Oracle Workflows Workflow Notifications - Override Email address for all Notifications
Technical Articles Oracle Workflows Workflow Notifications - Override Email address for all Notifications Also see here fully verifiable feedbacks/testimonials
| Workflow Notifications - Override Email address for all Notifications | | Print | |
| 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.
Step 2
Step 3 Comments
(37)
 written by Narayana Reddy , November 10, 2006 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
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.
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
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
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
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
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
Hi Anil,
Its really nice to see u sharing knowledge on this site.It will definetly pay back... Thanks Shameer
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.
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
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.
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
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
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
Hi Anil,
But I am using 11.5.10. I feel this button is disabled some where by AppsDBA.
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
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.
|
Subscribe to this comment's feed
good documnetation ,i will be asking you more questions in future
Thanks,
Narayana Reddy