Requirement :
Enable/Disable parameter using "Special" Type Valueset.
Steps:
1) Create First Parameter with value set as per the requirement. Here I used Yes_No standard value set.
2) Create Dummy parameter with value set with NONE as type:
3) Create "Special" Type Value set for third parameter :
Click on Edit information and select validate as event.
Use below code for validation:
FND PLSQL "BEGIN
IF ':$FLEX$.DUMMY_VS' ='N' THEN
NULL;
END IF;
END;"
IF ':$FLEX$.DUMMY_VS' ='N' THEN
NULL;
END IF;
END;"
Note:- Here you need to use value set which was used in "dummy" parameter.
4) Define the Concurrent using above parameter:
5)Attach value set which we create in step 2 to Dummy parameter
Select Default type as SQL Statement.
Default Value : SELECT 'N' from dual where :$FLEX$.i_all_employee = 'N'
NOTE : - Hide this parameter.
6) Attach Special type Value set to 3rd parameter which we created in Step 3.
7) Save your work.
8) Run the concurrent
If All Employees is Yes then Single Employee WWID parameter should be disable
If All Employees is No then Single Employee WWID parameter should be enable and user enterable.
In this way you can dynamically enable/disable parameter using special type value set.
For more Oracle Fusion HDL Videos please click here
For more Oracle Fusion Extract PDF Output Videos please click here
