Configuring Siebel Business Applications > Configuring Lists and Pick Applets > About Lists and Pick Applets >

About Hierarchical Lists


A hierarchical list constrains values according to the value that the user chooses in another list. For example, in the Service Request Detail Applet, the Area and Subarea fields are lists that get their values from the S_LST_OF_VAL list of values table. The value that the user chooses in the Area list determines the values that Siebel CRM displays in the Subarea list. For more information, see Creating a Hierarchical List.

The list of values table creates the hierarchical relationship between these values. Siebel CRM uses the same LOV Type to determine the values for the lists in the hierarchy. For example, for Area and Subarea, the LOV Type named SR_AREA determines the values. For more information, see Creating a List of Values.

How Siebel CRM Creates a Hierarchy

Siebel CRM uses the Parent LIC (language-independent code) field to define a parent value. For example, consider the example list of values described in Table 57.

Table 57. Example List of Values for a Hierarchical List
Type
Display Value
Language Independent Code
Parent LIC

SAMPLE_LOV

1

1

None

SAMPLE_LOV

A

A

1

SAMPLE_LOV

B

B

1

SAMPLE_LOV

2

2

None

SAMPLE_LOV

C

C

2

SAMPLE_LOV

D

D

2

Assume Siebel CRM displays the values listed in Table 57 in the following lists in a hierarchical relationship:

  • Parent list. Displays the values 1 and 2.
  • Child list. Displays values depending on the following value that the user chooses in the parent list:
    • 1. Siebel CRM displays the values A and B in the child list.
    • 2. Siebel CRM displays the values C and D in the child list.

For more information, see Creating a List of Values.

Creating a Hierarchical List of Values

You can create a hierarchical list of values.

To create a hierarchical list of values

  • Configure the following lists:
    • Configure the parent list to reference the PickList Hierarchical business component.
    • Configure the child list to reference the PickList Hierarchical Sub-Area business component.
Configuring Siebel Business Applications Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.