Wednesday, August 7, 2019

Difference Between Value set and Lookups



Value sets can be attached to parameters of a concurrent program or to a DFF segments where as Lookup are attached only to the fields of a Form/Page

Lookup can be maintained by end users where as Value Sets are almost never maintained by end users, with the exception of GL Flex field codes. Value sets are usually maintained by System Administrators.

Lookup can have translated values in different languages but not the values in the Value Sets

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 Lookup Form.

We have several different types of value sets but not lookup

No comments:

Post a Comment

AME (Approval Management Engine)

AME (Approval Management Engine) : AME Stands for Oracle Approval Management Engine. AME is a self service web application that enables...