Facing Issue With Account Name Prompt. (Doc ID 2187443.1)

Last updated on NOVEMBER 09, 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

Account Name prompt 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 specificed criteria didn't result in any data. This is often caused by ...

Filters
  Account Name is equal to 12 VOLT-TRAVEL / STOMP ENTERPRISES, A & I PRODUCTS, A&M MARINE INC.
"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select "historical" Account names from the prompt in the report in question.
     - "Historical" records are defined as:  records created before the report was developed.
2. Apply the filters by running the report.
3. Note that No results are returned by the query.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

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