How to make a parameter mandatory in concurrent program based on another Parameter
Hi friends, We are going to discuss about how to make a parameter mandatory in concurrent program based on another Parameter. We will share the business real time example showing how to make one parameter mandatory based on another parameter in concurrent program. We can make the concurrent programs mandatory but as such there is direct standard option to make any parameter required based on another parameter in concurrent program but we have an option called workaround using this we can meet this requirement and set the parameter mandatory based on another concurrent program parameter in oracle apps. This is very useful technique to make parameter mandatory based on another parameter. In this workaround, we are using the $FLEX$ feature of value set dependent. Please find below the more detail about how to make a parameter mandatory in concurrent program based on another Parameter.
Step by Step to make a parameter mandatory in concurrent program based on another Parameter
Step 1:- 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 a parameter mandatory in concurrent program based on another Parameter |
Step 2:- Our Requirement is, if OU name is 'Vision OU1',then Employee Type parameter should be non mandatory.
 |
| How to make a parameter mandatory in concurrent program based on another Parameter 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 a parameter mandatory in concurrent program based on another Parameter |
Step 4:- Here below , We are creating the 'XX_AUTO_VSET2' and should be type 'None'
 |
| How to make a parameter mandatory in concurrent program based on another Parameter |
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 a parameter mandatory in concurrent program based on another Parameter |
Step 6:- Here below is the third Parameter Employee Type.
 |
| How to make a parameter mandatory in concurrent program based on another Parameter |
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 a parameter mandatory in concurrent program based on another Parameter |
Step 8:- Now, we need to goto the Report and run. Here below by default second parameter is not mandatory.
 |
| How to make a parameter mandatory in concurrent program based on another Parameter |
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.
 |
| How to make a parameter mandatory in concurrent program based on another Parameter |
Step 10:- We have selected the OU name 'Vision OU2' then second parameter become mandatory.
 |
| How to make a parameter mandatory in concurrent program based on another Parameter |
2 comments:
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.
It has not become mandatory but disabled.
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.
It has not become non mandatory but disabled.
Post a Comment