Difference between Lookups and Value Sets
| I hope you have read the previous articles on Value Sets and also on Lookups. It is important for the learners to read things in Sequence. Hence you may decide to browse through the Training Index Page. Difference 1 Value sets can be attached to parameters of a concurrent program, whereas Lookups can't. Difference 2 Certain types of Lookups are maintainable by the users too, for example HR Users will maintain "Ethnic Minority" lookups. 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 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. Here comes the end of another simple article... Thanks, Anil Passi |
posted by Anil Passi at 4:00 PM
Comments on "Difference between Lookups and Value Sets"
-
Anonymous said ... (7:19 AM) :
-
Anil Passi said ... (7:22 AM) :
-
Mukesh said ... (5:39 AM) :
-
Anil Passi said ... (5:45 AM) :
-
Anonymous said ... (3:57 AM) :
-
Anonymous said ... (6:23 AM) :
-
Bhavesh said ... (12:04 AM) :
-
Anil Passi said ... (1:55 AM) :
-
Anonymous said ... (6:20 PM) :
-
Anonymous said ... (8:33 AM) :
-
Harish D said ... (3:57 AM) :
-
Suri said ... (3:58 AM) :
-
Mahesh Babu said ... (3:19 AM) :
post a commenthi
i think there is a typo mistake in Difference 1:
it should be like this
Value sets can be attached to parameters of a concurrent program, whereas Lookup types can't
Thanks for pointing that out Santosh. I have corrected that typo now.
Regards,
Anil
Hi Anil,
Can we say more difference between lookups and value set that
1)we can do the validation check in values set and value set has format type Char/varchar2/Number etc which is not in lookups.
2) Also in Value set we can insert duplicate values but lookup has lookup code and meaning so values are unique.
Please let me know is it correct or wrong.
Thanks& Regards,
Mukesh
1) - Correct.
2) You can repeat the values provided the parent value differs.
I am saying so based on Unique indexes as below
FND_FLEX_VALUES_U2=>FLEX_VALUE_SET_ID
FND_FLEX_VALUES_U2=>PARENT_FLEX_VALUE_LOW
FND_FLEX_VALUES_U2=>FLEX_VALUE
Thanks
Anil Passi
Not sure if I am correct, I am just a begineer in O.apps
As the value set gives the option of selecting values from a list of values, there is no point in having the duplicate values in the list.
If I am wrong, then can you explain me the scenario where we need duplicate values
Can you please explain this answer.
2) You can repeat the values provided the parent value differs.
I am saying so based on Unique indexes as below
FND_FLEX_VALUES_U2=>FLEX_VALUE_SET_ID
FND_FLEX_VALUES_U2=>PARENT_FLEX_VALUE_LOW
FND_FLEX_VALUES_U2=>FLEX_VALUE
understood .. but i can see everything that a lookup can do can be achieved bu value set.. then why lookup in the first place?
value set is usually maintained by administrators, but lookups can be managed by end-users too[barring system lookups]
but yes, i agree there is an overlap
I totally agree with your findings...
Ted
reverse cell phone lookups
Hi Anil,
I am trying to pull out pay_group_lookup_code from ap_invoices/ap_invoices_all for payment group.
But when i runt he program, the parameter for payment group is taking more than 40 sec to get list values...
can you share ideas... why it is taking that much time...
Regards,
Phani
Hi Anil,
In the difference below
Difference 3
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.
As the lookup values are stored in a table so why the Lookup Codes are Static list of values?
Why not dynamic?
Please explain.
Regards
Harish
Hi Anil,
u are doing a great job for us.Please clarify on Multi Org structure
Thanks,
Suri
Hi Anil,
Ur site is excellent.
Can you explain about different types of valuesets and lookups ?