Difference between Valuesets and Lookups


Difference 1
Value sets can be attached to parameters of a concurrent program or to a DFF segments where as Lookups are attached only to the fields of a Form/Page
Difference 2
Lookups can be maintained by end users where as Value Sets are almost never maintained by end users, with the exception of GL Flexfield codes. Value sets are usually maintained by System Administrators.
Difference 3
Lookups can have translated values in different languages but not the values in the Value Sets
Difference 4
Value sets can contain values that are a result of an SQL Statement. Hence it is possible to make Value Set list of values dynamic.
On the contrary, Lookup Codes are Static list of values which can only be entered through Lookups Form.
Difference 5
We have several different types of value sets but not lookups.
see this post to know more about different types of value sets –> http://oracleappsdna.com/question/what-are-different-types-of-value-sets/

Post a Comment