nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

how to burst a email with multiple attachments attached

Kamalakannan Natarajan

Find more posts tagged with

Fusion HCM Analytics

Accepted answers

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27843/how-to-burst-a-email-with-multiple-attachments-attached

Hi @Kamalakannan Natarajan,

Welcome to the Oracle Analytics Community!

Please take a look into the following posts which might be useful.

Can we burst multiple templates in BI Publisher? — Cloud Customer Connect

Multiple attachments through BIP Bursting — Cloud Customer Connect

Hope this help.

Thank you.

All comments

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/27843/how-to-burst-a-email-with-multiple-attachments-attached

Hi @Kamalakannan Natarajan,

Welcome to the Oracle Analytics Community!

Please take a look into the following posts which might be useful.

Can we burst multiple templates in BI Publisher? — Cloud Customer Connect

Multiple attachments through BIP Bursting — Cloud Customer Connect

Hope this help.

Thank you.

RVohra

@Kamalakannan Natarajan , Welcome to the Oracle Analytics Community! Thanks for your question.

A. Enabling a Report for Bursting

Prerequisite: A report defined in BI Publisher. The report data must contain an element by which the report will be split and an element by which the report will be delivered.

Enabling a report for bursting consists of the following steps:

    1. Open the report in Edit mode.

    2. Select Bursting under the report definition.

    3. Select the Enable Bursting check box.

    4. Select the Split By and Deliver By elements.
    The Split By element is the data element from the report file that you wish to split the report by. For example, to split a batch of invoices by each invoice, you may use an element called CUSTOMER_NAME.

    5. The Deliver By element is the data element from the report file by which to determine the delivery method. In the invoice example, it is likely that each invoice will have delivery criteria determined by customer, therefore the Deliver By element may be CUSTOMER_ID.

    6. Select the data source for the delivery XML.

    The delivery XML can be sourced from the same data source as the main data set, or it can be generated from a different data source.

    7. Enter the SQL query to build the delivery XML.

        Parameter Mapping:-
          Channel = Email
          Parameter 1=Email address
          Parameter 2=cc
          Parameter 3=From
          Parameter 4=Subject
          Parameter 5=Message Body
Parameter 6= Attachment (true/false) Note that if your output format is pdf, you must set this parameter to "true" to attach the pdf to the email
          Parameter 7=Reply-To

The template, template format, locale, output format, delivery channel, and customer e-mail address are all specified in elements from the delivery data source and will be returned by the query. The SQL to generate the delivery XML for this example is as follows:

Note:

    select distinct
    CUSTOMER_ID "KEY",
    CST_TEMPLATE TEMPLATE,
    TMPL_TYPE TEMPLATE_FORMAT,
    CST_LOCALE LOCALE,
    CST_FORMAT OUTPUT_FORMAT,
    CST_DEL_CHAN DEL_CHANNEL,
    CST_EMAIL PARAMETER1,
    '<EMAIL_ADDRESS>' PARAMETER2,
    '<EMAIL_ADDRESS>'PARAMETER3,
    'Your Invoices' PARAMETER4,
    'Hi'||CUST_FIRST_NAME||chr(13)|| 'Please find attached your
    invoices.' PARAMETER5,
    'true' PARAMETER6,
    ' donotreply@nowhere .com ' PARAMETER7
    from customers;

B. Scheduling a Report to Be Burst
If your report has been enabled for bursting, the Schedule Report page will include a Burst Report
option under the Job Properties region. Schedule the reports or run immediately by specifying it in the Time region and submit the report.

Email would be delivered to all Email addresses mentioned in PARAMETER1 and PARAMETER2 columns of SQL query.

Hope it helps!

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

GTA 50