Example of a Standard Lookup
Creating a new standard lookup involves creating or selecting a lookup type containing the lookup code. The task also involves determining appropriate values for the lookup codes and their meanings.
You can create or edit lookup codes only if the configuration level for that lookup type supports it.
Creating a Lookup Type Called COLORS
Your enterprise needs a list of values to be used as different statuses on a process. Each status is indicated using a color. Therefore, you create a lookup type called COLORS. The following table lists a mapping between the lookup type parameters and the actual values assigned to those parameters to create the required list of values.
|
Lookup type parameters |
Value |
|---|---|
|
Lookup type name |
COLORS |
|
Meaning |
Status |
|
Description |
Status by color |
|
Module |
Oracle Fusion Middleware Extensions for Oracle Application |
After you define the lookup type, you need to define the lookup codes and their related details. The following table lists the lookup codes you define for the COLORS lookup type.
|
Lookup Code |
Meaning |
Enabled |
Display Sequence |
|---|---|---|---|
|
BLUE |
Urgent |
No |
4 |
|
RED |
Stop |
Yes |
1 |
|
GREEN |
Proceed |
Yes |
3 |
|
YELLOW |
Check |
Yes |
2 |
The Resulting Data Entry List of Values
Only the enabled lookup codes appear in the list of values for the COLORS lookup type. You must select one of them to complete the activity.
The following table lists the meanings and the codes that were enabled. They appear in the order of the defined display sequence.
|
Meaning |
Lookup Code |
|---|---|
|
Stop |
RED |
|
Check |
YELLOW |
|
Proceed |
GREEN |
The BLUE lookup code wasn't enabled and doesn't appear in the list of values. The display sequence of values in the list of values is alphabetic, unless you enter a number manually to determine the order of appearance. Number 1 indicates the first value that appears in the list. Only lookups that are enabled and active between start and end dates are visible.
The Transaction Table
When users enter one of the values from the list of values for the lookup type COLORS, the transaction table records the lookup code. The following table contains an example, where the lookup code is stored in the Status column of the transaction table.
|
Transaction number |
User name |
Status |
|---|---|---|
|
1 |
Jane |
RED |
|
2 |
Bob |
YELLOW |
|
3 |
Alice |
BLUE |
The status for one user is BLUE because at the time they entered a value, BLUE was enabled. Disabling a lookup code doesn't affect transaction records in which that code is stored. Data querying and reporting have access to disabled lookup codes in transaction tables.