Email is not going through bursting

Content

Hello Team,

We are trying to burst the report output to email from BI publisher, but it is not working. When I schedule to report that has the bursting query to send the output to email it does not send the email. However when I resend it from the report job output, I receive one email (I guess the other email is cached somewhere from the schedule job)

Please let me know if you came across anything like this.

Regards,

Abhishek Kumar

 

Code Snippet

SELECT DISTINCT paha.auction_header_id||'-'||pple.trading_partner_id as "KEY",
(CASE WHEN pns.style_name = 'LTC Negotiation Style'
THEN 'LTCTemplate'
ELSE 'CommAndTransTemplate'
END) TEMPLATE,                                           
'RTF' TEMPLATE_FORMAT,
'en-US' LOCALE,
'HTML' OUTPUT_FORMAT,
'RFQ PDF Report' OUTPUT_NAME,
'EMAIL' DEL_CHANNEL,
(CASE 
WHEN scv.email_address IS NOT NULL AND pbp.additional_contact_email IS NULL
THEN scv.email_address
WHEN scv.email_address IS NULL AND pbp.additional_contact_email IS NOT NULL 
THEN pbp.additional_contact_email 
WHEN scv.email_address IS NOT NULL AND pbp.additional_contact_email IS NOT NULL 
THEN scv.email_address||','||pbp.additional_contact_email 
END) PARAMETER1,
pea.email_address PARAMETER2,
'Boeing Distribution