My Oracle Support Banner

NULL Value Disappears When Selecting 'Limit values by' Filtering Option In Prompts (Doc ID 2716546.1)

Last updated on OCTOBER 05, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


NULL value disappears when turning on 'Limit values by' choice list values in OBIEE 12c prompt. This is observed only when User Input is 'Choice List' in Prompts.

Steps to verify

  1. Create prompt with 2 columns where NULL Value is present in data for the columns.
  2. In the 2nd column prompt, choose 'Choice List' in User Input.
  3. In Choice List Values, select 'Limit values by' and choose the 1st column.
  4. In Display section, select the 2nd column where 'Limit Values By' is applied.
  5. Null is not displayed.


Upgraded from 11g to 12c.


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

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