How to make concurrent program parameters Mandatory Dynamically

Hi Friends, We are going to discuss about how to make concurrent program parameters Mandatory Dynamically. We will share the details steps to make concurrent program parameters Mandatory Dynamically. We have the option in concurrent program to make it mandatory but we don't have the direct option for dynamically mandatory. We will share some workaround method which helps to make the concurrent program parameters dynamically. This workaround is little bit tricky but it definitely usefully to make concurrent program parameters dynamically mandatory. We do use the $FLEX$ feature also in this workaround for making the parameters mandatory dynamically. Please find below the detail steps to make concurrent program parameters Mandatory Dynamically.

Step by Step to make concurrent program parameters Mandatory Dynamically

Step1: - We have below business requirement to make parameters mandatory dynamically.

If OU Name is 'Vision OU1' then Employee Type should be non mandatory.

If OU Name is 'Vision OU2' then Employee Type should be mandatory.

How to make concurrent program parameters Mandatory Dynamically

Step 2:- Our Requirement is, if OU name is 'Vision OU1',then Employee Type parameter should be non mandatory.

How to make concurrent program parameters Mandatory Dynamically

Step 3: We are creating the Second parameter , which should be display off.

But before this we need to create the value set of this parameter 'P_AUTO_FLAG'

How to make concurrent program parameters Mandatory Dynamically

Step 4:- Here below , We are creating the 'XX_AUTO_VSET2' and should be type 'None'

How to make concurrent program parameters Mandatory Dynamically Application

Step 5:- Here below , we are attaching this value set to second display off parameter 'XX_AUTO_VSET2'.

Default Type : SQL

Default Value : Select 'Y' from dual where :$FLEX$.XX_OU:NULL in ('Vision OU2')

How to make parameters Conditionally mandatory or non mandatory from Concurrent Program Application

How to make concurrent program parameters Mandatory Dynamically

Step 6:- Here below is the third Parameter Employee Type.

How to make concurrent program parameters Mandatory Dynamically

Step 7:- In the XX_EMPLOYEE_TYPE value set for third parameter , We need to set this below condition.

(SELECT 'Temporary Employee' E_TYPE FROM DUAL)

In Where condition , we are referencing the second parameter value set 'XX_AUTO_VSET2'

How to make concurrent program parameters Mandatory Dynamically

Step 8:- Now, we need to goto the Report and run. Here below by default second parameter is not mandatory.

How to make concurrent program parameters Mandatory Dynamically

Step 9:- Now we have selected the 'Vision OU1' value but still the Employee Type is non mandatory as per our requirement.Parameters are now showing mandatory dynamically.