Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

Need to send BIP bursting excel output as a url in email instead of attachment

Received Response
381
Views
4
Comments
User_LJKSA
User_LJKSA Rank 1 - Community Starter
edited Dec 19, 2023 11:08AM in Oracle Analytics Publisher

Hi

I have created a report where I can mail the excel output as an attachment. I need to mail that same excel as a url and not as an attachment. I have set "send email as url " option in admintration-> delivery configuration.

I can send pdf output as a url but not the excel one. PFB my bursting query:

SELECT DISTINCT 1 KEY,

'PayablesQueueListReport' TEMPLATE,

'en-US' LOCALE,

'xlsx' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'EMAIL_BURST_OUTPUT' OUTPUT_NAME,

EMAILID PARAMETER1,

'namita.x.singh@oracle.com' PARAMETER2,

'namita.x.singh@oracle.com' PARAMETER3,

'Payables Queue List Report' PARAMETER4,

'PFA the report.' PARAMETER5,

'false' PARAMETER6

FROM (SELECT trim(email_id) as EMAILID FROM (SELECT

 REGEXP_SUBSTR(:P_Notify, '[^;]+', 1, LEVEL) AS email_id

FROM

 dual

CONNECT BY

 REGEXP_SUBSTR(:P_Notify, '[^;]+', 1, LEVEL) IS NOT NULL))

Regards

Namita

Answers