Oracle fusion ERP - Multi file bursting | Send Multiple files by using Bursting

Usecase: Here we will split the data block using vendor name as key and send the multiple files using Email delivery channel.

Used Data model SQL query:

SELECT B.VENDOR_NAME, B.VENDOR_ID,

A.INVOICE_ID,

A.INVOICE_NUM,

A.INVOICE_AMOUNT,

A.AMOUNT_PAID,

A.INVOICE_DATE,

A.DESCRIPTION,

A.BATCH_ID,

A.BASE_AMOUNT

FROM AP_INVOICES_ALL A, POZ_SUPPLIERS_V B WHERE A.VENDOR_ID =B.VENDOR_ID AND A.VENDOR_ID IN (300000047414635,300000047414571 3000000047414503,300000047414679)

Used Bursting Query:

Select Vendor_name KEY, -- split by --

'MultiReport1_Temp' TEMPLATE, -- TEMPLATE NAME OR REPORT NAME --

'en-US- LOCALE, -- English Language--

'PDF' OUTPUT_FORMAT, -- PDF, EXCEL,RTF,CSV,HTML,XLS--

VENDOR_ID||'.pdf' OUTPUT_NAME, -- Output File Name --

'EMAIL' DEL_CHANNEL, -- MAIL,FAX,FILE,FTP,PRINT,SFTP --

'Test@test.com' PARAMETER1, -- To mail.--

'Oracle@oracle.com' PARAMETER3 -- FROM MAIL --

'Supplier Invoice Details ' PARAMETER4, -- MAIL SUBJECT --

'Please find attached document for Invoice Details' PARAMETER5, --MAIL BODY--

'true' PARAMETER6 -- MAIL HAVING ATTACHMENT OR NOT--

FROM(

SELECT DISTINCT B.VENDOR_NAME, B.VENDOR_ID FROM AP_INVOICES_ALL A, POZ_SUPPLIERS_V B WHERE A.VENDOR_ID =B.VENDOR_ID AND A.VENDOR_ID IN (300000047414635,300000047414571 3000000047414503,300000047414679)

)

Detailed screenshots: