Report Prompt of custom String field not returning results for selections even though corresponding results exist (Doc ID 2187460.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.1.11.1.0 version, Analytics

One of the prompts does not retrieve data for historical records.

I have created a BI Analysis Report, in that report I have took Account Name as Prompt, but I am facing the issue with Historical data, when I give account name for historical data, I am not getting Results, but for Test Records, data is coming.

This is strange behavior for reporting on historical data.


ERROR
-----------------------
"
No Results
The specified criteria didn't result in any data. This is often caused by ...
"



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select an option from the prompt in the report in question.
2. Apply the filters by running the report.
3. Note that No Results are returned by the query.



BUSINESS IMPACT
-----------------------
Report is non-functional. Report is used to return vital data.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms