Creating a Dependent Choice List

Steps:

1. Hello, my name is John, and today we are discussing extending  applications using Application Composer.

   Step 1

2. In this demo, I will show you how to create a choice list that displays different values depending on the selection a user made in a second choice list.

    

   This is the first of two demos that show you how to create and test a dependent choice list.

    

   In this example, we create a choice list that helps users classify the issue in a trouble ticket, depending on the  type of problem they are having.

   Step 2

3. We begin by navigating to the object in Application Composer. In our example, this is the custom object called Trouble Ticket, but we could just as easily extend a standard application object.

   Step 3

4. We start by selecting the Fields link.

    

   Click the Fields link.

   Step 4

5. And clicking the Create button.

   Click the Create a custom field button.

   Step 5

6. We select the fixed choice list option.

    

   Click the Choice List (Fixed) option.

   Step 6

7. Click the OK button.

   Step 7

8. We enter the field name users will see in the Display Label field.

    

   Enter the desired information into the Display Label field. Enter

    a valid value
    e.g.
    "Area"
   .
   Step 8

9. Pressing any key populates the Name field.

    

   Press [Tab].

   Step 9

10.  This internal name must be unique.  We're OK here.

    Step 10

11. Now let's create the lookup type with all the values.

     

    Click the Create a New Lookup Type button.

    Step 11

12. We can reuse lookup types, so let's enter a name that will be easy to identify.

     

    Enter the desired information into the Meaning field. Enter

     a valid value
     e.g.
     "Trouble Ticket Area"
    .
    Step 12

13. Now the technical name. No spaces permitted.

     

    Enter the desired information into the Lookup Type field. Enter

     a valid value
     e.g.
     "TT_AREA"
    .
    Step 13

14. Now let's add the values.

     

    Click the Create Lookup Code button.

    Step 14

15. For each value, we add the text users see in the Meaning field.

     

    Enter the desired information into the Meaning field. Enter

     a valid value
     e.g.
     "CD-ROM"
    .
    Step 15

16. Press [Tab].

    Step 16

17.  And the technical name in the Lookup Code field.

     

    Enter the desired information into the Lookup Code field. Enter

     a valid value
     e.g.
     "CD_ROM"
    .
    Step 17

18. Press [Tab].

    Step 18

19. Press [Tab].

    Step 19

20. The display sequence determines the order of the values in the list. We want CD-ROM to be the first value, so we enter a 10.

     

    Enter the desired information into the Display Sequence field. Enter

     a valid value
     e.g.
     "10"
    .
    Step 20

21. Now let's enter the next value.

     

    Click the Create Lookup Code button.

    Step 21

22. Enter the desired information into the Meaning field. Enter

     a valid value
     e.g.
     "Desktop"
    .
    Step 22

23. Enter the desired information into the Lookup Code field. Enter

     a valid value
     e.g.
     "DESKTOP"
    .
    Step 23

24. Press [Tab].

    Step 24

25. Press [Tab].

    Step 25

26. We want this to be the second value in the list, so we enter 20.  You get the idea.

     

    Enter the desired information into the Display Sequence field. Enter

     a valid value
     e.g.
     "20"
    .
    Step 26

27. When you are done entering all the values, you save.

    Click the Save button.

    Step 27

28. Now that we've created all the values, let's specify which values to display when.

     

    Click the Constrain list by parent field value selection option.

    Step 28

29. From the Parent Choice List, we choose which list determines the values to display.

    Click the Parent Choice List list.

    Step 29

30. In our example, that's Type.

    Click the Type list item.

    Step 30

31. Now let's create the map that determines which values diplay when.

     

    Click the Create a New Value Map button.

    Step 31

32. We'll start by selecting what values to display for hardware issues.

     

    We can select a value by doubleclicking on it.

     

    Double-click the Desktop list item.

    Step 32

33. Double-click the Laptop list item.

    Step 33

34. Double-click the CD-ROM list item.

    Step 34

35. Now let's do the same for the Software type.

    Click the Software list item.

    Step 35

36. Double-click the Application list item.

    Step 36

37. Double-click the Operating System list item.

    Step 37

38. No need to show you the rest.

    Step 38

39. When we are done selecting the values for all the types, we click OK.

    Click the OK button.

    Step 39

40. And save.

    Click the Save and Close button.

    Step 40

41. Now let's display the new Area field in the UI.

    Click the Pages link.

    Step 41

42. We want to add the new Area field to the summary section at the top of trouble ticket edit page.

    This is called the Details Page in Application Composer.

    Step 42

43. Click the Edit Summary Form link.

    Step 43

44. We'll add the field to the top summary section.

    Double-click the Area list item.

    Step 44

45. We are done. In the next demo we'll check our work.

    Click the Save and Close button.

    Step 45

46. In this demo you learned how to create a dependent choice list field in Application Composer.

     

    You can find additional learning resources in your Oracle Fusion Help application, as well as in the Oracle Learning Library, and at Oracle University. Thank you.

    Step 46

Table of Contents  Start Topic