OBIA Dashboard Prompt is Displaying NULL Value for Some Prompts (Doc ID 2040635.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

In dashboard prompts (choice list) with time dimensions like quarter and month , NULL value is being displayed along with the other values. This is not happening with the year prompt.

On executing the back end query for 'Quarter' filter, it is not fetching NULL but in the report it is showing NULL value. Same is the case with 'Month.

The same issue is also being experienced with a few other prompts as well like:

 

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