Home » Applications » Oracle Fusion Apps & E-Business Suite » Email output pdf
Email output pdf [message #351975] Sat, 04 October 2008 03:00 Go to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi all,
How can we send the concurrent program (report) output(.pdf)
to a email address when report was submitted?
Please can any help in this...
I did using UTL_MAIL API but that was for upto 32kb .

Thanks,
Kittu.
Re: Email output pdf [message #351984 is a reply to message #351975] Sat, 04 October 2008 09:58 Go to previous messageGo to next message
kjoy
Messages: 11
Registered: September 2008
Junior Member
Kittu

There are many options to sent the concurrent program output to the email recipients.

1. Use the workflow to lunch the report and last node should be used for sending email . You need to code in such way that to get the report output and store in a table column and send that out put as an email .


2. Create a shell script to copy the report output from out directory and you can use use the mail utilities to send emails. Register as a host concurrent program with the shell script and include in a request set . you need to pass the request id and location of the out directory to this program to send email.
Here is very useful link
http://oracle.anilpassi.com/email-output-of-concurrent-program-request-2.html

3. Create another printer type , this should have custom driver and should have an argument to invoke a shell script copy the output from the out directory and send emails to the recipients.

Look at this metalink notes
https://metalink2.oracle.com/metalink/plsql/f?p=200:27:6310452058764939485::::p27_id,p27_show_header,p27_show_help:589887.993,1,1

https://metalink2.oracle.com/metalink/plsql/f?p=200:27:6310452058764939485::::p27_id,p27_show_header,p27_show_help:705949.992,1,1
https://metalink2.oracle.com/metalink/plsql/f?p=200:27:6310452058764939485::::p27_id,p27_show_header,p27_show_help:657394.993,1,1


4. You can create a shell script copy the file from the out directory and invoke an FTP Session and FTP the file to recipient’s FTP location . This will work for very large files .

You can refer these notes for additional info.

Note.1053277.6 HOW TO EMAIL A REPORT IN PDF OR HTML FORMAT
Note.1037049.6 WHAT IS THE SYNTAX FOR SENDING MAIL TO MULTIPLE RECIPIENTS
Note.1035315.6 HOW TO SEND REPORT IN EMAIL WITHOUT LOSING FORMATTING
Note 106549.1 How to send Oracle Reports output via email in specific format other than eps?


Thanks
Joy


Re: Email output pdf [message #352103 is a reply to message #351984] Mon, 06 October 2008 03:12 Go to previous messageGo to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi Joy,
Thank you very much for the information provided.

Yeah these link are giving how to send ... but no sample shell prog...

I did as follows with pl/sql

1.created the report as concurrent program.

2.checked the utl_file_dir and smtp_out_server parameters with the help of DBA.They were set correctly as per DBA.

3.created a directory on output directory of the sever.

4.downloaded the UTL_MAIL API with he help of DBA.

5.created on more concurrent prog of pl/sql stored procedure
in this i called the report with FND_REQUEST.SUBMIT_REQUEST
if that is completed/normel then
i called utl_mail.send_attach_raw to send the output of the request id geneted above.And emails were going Smile for a given email address.

Because of the API it can send attachment upto 32kb.

Now i wanted to send irrespective of the size of attachment.

I didn't find sample shell prog in the links provided by you.
if u can please provide me with sample shell script....because i haven't done shell prog before.

Thanks,
Kittu.


Re: Email output pdf [message #352250 is a reply to message #352103] Mon, 06 October 2008 21:43 Go to previous messageGo to next message
kjoy
Messages: 11
Registered: September 2008
Junior Member
Kittu

I am not a techi and there is a sample shell script in this link
Re: Email output pdf Sat, 04 October 2008 09:58
http://oracle.anilpassi.com/email-output-of-concurrent-program-request-2.html
abd show the script to DBA and he will turn around that script for your use.

Create a thread in unix forum .
Thanks

Joy







Re: Email output pdf [message #352308 is a reply to message #352250] Tue, 07 October 2008 00:52 Go to previous message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Joy,
Thanks for your reply.
Anyhow i have to do some R&D work on it Smile
I was thinking that upto 32kb was successful with pl/sql then y can't we do for more size... thats it.
So shell will be the replacement,right?

Thanks again,
Kittu.
Previous Topic: Regarding the Account and Party Merge
Next Topic: Concurrent Program to FTP file
Goto Forum:
  


Current Time: Sun Dec 04 10:36:24 CST 2016

Total time taken to generate the page: 0.12138 seconds