Lookup Types

Lookup types provide the lists of values in application fields that are drop-down lists.

For example, while creating a help desk request, the Severity is selected from a drop-down list. The values in that list are derived from a lookup type defined in Setup and Maintenance. This lookup type has several potential values known as lookups, each with their own unique lookup code and meaning that displays in the UI.

Note:

You can't create a new lookup with the name starting with ORA, to avoid any conflict with the lookups predefined in the application.

How You Modify Lookup Types

You can change many lookup types during or after implementation.

The configuration level of a lookup type determines whether the lookups in that lookup type can be edited. The lookup configuration levels are: User, Extensible, and System.

Here's a table that shows which lookup management tasks are allowed at each modification level.

Allowed Task

User

Extensible

System

Deleting a lookup type

Yes

No

No

Inserting new codes

Yes

Yes

No

Changing the wording that displays on the page (Meaning field)

Yes

Yes

Yes

Updating start date, end date, and enabled fields

Yes

Yes, only if the code isn't predefined data

No

Deleting codes

Yes

Yes, only if the code isn't predefined data

No

Updating tags

Yes

No

No

Updating module

Yes

No

No

If a product depends on a lookup type, the configuration level must be set to system or extensible to prevent deletion. Once the configuration level is set for a lookup type, it can't be changed. The configuration level for lookup types created using the Define Lookups page is by default set at the User level.

Help Desk Lookup Types

You can find lookup types by searching for an associated setup task in the Setup and Maintenance work area. Lookup types that are commonly edited are presented within the Help Desk offering as one of the setup tasks or task lists. Other lookup types that are less frequently changed, might not be shown in the offering, but can still be accessed through the Manage Common Lookups task. Here are some common help desk lookup tasks or task lists:

  • Define Help Desk Request Lookups
  • Manage Help Desk Request Severity
  • Manage Help Desk Request Channel Types