FTP bursting in oracle fusion

FTP bursting in oracle fusion

In this post , We will be discuss about FTP bursting in oracle fusion. FTP bursting is the method in which we can deliver the reports outputs directly in to the FTP servers. In this process , when the reports completes successfully , system automatically transfers the reports output to the FTP server. We need to do some setups in the BIP report to enable the FTP bursting in oracle fusion. Here below is the complete steps to enable the FTP bursting in oracle fusion.

Step by Step to Implement the FTP bursting in oracle fusion

Step1:- First thing I am assuming , we know the BIP reporting tool in Oracle cloud. If you are familiar with BIP in Oracle Fusion then you can refer my OLD posts.

Step2:- Go to the BIP report Data Model to which we want to do the Bursting.

Step3:- For Example , here below is the Report Data Model and i want to Create the Bursting according to the vendor.

Like Report output should Split and send according to the supplier basis so here below VENDOR_ID is the important column of this report and we will use this column to split the report output for different suppliers.

FTP bursting in oracle fusion

Step4:- In the report Data Model , We need to go to Bursting Open as highlighted below.

Step5:- Now click on the '+' icon to create the bursting Logic for this report.

Step6:- Here below we are designing the Bursting logic in Cloud BIP reports.

Split By and Delivery By are the Two important Parts in Designing the Bursting Logic.

Split By means , We can to divide the reports output on the basis of which column of the report. For Example , We will use Vendor_id column so that report output will be split based on the Vendor and if the report output having 3 suppliers output then Bursting First divide/split this report output in 3 parts based on Vendor Id and then send three reports output in FTP.

Delivery By means , This is uses to sent the report output through FTP. Here also we need to specify the report column based on which we want to deliver the report output.

Split By is the Parent Column and Deliver by is the child Column of this Parent Split by Column.

So FTP bursting deliver logic works on the basis of Deliver By.

Step 7:- Here below i have used the common Vendor_ID column of the report in Split By & Deliver By logic.

Split By and Delivery By are the Two important Parts in Designing the Bursting Logic.

Split By means , We can to divide the reports output on the basis of which column of the report. For Example , We will use Vendor_id column so that report output will be split based on the Vendor and if the report output having 3 suppliers output then Bursting First divide/split this report output in 3 parts based on Vendor Id and then send three reports output in FTP.

Delivery By means , This is uses to sent the report output through FTP. Here also we need to specify the report column based on which we want to deliver the report output.

FTP and SFTP

PARAMETER1: Server name PARAMETER2: Username PARAMETER3: Password PARAMETER4: Remote Directory PARAMETER5: Remote File Name PARAMETER6: Secure (set this value to 'true' to enable Secure FTP) (PARAMETER 7-10 are not used)

In the SQL Query we will use this below SQL Query

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)

Step8:- Here below is the final Bursting Logic written in the BIP report.