BI Publisher Bursting Report Output To UCM Channel

by admin

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

XXOraPartyDetailsUCMBurstTMPLDownload

Please watch the below video for detailed discussion :

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: BIP