Not receiving emails from bursting query
Summary:
We are trying to develop a bursting query to send email notifications, but are not receiving any emails though the report job shows to be successful.
Content (please ensure you mask any confidential information):
I have the bursting query added to a data model:
This is the query I am using (email addresses have been replaced):
SELECT
trx_number KEY, -- Split by
'Bursting_Layout' TEMPLATE, -- Catalog
:xdo_user_report_locale LOCALE, -- English (es)
'PDF' OUTPUT_FORMAT, -- PDF,HTML,CSV,RTF,EXCEL
'EMAIL' DEL_CHANNEL, -- EMAIL/FAX/FTP/FILE/SFTP/PRINT/WEBDAV
'AR INVOICE_'||trx_number OUTPUT_NAME, -- Output Name