Oracle Fusion 39-1: Single file Bursting Concept in fusion | Send single 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 .

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:-

My Vlog Channel link:-

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

Contact Info:-
------------------------------------------------------------------------------------------------------------------------------------------------

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 --
, '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,
NULL Parameter2, -- CC 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)
)

[jitusethi]

Thanks alot for all videos Manoj sound like one of my friend is teaching me. love the way you explain buddy.. Big fan

[ajaypandey]

Thank you sir...हमें ज्ञान का प्रकाश प्राप्त करने के लिए.🙏

[andrewnainggolan]

you've saved my career, Sir. thank you

[vikasprajapati]

Sir ye maine apne integration me use kiya... Thanks for such a unique content 💖

[meghasingh]

Hello Sir,

Your teaching method is too good, please make the video for Extract.

[farhaalam]

Good Afternoon Sir,
Such a nice and well explanation

[Guru-ill]

Hi manoj. our client no Add description emaill only script using send the mail is possible?

[mohommedkhan]

sir how you prepare that application command

[dauleshsharma-bnqe]

Hi Manoj can you tell if our client dont want this extra key column that we have added, how we can send report then

[maneeshrockzz]

sir add destinations lo to address cc avi evvakundane bursting avvali kada sir

[MohsinKhanSC]

Manoj bhai, instead of developing a ESS Job, can we do report bursting in bip bursting..

[amitgupta-isfu]

Hi Manoj Sir, Any plans for SCM Fusion vedios?

[Jump_tiger]

sir we have no instance how to take instance to do practice

[rivy]

Sir ye kaam toh hum report schedule k thru bhi kar sakte h na sayad

[harshchauhan]

I am not getting complete numeric value after decimal how can I get complete value in output ?

[rangaprasad]

In OTBI report we have taken 2 subject areas but when we ran report data was not getting but in backend data was there so what was the issue. can you please suggest ?