OracleAppsDNA

Difference between Valuesets and Lookups

This is yet another post for Oracle Apps beginners!

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/

Exit mobile version