Siebel CRM How To - Create a new LOV?

Whatever I have posted in this blog assumes that you have fair bit of idea working on Siebel CRM. I noticed there is hardly anything in this blog that can help a newbie. So thought of starting a new Category that is 'Siebel CRM How To'. This Category will include step by step How To's to various things in Siebel CRM. Starting this series is a simple 'How To' of creating a new List of Value and adding to the existing List of Value (LOV).

Information about LOV and explaination about the various terms is subject of another post. In this post I am just going to have step by step tutorial of creating a new LOV and adding new values to existing LOV's

Creating a new LOV

You can create an LOV from two places both have a different way of creating LOV in Siebel CRM.

Administration ==> Data ==> List of Values
Administration ==> Data ==> LOV Explorer

Through List of Values to add a new LOV following steps have to be followed. As an Example we will add a new LOV for Martial Status of a person.

1. Click New and Choose LOV_TYPE in Type Field
2. Enter MARITAL_LOV in 'Display Value'.
3. Enter 'Marital Status' in Language-Independent Code Field
4. Enter 'English-American' if you implementation language is English otherwise it will be according to the language of your implementation. Save the record
5. Click New again and choose 'MARITAL_LOV' in Type Field
6. Enter 'Married' in Display Value and Language-Independent Code Field
7. Enter 'English-American' if you implementation language is English otherwise it will be according to the language of your implementation. Save the record.
8. Follow steps 5 -7 for all values that you want to associate with this LOV

For example we will follow steps 5 - 7 and just change the value Married to Single so that It can have two values 'Married' and 'Single'

Through LOV Explorer you have to perform the following steps.

1. Click New and enter 'MARITAL_LOV' in the Type field
2. Click on the + sign in the left hand side of the LOV Explorer window for the type that you created
3. Click on the Values folder.
4. In the Right hand side Applet click on New
5. Enter 'Married' in the 'Code' and 'Display Value' Field
6. Enter 'English-American' if you implementation language is English otherwise it will be according to the language of your implementation. Save the record.
7. Repeat steps 4-6 for the all the values that you want to enter.

That's it. You are done with creating the New LOV with new Values

To enter New Values in the existing Siebel LOV just perform the following steps.

1. Query for the LOV Type that you want to add New Values.
2. Copy the record Enter the Display Value and Language Independent Code Field
3. Change the value in the Order Field to be the unique number and save the record.

Related Posts that you might like to Read:

Siebel CRM - List of Values a Strategic Move!
Siebel CRM - List of Values a Strategic Move- Continued!