Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to do email bursting without sending an attachment

Received Response
1281
Views
3
Comments

I am writing the bursting logic to send a text file .

I dont want the text file to be attached in the email.

Logic:

(select 'DATA' KEY

  ,'Billing' TEMPLATE

  ,'eText' TEMPLATE_FORMAT

  ,'en-US' LOCALE

  ,'TEXT' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'abc'||:P_MODE||'_'||TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') OUTPUT_NAME,

'xx@abc.com' PARAMETER1, -- to_email

'no-reply@oracle.com' PARAMETER3,

'test email' PARAMETER4,

'Process completed successfully

 PARAMETER5,

'FALSE' PARAMETER6

FROM dual)


Even the parameter6 is set to false, the file is still getting attached

Answers

  • Hamed Tolan
    Hamed Tolan Rank 1 - Community Starter

     ,'eText' TEMPLATE_FORMAT

    must be HTML not EText

  • user8139220
    user8139220 Rank 1 - Community Starter

    please share the logic of query content in mail body. urgent

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead
    1. Ensure TEMPLATE_FORMAT is Set Correctly

    TEMPLATE_FORMAT = 'HTML' instead of 'eText' that prevents attachments from being included.

    2. Modify the Delivery Channel

    Instead of 'EMAIL', try using 'NONE' or another delivery method that doesn’t generate attachments.