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 .
Bursting Base Video :- • Oracle Fusion 39: Burs...
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:-
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 :- oracleshooter.blogspot.com
Email Id :- [e-mail]
Telegram Link:- t.me/joinchat/LKP54BKdxH8-Gza...
whatsapp Group :- 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 --
, '[e-mail]' Parameter1 -- TO Mail --
, '[e-mail]' 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,
'[e-mail]' Parameter1, -- TO Mail --
NULL Parameter2, -- CC Mail --
'[e-mail]' 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)
)

[@ajaypandey7154]

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

[@jitusethi5327]

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

[@vikasprajapati4004]

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

[@meghasingh9762]

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

[@andrewnainggolan635]

you've saved my career, Sir. thank you

[@venkatamaneswararaodudala2914]

Good Concept, thanks Bhayya.

[@vickykumar-ks1vh]

thanks sir ji

[@ABUNDANCETIPS]

Thank you so much 🙏

[@MohsinKhanSC]

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

[@dauleshsharma-bn6qe]

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

[@rahulshahapure4607]

Superb video.. great explanation!! 🙂👍

[@OracleShooter]

Thanks Rahul

[@farhaalam6718]

Good Afternoon Sir,
Such a nice and well explanation

[@OracleShooter]

Thank you so much

[@SudheerKumar-is5dd]

👏

[@amitgupta-is3fu]

Hi Manoj Sir, Any plans for SCM Fusion vedios?

[@ri3vy]

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

[@maneeshrockzz9273]

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

[@Jump_tiger]

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

[@mohommedkhan2165]

sir how you prepare that application command

[@rangaprasad2728]

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 ?

[@OracleShooter]

Plz see otbi report with more then 2 subject area

[@harshchauhan5404]

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