How to disable a Parameter based on another parameter in Oracle Apps

Hi Friends, We are going to discuss about how to disable a Parameter based on another parameter in Oracle Apps. We will share the complete steps which will help to enable and disable the concurrent program dynamically. We often have the requirement in oracle apps in which we wants to disable or enable a parameters dynamically. As such we don't have the oracle provided direct option to disable or enable the parameters based on another parameter in oracle apps but we have developed the workaround or method using this we can enable or disable the parameter based on another parameter in oracle apps. In this post , We will share our real time example in which we have enable and disable the concurrent program parameter based on the value selected by user in another parameter. This method is real helpful if we want to disable the parameter based on another parameter in oracle apps. Please find below the detail steps to disable a Parameter based on another parameter in Oracle Apps.

Step by Step to disable a Parameter based on another parameter in Oracle Apps

Step 1:-We have below business requirement to disable a parameters based on another parameter in oracle apps.

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

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

How to disable a Parameter based on another parameter in Oracle Apps

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

How to disable a Parameter based on another parameter in Oracle Apps

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 disable a Parameter based on another parameter in Oracle Apps

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

How to disable a Parameter based on another parameter in Oracle Apps

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 disable a Parameter based on another parameter in Oracle Apps

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

How to disable a Parameter based on another parameter in Oracle Apps

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 disable a Parameter based on another parameter in Oracle Apps

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

How to disable a Parameter based on another parameter in Oracle Apps

Step 9:- Now we have selected the 'Vision OU1' value but still the Employee Type is disabled as per our requirement.Parameters are now enable/disable dynamically.

How to disable a Parameter based on another parameter in Oracle Apps

Step 10:- We have selected the OU name 'Vision OU2' then second parameter is now showing enable.

How to disable a Parameter based on another parameter in Oracle Apps

How to disable a Parameter based on another parameter in Oracle Apps