Bursting BI Publisher HTML Email
Hi Experts,
I have created the Bursting Definition below for testing purposes.
select
har.REQUEST_ID as KEY,
har.RUN_ID as TEMPLATE,
'en-US' as LOCALE,
'PDF' as OUTPUT_FORMAT,
'EMAIL' as DEL_CHANNEL,
'America/Los_Angeles' as TIMEZONE,
'GREGORIAN' as CALENDAR,
har.RUN_ID as OUTPUT_NAME,
'xxxx.yyyyy@abc.co.nz' as PARAMETER1,
'ernw.bi.sender@workflow.mail.ap1.cloud.oracle.com' as PARAMETER3,
'Test of BIP Bursting' PARAMETER4,
'<pre><p style="font-family: Open Sans,sans-serif; font-size:12pt; color: #18376a;">Hello '||har.REQUEST_ID||' World</p></pre>' PARAMETER5,
'false' PARAMETER6
from
HRC_ALERT_RUNS har
Tagged:
0