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

Question

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

Rini_Varghese-Oracle · Answer

HI @User_LJKSA and @SAHAD, kindly let us know if you were able to achieve this requirement

SAHAD · Answer

Hi @User_LJKSA ,

Can you please let me know if you were able to achieve this?

Mallikarjuna Kuppauru-Oracle · Answer

HI @ User_LJKSA

Below are the available options you can able to use.

Adding Bursting Definitions (oracle.com)

I don't think you can able to send the Attachment as URL link  Using Direct Bursting Option,i hope you are trying to use the SAVE_OUTPUT output as OUTPUT_FORMAT.?

You can save the ouptput in shared path and then share the same as EMAIL .

Other comments are welcome.

Regards,

Arjun