Oracle Fusion 39-2: Multi file Bursting Concept in fusion | Send multi file by using bursting

Topic:- Send your full report output thru fusion bursting program y using few steps with me, Know Bursting in very simple words with me.
Bursting Base Video :-    • Oracle Fusion 39: Bursting Concept in...  
Single FIle Bursting : -    • Oracle Fusion 39-1: Single file Burst...  
Multi File Bursting :    • Oracle Fusion 39-2: Multi file Bursti...  

From today onward start learning Oracle cloud ERP or you can say Oracle fusion ERP.

it very helpful to all the students and beginners as well.
so keep going with oracle shooter.

PlayList:- Oracle Fusion
Concept :- #Oracle #ERP #FUSION

Full Blogs Link:-
https://oracleshooter.blogspot.com

My Vlog Channel link:-
   / mylifemyface  

Related Playlist:-
0. PLSQL
:-    • PLSQL  
1. SQL
:-    • SQL  
2. Oracle Apps Technical
:-    • Oracle Apps Technical  
3. OAF
:-    • OAF  
4. Unix / Linux
:-    • Unix / Linux  
5. Company Knowledge
:-    • Company Knowledge  
6. Information
:-    • Information  
7. Oracle ERP
:-    • Oracle ERP  


Contact Info:-
Instagram:-   / mylifemyface  
Facebook :-   / mylifemyface11  
Twitter :-   / mylifemyface11  
Blogger :- https://oracleshooter.blogspot.com
Email Id :- [email protected]
Telegram Link:- https://t.me/joinchat/LKP54BKdxH8-Gza...
whatsapp Group :- https://chat.whatsapp.com/ISOb4Zs84FR...
----------------------------------------------------------------------------------------------------------------------------------------

SELECT VENDOR_NAME KEY -- Split By --
, 'XX_BURSTING_TEMP' TEMPLATE -- Report or temaple Name --
, 'en-US' LOCALE -- English Language --
, 'PDF' OUTPUT_FORMAT -- PDF, EXCEL, RTF, CSV, HTML , XLS
, 'EMAIL' DEL_CHANNEL -- MAIL, FAX, FTP, FILE, PRINT, SFTP --
, VENDOR_ID||'.pdf' OUTPUT_NAME -- File output Name --
, '[email protected]' Parameter1 -- TO Mail --
, '[email protected]' Parameter3 -- FROM Mail --
, 'Supplier Invoice detail' Parameter4 -- Mail Subject --
, 'Please find the attached document for Invoice Detail' 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 ( 300000001860403, 300000003359970, 300000003424026, 300000003359503, 300000003359878, 300000003359933)
)

SELECT VENDOR_NAME KEY -- Split By --
, 'XX_MSTR_DET_SUB_G_L_TEMP' TEMPLATE -- Report or temaple Name --
, :xdo_user_report_locale LOCALE -- English (es) Language --
, 'PDF' OUTPUT_FORMAT -- PDF, EXCEL, RTF, CSV, HTML , XLS
, 'EMAIL' DEL_CHANNEL -- MAIL, FAX, FTP, FILE, PRINT, SFTP --
, VENDOR_ID OUTPUT_NAME -- File output Name --
, Parameter1 -- TO Mail --
, Parameter2 -- CC Mail --
, Parameter3 -- FROM Mail --
, Parameter4 -- Mail Subject --
, Parameter5 -- Mail Body --
, Parameter6 -- Mail having Attachment or not --
, Parameter7 -- Replt-to --
, Parameter8 - Mail BCC-
FROM (
select DISTINCT B.VENDOR_NAME , B.VENDOR_ID,
'[email protected]' Parameter1, -- TO Mail --
NULL Parameter2, -- CC Mail --
'[email protected]' Parameter3, -- FROM Mail --
'Invoice detail' Parameter4, -- Mail Subject --
'Please find the attached document for Invoice Detail' Parameter5, -- Mail Body --
'true' Parameter6, -- Mail having Attachment or not --
'Reply-To' Parameter7, -- Replt-to --
NULL Parameter8 - Mail BCC-
From ap_invoices_all A, POZ_SUPPLIERS_V B
WHERE A.VENDOR_ID = B.VENDOR_ID
AND A.VENDOR_ID in ( 300000001860403, 300000003359970, 300000003424026, 300000003359503, 300000003359878, 300000003359933)
)