can value list and parameter reference each other?
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