1. Implementing Risk Management
  2. Manage Lookups

Manage Lookups

Lists of values in Oracle Fusion Cloud Risk Management pages are stored as "lookups." You can add values to some delivered lookups.

Each list of values has its own lookup table. An entry within a lookup table consists of these elements:

  • A "lookup type" identifies the table in which a lookup value exists. In effect, it distinguishes lookup values belonging to one LOV from those belonging to others.

  • Within a given lookup type, each entry correlates a "lookup code" to a "meaning." The code is an internal value. The meaning is the text that actually appears in an LOV.

  • Each entry may also have a description.

Determine Lookup Type

To create a lookup value, first determine its lookup type:

  1. Identify one value in the LOV in which the lookup is to appear. For example, if you're creating a new perspective type:

    • Navigate to the Create Perspective Hierarchy page: Open the Perspectives work area, then select the Create action.

    • Expand the Type field in the Create Perspective Hierarchy page. Note one of its values, such as Major Process.

  2. Open the Lookups page: Select the Lookups tab in the Setup and Administration work area.

  3. Click Show Filters. In the Meaning field of the Filters panel, enter the value you noted. Click Search. The Lookups page then includes one row that displays the lookup type to which you want to add. In the perspective type example, this value is GRCM_PERSPECTIVE_TYPE.

However, each of the following pages contains a Type field with no predefined values. For those fields, this method of determining a lookup type wouldn't work. On each of the following pages, the correct lookup type for the Type field is:

Page

Lookup Type

Create Process or Edit Process

GRCM_PROCESS_TYPE

Create Risk or Edit Risk

GRCM_RISK_TYPE

Create Control or Edit Control

GRCM_CONTROL_TYPE

Create Issue or Edit Issue

GRCM_ISSUE_TYPE

Create and Edit Lookups

To create a lookup:

  1. In the Lookups page, click the Create Lookup icon. A Create Lookup page opens.

  2. In the Lookup Type field, enter the lookup-type value you've just identified.

  3. Enter a code in the Lookup Code field. A code should consist of 30 or fewer characters. Use upper-case for alphabetic characters. Fill the space between words with an underscore.

  4. In the Meaning field, enter text that's actually to be presented in an LOV. The combination of lookup code and meaning must be unique.

  5. In the Status field, accept the default value, Active, or select Inactive.

  6. Optionally, describe the lookup in the Description field.

  7. Select Save and Close.

You can't edit predefined lookups. You can edit lookups you've created. To edit a lookup you've defined:

  1. In the Lookups page, search for the lookup you want to edit: Filter for any combination of type, meaning, description, and status values, and click the Search button.

  2. Click the row for the lookup you want to edit, then click the Edit Lookup icon.

  3. An Edit Lookup page opens. Modify any of the status, meaning, and description values. (The lookup type and lookup code are presented as read-only values; you can't edit them.)

  4. Select Save and Close.