My Oracle Support Banner

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.

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

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
Symptoms
Cause
Solution
References


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