BI Publisher (MOSC)

MOSC Banner

Bursting e-mail delivery with subject and body parameterized

edited Jul 7, 2014 11:34AM in BI Publisher (MOSC) 3 commentsAnswered ✓

Hi,

according with the Oracle Documentation Adding Bursting Definitions - 11g Release 1 (11.1.1) I can create a parameter, definited into Data Model, and use it into Bursting Definition Query.

I would like use parameters for e-mail subject and e-mail body. Like this:

select distinct
t.ID as "KEY",
'TemplateName' TEMPLATE,
'IT-it' LOCALE,
'pdf' OUTPUT_FORMAT,
'true' SAVE_OUTPUT,
'Rpt_bsp-'||rep_name||' '||To_Char(SYSDATE,'dd-mm-yyyy_hh24-mi-ss') OUTPUT_NAME,  
'email' DEL_CHANNEL, 
t.EMAIL PARAMETER1,
NULL PARAMETER2,  
'publisher@oracle.com' PARAMETER3, 
:P_EMAIL_SUBJECT PARAMETER4, 
:P_EMAIL_BODY PARAMETER5, 
'true' PARAMETER6 
from email_addresses_rep t

But :P_EMAIL_SUBJECT

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center