Bursting with logo in body and file attached

Guido Masciello

Good evening,

I need to send emails using bursting in Oracle HCM. These emails must include the Excel output of the report as an attachment and an email body formatted with HTML, particularly with a logo image.

1. Currently, if I use the solution of an HTML template within bursting, I can create the email body with all the required formatting and the logo image.

SELECT distinct

EMAIL_W KEY,

‘rtf template’ TEMPLATE,

'en-EN' LOCALE,

'HTML' OUTPUT_FORMAT,

'false' SAVE_OUTPUT,

'EMAIL' DEL_CHANNEL,

EMAIL_W PARAMETER1, --To

‘XXX@YYY.IT' PARAMETER3, --From

:pSubject PARAMETER4, -- Subject

null parameter5,

'true' PARAMETER6 – Attachment

2.

However, with this solution, no file is attached to the email.

1. To attach the file, I use the following SQL:

SELECT distinct

'BURST_KEY' KEY,

'TT' TEMPLATE,

'en-EN' LOCALE,

'EXCEL' OUTPUT_FORMAT,

'true' SAVE_OUTPUT,

'EMAIL' DEL_CHANNEL,

'FND_TIMEZONE' OUTPUT_NAME,

‘’X@Y.IT’ PARAMETER1, --To

'NO-REPLAY@oracle.com' PARAMETER3, --From

'SUBJECT' PARAMETER4, -- Subject

'<pre><p style="font-family: Open Sans,sans-serif; font-size:12pt; color: #18376a;">Good morning …..!</p></pre>' PARAMETER5, -- Body

'True' PARAMETER6 – Attachment

With this solution, I can successfully attach the file and format the email body. However, how can I include the logo image in the email body?

Thank you for your assistance.

Best regards,

MandeepGupta

Hi @Guido Masciello ,

As per my understanding this is not achievable. An idea was submitted for this a few days back:

https://community.oracle.com/products/oracleanalytics/discussion/comment/60789#Comment_60789

Thanks.