Not receiving emails from bursting query — Cloud Customer Connect
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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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