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

Question

Summary

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

Mallikarjuna Kuppauru-Oracle · Answer

Hi,

You can refer below MOS  doc -

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

Regards,

Arjun

User_GJ7B7 · Answer

@Mathieul ,

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

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

Regards,

Anand

Mathieul · Answer

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