This content has been marked as final. Show 15 replies
when you submit the request in the output chose email insted of printer.
Thanks for the suggestion, in fact when i am in the process of submitting a concurrent request. I see 'Options' tab. Where i can mention the name of the people to be notified.
I've mentioned his email address in his profile. These notifications are then available in the Notification mailers lists.
My question is how can i send these concurrent request's generated output file on a particular person's email address.
What are the other configuration steps need to be done.
Please don't hesitate to send me the complete steps. :)
maybe you need to setup workflow notification mailer at your OAM with info, about your mail server and deatils need there.
My mail server is hosted externally. i am using smtp and pop3 for sending and receiving emails. Will i be able to send the output of the concurrent request with this configuration or i have to configure mail servrer with me.
Thankyou for your hints suggestions.
you will be able to but make sure to reflect those configration in your env. did you check if you have the workflow mailer configured at your env. ?
when you submit the request in the output chose email insted of printer.--->>>>>>>>>....
Tried the same.. I cant select any email in the output.. but I can select printer.. only noprint is availble there.. rather I tried using "Notify the following people" and it works. I just want to know..
1) how we can make this as the default option .. everytime, when I run the report I dont want to set this notify people, rather I want to make this as the default one ?/
Is this possible ?
2) am getting email about the report.. am gettin a URL . when I click it for the first time.. I can able to see the ouput of the request.whereas next time, it erroed out saying authentication failed.
ANy idea ?
The URL/link in ConcReq notifications are only valid for ONE look/visit per person on the notification list.
We use sendmail and uuencode the output into the message. Think You could probably define a print of type email and use pipes as the driver definition.
uuencode output.file | sendmail email@example.com
You can use UTL_MAIL.send_attach_varchar2 or UTL_MAIL.send_attach_raw to send attachments in the mail.
You have to install this first this does not come by default (see documentation).
You can create a simple procedure which :
1. Takes request_id as parameter
2. Reads the output file of thie request_id.
3. Attach this as txt attachment or raw attachment.
4. Send mail with attachment using the above.
But ofcourse, you have to be on database version 10g for this to be used.
We can send the output of the concurrent request as email to the concerned person using the following approach.
1. Capture the file path using the request_id (you can get the file path from the fnd_concurrent_requests table).
2. Use the code which is used to send emails with attachments. For the code please visit my blog (http://arunrathod.blogspot.com/2008/05/sending-email-using-plsql.html).
Let me know if you face any problem with this code.
Arun Kumar S.R
I have been able to burst and email relevant files as pdf attached to corresponding persons from the command line using the rwrun command and the distribution.xml file. It is working absolutely fine and the way i want it to but i also want to somehow do it from the concurrent manager. like when the report is run it picks up the distribution file and distributes cuz in rwrun command we actually specify the distribution.xml file.
so what i am asking is that if there is any way of attaching the distribution.xml file with the request so that when upon completion of request the emails are generated
If you are running command line. You can create a printer driver in Oracle application for this. Then attach this printer to your concurrent program
I have created a solution where the concurrent request is loaded to a workflow attribute and sent out from workflow notification mailer as an attachment to the main message.
This way you can send quotes and other documents to customers with a nice cover letter.
Check out the details on my blog at http://piotrbelter.blogspot.com
For sending concurrent request outputs to internal users I recommend the notification option from under the Options button when submitting a concurrent request. This way you can specify list of users (names not even emails) who should get the notification.
I don't think XMLP bursting is available for 11.5.9, only 220.127.116.11 and above.
But by far the easiest option for distributing output is to use the bursting functionality in XMLP/BIP to distribute output via email (or fax, print) to internal or external parties.
Gareth Roberts has documented the steps very well on his blog: