Email Bursting

Summary

How to send BI report pdf output as attachment

Content

There is a requirement to send the pdf output of a custom BI report to employees. I have added the bursting definition in my data model. But after running the report ,no mail is fired. What can be the issue ?

 

Here is my sql query for bursting definition:

select  (select email_address   
                from per_email_addresses
                where email_type = 'W1'
                and person_id = per.person_id
                and rownum=1) KEY,
                --:P1 TEMPLATE,
                'en-US' LOCALE,
               'PDF' OUTPUT_FORMAT,
                'EMAIL' DEL_CHANNEL,
                'email' PARAMETER1,
                (select email_address
                from per_email_addresses