Oracle Transactional Business Intelligence

Products Banner
Home› Oracle Analytics› Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Has Bursting SQL Functionality Changed with 22B?

Received Response
18
Views
2
Comments
jeffMA71
jeffMA71 ✭
in Oracle Transactional Business Intelligence

Summary:

Bursting SQL not working as it did before upgrade to 22B

Content (required):

Simple bursting sql to send email when running a report. Worked fine up until 22B. Now bursting SQL will only fire if you take additional steps of going into Schedule screen.

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT DISTINCT H.header_id KEY,

:template_name TEMPLATE,

'en-US'   LOCALE,

'PDF'   OUTPUT_FORMAT,

'EMAIL'   DEL_CHANNEL,

'XXXX_SO_Acknowledgement_'||H.ORDER_NUMBER OUTPUT_NAME,

NVL(:ToemailAddress,'[email protected]') PARAMETER1, -----: Email address

'' PARAMETER2, ------: cc

'[email protected]' PARAMETER3, ------: From -- created by/submitted by

'XXXX Sales Order# '||H.ORDER_NUMBER PARAMETER4, ------: Subject

'<html><body>

<STYLE>

TABLE.stand {font-size:10pt; width:800; FONT-FAMILY:"Tahoma", "Arial", "times", "serif"}

</STYLE>

<DIV>

<TABLE class = "stand" border=0 cellSpacing=0 cellPadding=0 width=800>

<TBODY>

<TR>

<TD width=68><IMG width=179 height=59 src="https://www.xxxx.com/themes/brooks/logo.svg"></TD>

<TD align=right>XXXX Life Sciences<BR><A href="http://www.xxxx.com/" rel=nofollow 

target=_blank>www.xxxx.com</A></TD></TR></TBODY></TABLE>

<TABLE class="stand" border=0 cellSpacing=0 cellPadding=4 width=800 bgColor=#826EC3>

<TBODY>

<TR>

<TD align=left><font color="white">Sales Order Acknowledgement</TD>

</TR></TBODY></TABLE>

<TABLE class="stand" border=0 cellSpacing=0 cellPadding=0>

<TBODY>

<TR>

<BR>

<TD>Please find attached sales order acknowledgement from XXXX

<BR>Should you have any questions or concerns, please contact your Customer Care Contact.

<BR>

<BR>Thank you

</TD>

</TR>

<div>

<TABLE class="stand" border=0 cellSpacing=0 cellPadding=0>

<TBODY>

<TR>

<TD>

</TR></TBODY></TABLE>

<DL></DL><WBR><WBR></DIV></DIV></DIV></div></body></html>

</body></html>' PARAMETER5, ------: Message body

'true' PARAMETER6, ------: Attachment value ('true' or 'false'). If your output format is PDF, you must set this parameter to "true" to attach the PDF to the e-mail.

'[email protected]' PARAMETER7, ------: Reply-To

null PARAMETER8 ------: Bcc

FROM DOO_HEADERS_ALL H

WHERE 1 = 1

AND h.status_code <> 'DOO_REFERENCE'

and h.order_number = :OrderNumber

AND h.change_version_number = (SELECT MAX (change_version_number)

                                   FROM doo_headers_all

                                  WHERE order_number =:OrderNumber                                  

                          )

 

Tagged:
· Share on FacebookShare on Twitter

Answers