Language-Independent Code Must Be Unique

If you create a multilingual list of values or a hierarchical list of values, then use a unique language-independent code. For a monolingual list where no language-independent code exists, you can use unique display values. For example, assume a customer requires the following country and state hierarchical list of values:

• Parent list of values is COUNTRY.

  Required values include Australia and USA.

• Child list of values is STATE.

  Required values include Western Australia and Washington State.

In this example, WA is not assigned to the language-independent code for both child list of value entries. The meaning is different for each location, so Siebel CRM assigns a unique language-independent code. For example, WESTERN_AU and WASH_STATE_USA.

Situations exist where it is appropriate to use duplicate values in the child list of values, but you must assign these the same display values in the same language. For example:

• Parent list of values is DEFECT_TYPE

  Required values include Product Defect and Documentation Defect

• Child list of values is STATUS

  Required values include Open and Closed

The status can be Open for each type of defect, so the list of values table contains multiple entries with the display value Open, one for each time that Siebel CRM can use it with each parent list of values entry. The LookupValue function returns the first value in the list of values table that matches the supplied LOV_TYPE and language-independent code values, so it is essential that Siebel CRM assigns the same display value.