Is it possible to send email with multiple attachments with the bursting process ?

Mathieul

Summary

Is it possible to send email with multiple attachments with the bursting process ?

Content

Hi everyone,

I'm working on the invoices process and my client would like to receive only 1 email with all the invoices,

the catch is that he want all the invoices in separated files.

Is it possible ?

If yes, how can I do it ?

For now, all I managed to do was ether put all the invoices in 1 pdf and send it in the email or send 1 email per invoice...

The problem with the later is that some client receive 100+ email in a day when the invoice process start...

Thank in advance for the help

Yogen

Hi,

To confirm,  Unfortunately there is no out of box or in-built way in BIP to attach multiple files in a single email and this a long pending enhancement request with Oracle.

However you can code custom java application to solve the problem. First send all separate invoices to a file location using FTP delivery channel through Bursting. Then design a custom java application to attach all files to one or more email and send it to clients.

We have done it successfully for the clients. You will need a good java expert and and have to understand use of BIP webservices to achieve this.

Please Mark helpful, if you find it useful.

Mathieul

I use a part of your answer, but I found another way which doesn't require the use of java.

I generated the files with the bursting process to a location on the server.

Then I lunch another program which send them with PL/SQL, here is the link that explain how  http://www.oracletool.com/blog/?p=64

So I do the following sequence

1 - Exec normal program

2 - Generate file with bursting

3 - Lunch subprogram of type PL/SQL

3.1 - Loop through list of email to send and send them

3.2 - generate report for all email sent

Thank for the tips

User_GJ7B7

@Mathieul ,

Below URL is not working, Can you please attach the code

http://www.oracletool.com/blog/?p=64

Regards,

Anand

Mallikarjuna Kuppauru-Oracle

Hi,

You can refer below MOS doc -

Bursting in EBS XML Publisher Consolidated Reference (Doc ID 1574210.1)

Regards,

Arjun