Bursting Parameters in oracle Fusion

Bursting Parameters in oracle Fusion

As we know, Bursting helps to split and distribute the report output to the multiple desired recipients or business customers or suppliers. In this Oracle fusion bursting process, Bursting parameters plays a very important role. While writing the Bursting program logic, We need to mentioned the bursting parameters in the Bursting query which helps to executes and distribute the reports output. Bursting parameters help to decide, the Distribution channel (FTP, Email , FAX , Printer) and Recipients and other Critical Configuration information’s handled through the bursting parameters. Here below I will try to explain more on this Bursting Parameters in oracle fusion.

Detail Explanation and Types of bursting parameters in oracle fusion

While Writing the Report bursting query in oracle fusion , we do need to mentioned the Bursting parameters in that query. There parameters works based on the distribution channel ( Like Email , FTP, Fax , Printer). So For Email bursting Query , The parameters will have different role and functioning but for FTP bursting Query , These bursting parameters will work different.

Here below I will try to Share the bursting Queries for Email and FTP Distribution methods.

Here below We do write the  Bursting Logic in the BIP report.

 

Bursting Parameters for Email

select

Vendor_id as "KEY", -- It must be same as deliver by--

'RTF NAME OF THE BIP REPORT.rtf' TEMPLATE, -- Fusion Report template name--

'en-US' LOCALE,

'PDF' OUTPUT_FORMAT, -- output format pdf rtf text etc.--

VENDOR_NAME OUTPUT_NAME, --- Report Output Name Which you want to give ---

'EMAIL' DEL_CHANNEL, -- delivery channel name email,fax,print etc---

'To Email Address' PARAMETER1,-- to mail address---

'Cc Email Address' PARAMETER2,-- cc email address--

'TestEmail.email.com PARAMETER3',--From Email Address---

'Subject Of the Email' PARAMETER4, -- Email Subject--

'Hi

'||'Email body which will be show in the Bursting Email.

'||'Thanks & Regards

Test Person' PARAMETER5, -- Email body --

'True' PARAMETER6,-- attachment true/false value

:p_from_email  PARAMETER7 -- reply-to mail address--

from PO_VENDORS

Bursting Parameters for FTP In Oracle Fusion

select

Vendor_id as "KEY", -- It must be same as deliver by--

'RTF NAME OF THE BIP REPORT.rtf' TEMPLATE, -- Fusion Report template name--

'en-US' LOCALE,

'PDF' OUTPUT_FORMAT, -- output format pdf rtf text etc.--

VENDOR_NAME OUTPUT_NAME, --- Report Output Name Which you want to give ---

'FTP' DEL_CHANNEL, -- delivery channel name email, fax,print,ftp etc---

'testserver.com' PARAMETER1 -- Server name---

'apuser’ PARAMETER2,-- Username --

‘34553’ PARAMETER3’ ,--Password ---

‘testfile’ PARAMETER5, --Remote File Name --

'True' PARAMETER6, Secure (set this value to 'true' to enable Secure FTP)

 from PO_VENDORS

(PARAMETER 7-10 are not used)