GeeKs Blogging @ dotCOM

Siebel – LOV Number Limitation

Siebel List of Values is probably the most commonly used entity in almost all the Siebel EAI projects. I have seen people use LOVs for all sorts of crazy things – storing Language Translations (most common use!), reverse translations, holding Pricing Information, identifying incoming interfaces, setting up a list of allowed values (for eg. in an incoming XML tag), using the Description field to increase the max length that can be stored and what not!

Siebel List of Values have found such profound use and application, possibly because of the famous LookUpValue() function, which can quickly pick out values from the S_LST_OF_VAL table. The LOVs are cached which make this function work even faster and helps Performance. It does have its own set of pains, however.

Once I heard that one of my friends had a requirement, where they created exceptionally large number of LOVs in the List of Values entity, for only one particular LOV Type. They noticed that the LookUpValue() function started failing after some particular values. They noticed that after some 12,000 values, the LookUpValue() function no longer worked!

Digging a little more on Metalink, they found that Siebel officially supports only upto a max of 10,000 values in a particular LOV Type. After that, the LookUpValue() function will fail to return a value.

News to me. But, definitely something that all Siebel Architects could possibly keep in mind when designing Siebel CRM solutions. I guess it is always nice to know the limits upto which one can stretch.

Related posts:

1. Siebel – LookUpName() and LookUpValue() Hi all, I was working for a multi lingual implementation...
2. Siebel – Symbolic Strings Consider this a brief introductory tutorial on Symbolic Strings in...
3. Siebel – Left, Right and from the Middle Extracting a sub string from a lengthy string in Siebel....
4. Siebel – Installer hangs midway In my website statistics, I see somebody trying to find...
5. Siebel – Popup Update Only Hi all, I was working with Siebel Multi Valued Links...
6. Siebel – Reading data directly from Siebel SRF SRF or the Siebel Repository File as it is more...
7. Siebel – Make MVG Field required Siebel supports the concept of Multi Valued Fields, or the...