Developing and Deploying Siebel Business Applications > Pick Lists, Drilldowns, and MVGs > Configuring Pick Lists >

Static Pick Lists

A static pick list is a list of predefined values that the user invokes from a field in an applet. When the user clicks the drop-down arrow to the right of the field, a single-column pick list appears. The user chooses a value from the list, and then clicks Save to enter the value for the field. The values in the pick list are predefined by an administrator or developer and stored in the list of values table. Figure 22 shows a pick list for the Price field.

Figure 22. Static Pick List
Click for full size image

A pick list can be bounded or unbounded. A bounded pick list restricts the user to choose values from the list only. With an unbounded pick list the user can choose a value from the list or type a entry directly into the field.

NREC's requirement is to have pick lists for the following fields on the Opportunity business component.

  • Bathrooms
  • Bedrooms
  • Price Range
  • Square Feet

The following procedure uses the Price Range field on the Opportunities business component as an example. To complete the NREC configuration, create pick lists for the remaining fields as well.

To create a new static pick list

  1. Choose File > New Object.

    The New Objects Wizard appears.

  2. Under the General tab, select the Pick List icon, and then click OK.

    The Pick List wizard opens.

  3. In Pick List dialog box, enter the values shown in the following table, and then click Next.


    NREC Configuration

    Business Component



    Price Range

    The field is one you created in Adding Additional Columns to the Opportunity Base Table.

    The Pick List Type dialog box appears, and it displays the controls that map to the field you selected in Step 3.

  4. Click the Static option button and then click Next.
  5. In the Pick List Definition dialog box, click the Create new Pick List option button and then click Next.
  6. In the next Pick List Definition dialog box, enter Price Range as the name of the pick list, click the Create new List of Values option button, and then click Next.
  7. In the List of Values dialog box, enter a name for the list and then, for each value to appear in the list, enter the value shown in the following table, and then click Enter.




    0 - 100,000

    100,000 - 150,000

    150,000 - 200,000

    200,000 - 250,000

    ...and so on

  8. In the next Pick List Definition dialog box, enter a comment in the Comment field and leave the Search Specification and Bounded Pick List check boxes blank.

    A bounded pick list forces the user to enter a value that has been predefined on the list. Not selecting the Bounded check box allows the user to type in a value or choose one from the list.

  9. In the Finish dialog box, review the information and then click Finish.

    The wizard creates the Pick List object and related objects and adds the list of values to the database.

  10. Compile and Unit Test.

    The pick list appears as a drop-down list on the Price fields in the user interface. See Figure 22. Notice that the pick list is available on the Price field in both the list and the form applet.

Developing and Deploying Siebel Business Applications Copyright © 2006, Oracle. All rights reserved.