BI Agent Is Not Setting Corret Date Format In Prompt
(Doc ID 2589298.1)
Last updated on APRIL 15, 2020
Applies to:Oracle Fusion Sales Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.
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 Codes: GYYEWLWG"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document