We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Email is not going through bursting

Received Response
18
Views
7
Comments
edited Oct 13, 2020 11:27AM in Reporting and Analytics for SCM 7 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!