BI Publisher Query - Send Bursted Email (HTML) with separate PDF Attachment — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Publisher Query - Send Bursted Email (HTML) with separate PDF Attachment

edited Nov 6, 2019 9:15AM in Reporting and Analytics for HCM 2 comments

Summary

Is it possible to have two outputs in a BI Publisher Report?

Content

Hello,

We have a BI Publisher report which sends an email (HTML) output, split and delivered by employee number, to certain employees.  As well as the email itself, we'd like to be able to attach a document as a PDF to each email.  Aside from setting PARAMETER6 in the bursting SQL to TRUE, I'm unsure as to how to indicate which document should be attached or whether this is even possible.

Any guidance would be appreciated.  

 

Version

HCM 19C

Code Snippet

SELECT ColleagueNumber as KEY,
'ReportTemplate' as TEMPLATE,
'HTML' as OUTPUT_FORMAT,
'en-UK' as LOCALE,
'EMAIL' as DEL_CHANNEL,
Email as PARAMETER1,
'SenderEmailAddress' as PARAMETER3,
'EmailSubject' as PARAMETER4,
NULL "PARAMETER5",
'true' as PARAMETER6,
'BCCAddress' as PARAMETER8

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!