@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!