BI Publisher (MOSC)

MOSC Banner

can value list and parameter reference each other?

edited Apr 4, 2012 4:23PM in BI Publisher (MOSC) 8 commentsAnswered
Hi Experts

My customer found a report could not work after the patch 6813509 applied. (the BI Publisher version is 10.1.3.2)

When I check the report difination, I found the value list and parameter reference each other like below.

-Value List

name: Value_list_1

Type:SQL

SQL:

SELECT '--'  FROM DUAL

UNION

SELECT 'submit' FROM DUAL WHERE NVL(:new_parameter_1,0) = 'submit__'

UNION

SELECT 'submit_' FROM DUAL WHERE NVL(:new_parameter_1,0) = 'submit'

UNION

SELECT 'submit__' FROM DUAL WHERE NVL(:new_parameter_1,0) NOT IN ('submit','submit__')

 

-Parameter

name: new_parameter_1

Type:menu

Default value: --

Value list: Value_list_1

Refresh other parameters on change is checked

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center