BI Agent Is Not Setting Corret Date Format In Prompt (Doc ID 2589298.1)

Last updated on NOVEMBER 10, 2022

Applies to:

Symptoms

Created a dashboard with a dashboard prompt containing a date filter. This date filter has a default sql value. When any user opens the dashboard from analytics page, or from BI Answers page, it works just fine.

From date filter prompt:select '01/01/' || replace(cast(year(now()) as char), ' ', '') from "Sales - CRM Pipeline"

To date filter prompt:select '31/12/' || replace(cast(year(now()) as char), ' ', '') from "Sales - CRM Pipeline"

The problem is we have an Agent to send this dashboard to certain users, Sales admin and sales rep  and for this user sales rep  it is giving error. For user sales admin the reports sends email just fine but sales rep is getting error  and when I open the Alert in BIA, it shows the following error:

"View Display Error
 
A date value was expected (received "31/12/2019").
Error Details
Error Codes: GYYEWLWG"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.