f Get Oracle Apps Traning Here: Difference between Lookups and Value Sets

This work is licensed under a Creative Commons -NonCommercial 2.5 License.



Thursday, October 26, 2006

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

Comments on "Difference between Lookups and Value Sets"

 

Anonymous Anonymous said ... (7:19 AM) : 

hi
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

 

Blogger Anil Passi said ... (7:22 AM) : 

Thanks for pointing that out Santosh. I have corrected that typo now.

Regards,
Anil

 

Blogger Mukesh said ... (5:39 AM) : 

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

 

Blogger Anil Passi said ... (5:45 AM) : 

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

 

Anonymous Anonymous said ... (3:57 AM) : 

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

 

Anonymous Anonymous said ... (6:23 AM) : 

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

 

Blogger Bhavesh said ... (12:04 AM) : 

understood .. but i can see everything that a lookup can do can be achieved bu value set.. then why lookup in the first place?

 

Blogger Anil Passi said ... (1:55 AM) : 

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

 

Anonymous Anonymous said ... (6:20 PM) : 

I totally agree with your findings...


Ted

reverse cell phone lookups

 

Anonymous Anonymous said ... (8:33 AM) : 

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

 

Blogger Harish D said ... (3:57 AM) : 

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

 

Blogger Suri said ... (3:58 AM) : 

Hi Anil,

u are doing a great job for us.Please clarify on Multi Org structure

Thanks,
Suri

 

Anonymous Mahesh Babu said ... (3:19 AM) : 

Hi Anil,
Ur site is excellent.
Can you explain about different types of valuesets and lookups ?

 

post a comment