Report Layout Columns Fail to Filter Data With Error 'No Data' When Selecting A Column Header In BI Publisher Interactive Mode (Doc ID 2060869.1)

Last updated on OCTOBER 05, 2015

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.0 to 11.1.1.9.0 [Release 11.1]
Information in this document applies to any platform.

Symptoms

User creates a new report layout that returns the appropriate data, and when viewing it interactively the report functions properly.

However when selecting one of the column headers in an attempt to filter the column, the response is "No data found". 

When you click the column header you can see all the possible values, and all of them are selected.

If you de-select even one of them then no data is returned.

Changes

 A new report layout was created.
 

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