BI Publisher - For Reports With Cascading Parameter Values, using Commas As A Parameter Delimiter Can Cause The Search Function To Fail (Doc ID 2020573.1)

Last updated on JUNE 26, 2015

Applies to:

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

Symptoms

BI Publisher 11.1.1.7.141014

1. For a report with a cascading Parameter, a Region is selected which populates the list of Site values which defaults to 'All'.
Expanding the LOV shows a list.
Next select 'Search'

See the 'Available' and 'Selected' areas with 2 anomalies:
a. All the values are in the 'Selected' area and none are in the Available area
b. The values are non-sense though because every comma is treated as a delimiter

2. When the 'Move All' function is selected (to move from the right pane to the left pane), the anomalies listed above are still present.
(moving single items didn't work at all).

3. After refreshing the left pane, all of a sudden the Parameter values are listed correctly.

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