BI Publisher Bursting Report Output To UCM Channel

Data Model

SELECT 
  hp.party_id key,
  hp.party_name,
  hp.party_type 
FROM  hz_parties hp 
where 1=1
and rownum < 101

Bursting Query for UCM

select PARTY_ID as "KEY",
'XXOraPartyDetailsUCMBurstTMPL' TEMPLATE,
'en' LOCALE,
'xlsx' OUTPUT_FORMAT,
'WCC' DEL_CHANNEL,
'FA_UCM_PROVISIONED' PARAMETER1,
'FAFusionImportExport' PARAMETER2,
'fas16.student' PARAMETER3,
'UCM Bursting Report-' || PARTY_ID ||'-'|| TO_CHAR(SYSDATE,'HHMISS') PARAMETER5,
 PARTY_ID ||TO_CHAR(SYSDATE,'HHMISS') ||' Report.xlsx'  PARAMETER6,
'comments' PARAMETER7,
'FALSE' PARAMETER9
from hz_parties


/*
Note that to Deliver to ContentServer, the
DEL_CHANNEL parameter should be 'WCC'
PARAMETER1 parameter should be 'FA_UCM_PROVISIONED'
PARAMETER2 parameter should be 'FAFusionImportExport'
*/

Report

Please watch the below video for detailed discussion :