1,609 total views
In order to achieve the hyperlink in email body of BI Publisher Report, we need to write html code in the bursting SQL Query.
Want to learn Fusion Technical tools? Checkout this article
We will add the bursting query to the Data Model in the bursting query section.
Sample bursting SQL for Email delivery option:
select '1' KEY, — must be same as deliver by 'TEST' TEMPLATE,– report template name 'RTF' TEMPLATE_FORMAT,– template format 'en-US' LOCALE, 'PDF' OUTPUT_FORMAT,– output format pdf rtf text etc.. 'EMAIL' DEL_CHANNEL,– delivery channel name email,fax,print etc.. 'Test Email' OUTPUT_NAME, 'email@example.com' PARAMETER1,– to mail address 'firstname.lastname@example.org' PARAMETER2,– CC mail address 'email@example.com' PARAMETER3,– from mail address 'Test Subject' PARAMETER4, — subject '<html>Hi'||' '||'xxxx'||',<br/><br/> The survey will take approximately 10 minutes. Please read each question carefully and select the response that best fits your experience.'<br/><br/> <a href=' || ”'http://www.google.com”' || '>Click here to take the Exit Survey</a><br/><br/>' Thank you,<br/>Company HR</html>' PARAMETER5, — message body 'true' PARAMETER6– attachment true/false value 'firstname.lastname@example.org' as PARAMETER7, — reply-to mail address from dual <a href has been used to add the hyperlink.. <br/> has been used to add new line character..
Similarly we can add an image to the email body using the below html command:
'<img src=”' || https://www.w3schools.com/images/w3schools_green.jpg || '” alt=”alternate text for image”>'
We need to upload the image to UCM and then copy the UCM hyperlink and use it in the bursting SQL.
Tip: We can do bursting for Email/FTP delivery options. The output will be burst by the split by key and will get delivered to the deliver by key values.
Latest posts by Sricharan Monigari (see all)
- Migration of Objects – Valuesets, Lookups, Fast Formula, Payroll Flows from one POD to another - November 30, 2020
- Renaming HCM Extracts is a possibility from 20D - November 24, 2020
- Sangam20 – Oracle Users Group Conference - November 23, 2020
- Passing Parameter values from Flow Instance to HDL Transformation Formula - November 23, 2020