Oracle Transactional Business Intelligence

Has Bursting SQL Functionality Changed with 22B?
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
)
Answers
-
Yes, I think it has changed.
Can you check this:
-
Please bookmark this URL, this is a list that is actively maintained and has most of the known issues covered and solutions/workarounds are also provided : https://docs.oracle.com/en/cloud/saas/otbi/otbi-known-issues/index.html#TBIKI-GUID-A1FFF714-E223-416D-86BD-EF09571B2D7D