UCM/Content Server/FTP/Email Bursting Sample Query

For most outbound interfaces bursting to content server and then picking the file from UCM is the best approach for large extracts.
Default URL - https://POD.oraclecloud.com/cs

Also a cool feature I noticed is that bursting works to different targets (like the same file can be sent to email & FTP at the same time)

Below is the samplequery for busting to UCM or webcenter content server.

Sample Bursting Query for UCM Bursting
This is a sample query for bursting reports to a specific folder in the content server.
select distinct
product_status as "KEY", -- Split Key from data model SQL
'BurstTemp' TEMPLATE, -- Report template name
'en-US' LOCALE,
'PDF' OUTPUT_FORMAT, -- Output type
'WCC' DEL_CHANNEL, -- To send to content server
'FA_UCM_PROVISIONED' PARAMETER1, -- Content Server name
'FAFusionImportExport' PARAMETER2, -- Security group
'intergration_user' PARAMETER3, -- Author of the file to be shown in content server
'' PARAMETER4, -- Account (Optional)
'Test_Burst' PARAMETER5, -- Title
Product_Status|| TestFile.pdf'PARAMETER6, -- Output File name
Product_Status PARAMETER8, -- Content ID (Optional)
'false' PARAMETER9, -- Custom metadata (Optional)
'/Contribution Folders/Inbound' PARAMETER10 -- Folder path to deliver files
from products

'FA_UCM_PROVISIONED' is the default account for BI reports 'FAFusionImportExport' can be used as it setup by default.


Sample Bursting query for Email with output file name from BI Publisher-
SELECT 'Split_KEY' KEY, -- Split Key from data model SQL
'AP Rejections' TEMPLATE, --BI Report template
'en-US' LOCALE,
'xlsx' OUTPUT_FORMAT,
'EMAIL' DEL_CHANNEL,
'from@email.com' parameter1,
'cc@email.com' parameter2, --CC
'to@email.com' parameter3,
'Bursting Email TEST' parameter4,
'Please find the reported AP Invoice Rejections during the interface load.
Please review the errors and take appropriate actions.
Regards
Interface Team ' parameter5,
'true' parameter6,
'replyto@nowhere.com' parameter7,
'Rejections Output'|| to_char(sysdate,'dd_mm_yyyy') output_name FROM dual


Sample Bursting query for FTP with output file name from BI Publisher-

SELECT SEQ KEY
, 'TEST_REPORT' TEMPLATE -- Report template name
, 'en-US' LOCALE
, 'PDF' OUTPUT_FORMAT
, 'FTP' DEL_CHANNEL
, 'FTP Name Defined in BI Pub' PARAMETER1
, 'accountname' PARAMETER2
, 'password' PARAMETER3
, 'folder' PARAMETER4
, 'TEST_FTP_'||TO_CHAR(SYSDATE, 'DDMMYYHH24MISS')||'.pdf' PARAMETER5
, 'TRUE' PARAMETER6
, null parameter7
from dual