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
Tagged:
0