How to make a concurrent program parameter read only

Hi Friends, We are going to discuss about how to make a concurrent program parameter read only. We will discuss how we can make the concurrent program parameter read only and and user cannot change the default system value in that concurrent program parameter. One limitation in concurrent Program is this , we cannot make the concurrent program parameter read only directly instead we have the workaround which we can use to meet our read only concurrent program requirement. We will share the detail steps to make the concurrent program parameters read only in oracle apps. Here below is the complete detail about how to make a concurrent program parameter read only.

Step by Step to make a concurrent program parameter read only

Step 1:- Here Below is the Concurrent Program , We have P_OU parameter.In this parameter , we have the constant value 'Vision OU' . We want to make the field read only. We don't want that user can change the value in the parameter.

We don't have the direct option to make the parameter read only in oracle apps.

How to make a concurrent program parameter read only

Step 2: If we want to make the parameter read only , We first need to create the Value set.

Here below , We have create the value set 'XX_OU' of type 'Table'. 

Maximum Size should be : 240.

How to make a concurrent program parameter read only

Step 3:- Here below we have create the Table Value set and in this we write the sql query which will only extract the 'Vision OU'.

How to make a concurrent program parameter read only

(SELECT 'Vision OU' OU from dual).

Step 4:- Here below , We are attaching this above value set 'XX_OU' to the parameter. 

Now what will happen if user will change the default OU name in the parameter , then we cannot enter any other BU name as we have attached the Value set and it have only the name 'Vision OU' value in the list.

How to make a concurrent program parameter read only

Step 5:- Here below in the Concurrent Request program ,   if user will change the default OU name in the parameter , then we cannot enter any other BU name as we have attached the Value set and it have only the name 'Vision OU' value in the list.

How to make a concurrent program parameter read only