How to enable a Parameter based on another parameter in oracle apps
Hi Friends, We are going to discuss about how to enable a Parameter based on another parameter in oracle apps. We will share the detail steps to enable a parameter based on another parameter in oracle apps. We are sharing the working example to enable a parameter based on another parameter. As such we don't have the oracle provided direct option to enable the parameters based on another parameter in oracle apps but we have developed the workaround or method using this we can enable the parameter based on another parameter in oracle apps. In this post , We will share our real time example in which we have enable the concurrent program parameter based on the value selected by user in another parameter. This method is real helpful if we want to enable the parameter based on another parameter in oracle apps. Please find below the detail steps to enable a Parameter based on another parameter in Oracle Apps.
Step by Step to enable a Parameter based on another parameter in oracle apps
Step 1:- We have below business requirement to enable a parameters based on another parameter in oracle apps.
If OU Name is 'Vision OU2' then Employee Type should be enable.
If OU Name is 'Vision OU1' then Employee Type should be disable.
 |
| How to enable 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 enable.
 |
| How to enable a Parameter based on another parameter in oracle apps |
But before this we need to create the value set of this parameter 'P_AUTO_FLAG'
 |
| How to enable 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 enable 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 enable a Parameter based on another parameter in oracle apps |
Step 6:- Here below is the third Parameter Employee Type.
 |
| How to enable 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 enable 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 enabled.
 |
| How to enable 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 enable 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 enable a Parameter based on another parameter in oracle appsHow to enable a Parameter based on another parameter in oracle apps |
0 comments:
Post a Comment