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

Hi Friends, We are going to discuss about how to make parameters Conditionally mandatory or non mandatory from Concurrent Program Application. We will share the complete steps to conditionally mandatory or not mandatory concurrent program parameters in oracle apps r12. We have the option in oracle concurrent program to make the parameters mandatory but to make the it conditionally mandatory , we have to perform multiple steps. Conditionally mandatory parameters is not quite straight forward in oracle apps , We have to meet this requirement through some workaround. In this post , We are sharing the real time business example in which we will try to make the concurrent programs parameters conditionally mandatory. Please find below the complete detail about how to make parameters Conditionally mandatory or non mandatory from Concurrent Program Application.

Step by Step to make parameters Conditionally mandatory or non mandatory from Concurrent Program Application

Step 1: -Go to Concurrent Request .

Here below is the concurrent program.We have two parameter. 

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 parameters Conditionally mandatory or non mandatory from Concurrent Program Application

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

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

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 parameters Conditionally mandatory or non mandatory from Concurrent Program Application

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

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

Step 5:- Now we need to attach 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

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

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

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 parameters Conditionally mandatory or non mandatory from Concurrent Program Application

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

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

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

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

Step 10:- If we have selected the OU name 'Vision OU2' then second parameter become mandatory.

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

Step 11:- Here below selecting the value for second mandatory parameter Employee Type.

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


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