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

About Hierarchical Lists


A hierarchical list displays values that are constrained by 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 derive 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 establishes 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 Establishes 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 54.

Table 54. 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 54 in the following lists in a hierarchical relationship:

  • Parent list. Displays the values 1 and 2.
  • Child list. Displays values depending on which value the user chooses in the parent list:
    • If the user chooses 1 in the parent list, then Siebel CRM displays the values A and B in the child list.
    • If the user chooses 2 in the parent list, then 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 © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.