DATE parameter dependent on previous parameter value

Requirement: Requirement is to have a date parameter in the report which should be enabled if the previous parameter value is YES and should be disabled if the previous parameter value is NO:


Solution: Follow below steps to meet the above requirement

Step:1 Create a value set with validation type as NONE:




Step:2 Create a value set with validation type as SPECIAL:




In Edit Information, event type as Validate, give the below code




Step 3:

Now go to the concurrent program definition,

First parameter list down only 'Yes' and 'No' values. Now create a dummy parameter as below and attach the valueset created in the first step here. Default type as SQL Statement and value as below:

SELECT DECODE(:$FLEX$.EXTR_YES_NO,'Yes','1','') FROM DUAL





Step 4:

In the date parameter attach the valueset created in the step 2




Now while submitting the report, if we give Yes as first parameter value, date parameter will be enabled. If we give No, date parameter will be disabled.