How to set default value in value set in oracle apps

How to set default value in value set in oracle apps

In this post , We will be discussing about how to set default value in value set in oracle apps. We can only set the default value for the value set in concurrent program parameters. We have the option in parameters to set the default value for values set in oracle. But if we are setting some default value for any value set parameters then that value should be in the Value set list others wise system will give the error of non-existing value in lov. Here below, we will be discuss in more detail about how to set default value in value set in oracle apps.

Steps to set default value in value set parameters in oracle apps

Step 1:- As below in Concurrent Programs , We can set default value based on these below Default types

Constant

Current Date

Current Time

Profile

SQL Statement

Segment

For Constant Default Type 

For SQL Statement Default Type

For Profile Default Type as below 

How to set default value in value set in oracle apps