How to Schedule an OAC workbook as an Email Output (PDF or PNG)

User_57K2N · Jul 16, 2024 4:05PM

Dear Experts,

Please let me know a solution on how to schedule an OAC Workbook to be sent as an email (PDF or image) periodically (Daily , Weekly, Monthly). Since we have enabled the Preview Workbook Email Scheduler but still we are not getting email and also scheduled job running morethan 25 minutes and showing below error message, Please review below screenshot and provide your inputs.

Federico Venturin - Oracle · Jul 16, 2024 4:13PM

Hi @User_57K2N ,

Did you restart your OAC instance after enabling the Preview Workbook Email Scheduler?

Did you setup an email server to deliver workbooks?

Does you workbook work as expected when you open it?

User_57K2N · Jul 16, 2024 4:17PM

Hi @Federico Venturin ,

Thanks for your response.

Please find my response below ,

Did you restart your OAC instance after enabling the Preview Workbook Email Scheduler? —> It is Enabled

Did you setup an email server to deliver workbooks? —> Can you please guide to check this setup

Does you workbook work as expected when you open it? —> it opens with a minute

Federico Venturin - Oracle · Jul 16, 2024 4:21PM

Hi @User_57K2N ,

Please refer to the following documentation for setting up an email server: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-email-server-deliver-reports.html

[Deleted User] · Jul 16, 2024 4:24PM

Hello @User_57K2N

Welcomed to the community, please update your profile, so we know with whom we are communicating with.

Thank you!

User_57K2N · Jul 16, 2024 4:25PM

Hi @Federico Venturin

Thanks for your quick response. Getting below error while opening Mail Setting under console. I have the service administrator group

There was a problem attempting to retrieve the mail settings. { type : detailError , errorType : DETAIL_ERROR , errorMessage : HTTP 401 Unauthorized }

Please guide me to ratify this issue.

Gianni Ceresa · Jul 16, 2024 6:26PM

@User_57K2N ,

Look at the linked discussion. Is your OAC a FDI/NSAW integrated OAC instance? Then this discussion tells you about the HTTP 401 when looking at the mail settings.

https://community.oracle.com/products/oracleanalytics/discussion/22231/oac-error-retriveving-mail-setting