Oracle BI Publisher, Email bursting, attach the report and formatted text in the body of the email

Question

Summary

Oracle BI Publisher, ​Email bursting, attach the report and formatted text in the body of the email at the same time.

Content

Oracle BI Publisher, ​Email bursting, attach the report and formatted text in the body of the email at the same time.

​​At the moment I can attach my report, for example as pdf or excel, but the body of the email, is plain text. (Parameter5)

​

​Any suggestion?

​

​Can we have a report as email body and a different report as attachment? At the same time?

​​Why the report can be the body of the email OR the attachment?

​

Thanks G.

Mdibrahim Karur · Answer

Hi,

Use the below code in control file message section.

<xapi:message id="12345678" to="${CP_TO_ADD}" cc="${CP_CC_ADD}" attachment="true" content-type="text/html" subject="sfagsgsdgsdga" >

Thanks

Md Ibrahim

Mdibrahim Karur · Answer

Hi,

Check the control file used for bursting , that it allow html data also.

If required any help, share your control file here. mdibrahim.karur@gmail.com

Regards,

Md Ibrahim

Gabriele Bertaina · Answer

Hi Brajesh,

Thanks for your answer.

I have tryed to put in the parameter5 (body) formatted html, but the attribute is not rendered correctly, it shows the html syntax.

I'm not sure of what you mean with use the body as HTML.

This is a sample of my bursting query:

SELECT DISTINCT

:P_TEMPLATE as TEMPLATE,

'en-AU' LOCALE,

'pdf' OUTPUT_FORMAT,

:P_OUTPUT_NAME as OUTPUT_NAME,

'EMAIL' del_channel,

:P_EMAIL_TO PARAMETER1,

:P_EMAIL_CC PARAMETER2,

:P_EMAIL_FROM  PARAMETER3,

:P_EMAIL_SUBJECT PARAMETER4,

:P_BODY as PARAMETER5,

'true' PARAMETER6,

:P_REPLY_TO PARAMETER7,

:P_EMAIL_BCC PARAMETER8

FROM DUAL

if I put "html" as OUTPUT_FORMAT the report will be rendered an not attached; even if I have true as parameter6.

Could you please give me a sample?