Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size



Monday, 30 October 2006 19:03 Anil Passi
E-mail
User Rating: / 1
PoorBest 
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 (56)add
...
written by Narayana Reddy , November 10, 2006
Hi,

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

Thanks,
Narayana Reddy
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: -2
...
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
report abuse
vote down
vote up
Votes: -1
...
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.
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: +0
...
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
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: +0
...
written by Sachin Jedhe , December 17, 2006
Hi Anil,
we are on 11.5.10.2.

Thanks
Sachin
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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 add***s 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.
report abuse
vote down
vote up
Votes: +0
...
written by rahul pardeshi , May 18, 2007
i need to send the notification to outside email like
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
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
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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 ad***ses differnt from the users in the database.
would appriciate the help,
thanx,
rafi.
report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
...
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.
report abuse
vote down
vote up
Votes: -1
...
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

report abuse
vote down
vote up
Votes: +0
...
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 Add***s" 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

report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
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.

report abuse
vote down
vote up
Votes: +0
...
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
report abuse
vote down
vote up
Votes: +0
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

report abuse
vote down
vote up
Votes: +0
How to modify Email options!
written by Supriya , April 24, 2008
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
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi- , April 24, 2008
Supriya

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







Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
...
written by Supriya , April 24, 2008
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
Supriya
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi- , April 24, 2008
I am afraid that this will indeed require a change to the wft file, and also will impact both Email and Notification within worklist.
report abuse
vote down
vote up
Votes: +0
How to Customize the PO/Requisition Workflow Notifications -Approval
written by Basavanagowda.M , May 07, 2008
Hi Anil,
Thank u so much,
Requires to customize the Purchase Requisition Approval Notification,need 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.

Thanks a lot

Regards,

B.Gowda
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , May 07, 2008
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.

Otherwise you will have to look into the WF message, which will most likely be based on pl/sql package/procedure
Thanks,
Anil
report abuse
vote down
vote up
Votes: +0
Customize the Purchase Requisition Approval Notification
written by Rizwan Khan , October 14, 2008
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,
Rizwan

report abuse
vote down
vote up
Votes: +0
workflow notification being skipped and getting auto approved
written by Priyanka_Ray , November 06, 2008
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?


report abuse
vote down
vote up
Votes: +0
Notification Mailer
written by Saharya , April 07, 2010
Hi Anil,
l**e 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 add***ses 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
report abuse
vote down
vote up
Votes: +0
email without WF
written by Anil- , April 07, 2010
Do you wish to send emails without going via WF ?
If so, use implement below procedure in pl/sql

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 => ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it '
,p_from => ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it '
,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=' ||
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;

report abuse
vote down
vote up
Votes: +0
...
written by Anil- , April 07, 2010
Or use this link
http://pastebin.com/McgpR60S

report abuse
vote down
vote up
Votes: +0
Workflow mailer notification
written by abdul hameed , July 22, 2010
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..

ever smtp and other settings are very fine,, and mails reach the WF_NOTIFICATION_OUT table.. its ready in status,,

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

thanks in advance
report abuse
vote down
vote up
Votes: +0
Oracle Application R12.1.3 Approval mail is not working
written by ravindra Saini , December 27, 2010
Hi ,


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


but notification mailer is working .

report abuse
vote down
vote up
Votes: +0
Workflow email notifications
written by NDG , January 19, 2011
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 add***ses 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.
Thanks,
Nilesh
report abuse
vote down
vote up
Votes: +0
Email to Multiple Email Add***ses
written by shishu paul , April 28, 2011
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 add***s properly. But my need is to send an email to more than one email add***s in one run. Is it possible then how we can achieve this.

Thanks
Shishu Paul
report abuse
vote down
vote up
Votes: +0
how to setup i-expense email notification
written by Kristian Azwar , July 29, 2011
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,
Kristian
report abuse
vote down
vote up
Votes: +0
iexpense email notification
written by Kristian Azwar , August 01, 2011
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?
report abuse
vote down
vote up
Votes: +0
RE: Email Notifications not working in i-Procurement and Purchasing.
written by Sandeep Vemula , August 18, 2011
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,
Sandeep.
report abuse
vote down
vote up
Votes: +0
Set Override Via Script
written by Martin , January 30, 2012
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.
Thanks
report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy
< Prev   Next >
Last Updated ( Monday, 04 June 2007 17:26 )  

Related Items

Search apps2fusion