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
Comments
good documnetation ,i will be asking you more questions in future
Thank s,
Narayana Reddy
Plea se feel free to ask, I am here to respond, that is if I know the answer.
Than ks
Anil
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
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.
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.
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
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_Appsyahoo.com
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
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.
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_Appsyahoo.com
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
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.
we are on 11.5.10.2.
T hanks
Sachin
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
The screenshots posted by me are from 11.5.10 CU2 too. Please email me your screenshots on anilpassigmail.com
Thanks
Ani l Passi
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
The screenshots posted by me are from 11.5.10 CU2 too. Please email me your screenshots on anilpassigmail.com
Thanks
Ani l Passi
.
.
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
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
.
.
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
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
.
.
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
.
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 comments.anilpassigmail.com
.
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 comments.anilpassigmail.com
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
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.
rahul_pardeshiyahoo.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
Its really nice to see u sharing knowledge on this site.It will definetly pay back...
Than ks
Shameer
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.
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
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 .
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
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
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
But I am using 11.5.10. I feel this button is disabled some where by AppsDBA.
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
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
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
You can use the #HIDE_MOREINFO and #HIDE_REASSIGN attributes against the Notification Message.
Please see the screenshots below
Thanks,
Anil Passi
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
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
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
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
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?
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
If so, use implement below procedure in pl/sql
Quote:
pastebin.com/McgpR60S
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
users are not able to approve/reject the purchasing documents through mail notifications
but notification mailer is working .
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
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
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
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?
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.
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
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,
RSS feed for comments to this post