Oracle Order Management - Quick Codes (Lookups)

Oracle Order Management - Quick Codes (Lookups)

Application Utilities Lookups:

Main purpose of Application Lookups in Oracle Application are:

1. Maintain existing and to define additional Lookups for your shared Lookup types.

2. A maximum of 250 Lookups can be defined for a single type.

3. Each Lookup has a code and a meaning.

Navigation:

Oracle Order Management > Setup > QuickCodes > Order Management

Application Lookups Block:

Application Lookups Block contains the below fields:

  

Type

Query any Lookup type. A maximum of 250 Lookups can be defined for a single type.

Application

Query the application associated with the Lookup type.

Description

If you use windows specialized for a particular Lookup type, the window uses this description in the window title.

Access Level

The access level restricts changes that are possible to a lookup type. The possible access levels are:

  

System -              No changes to the lookup codes are allowed.

Extensible -        New lookup codes can be added. However, you cannot modify seeded lookup codes.

User -                    You can change any lookup code.

Lookups Values Block:

Application Lookups Values Block contains the below fields:

Code

Enter the code value for the Lookup. A maximum of 250 Lookups can be defined for a single type.

When you enter a valid Lookup meaning into a displayed window field, Lookups stores this code into a corresponding hidden field.

Ex: Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.

Values cannot be changed in this field after committing them. To remove an obsolete Lookup, It can be either disabled the code, enter an end date, or change the meaning and description to match a replacement code.

Meaning

When a valid Lookup meaning is entered into a displayed window field, Lookups stores the corresponding code into a hidden field. Lookups automatically displays the meaning in the Lookups field whenever the window is queried. For example, the Lookup "Y" displays the meaning "Yes" but stores the code value "Y" in a hidden field.

Description

Description is to add the meaning to give more information about the Lookup.

Tag

Optionally enter in a tag to describe the lookup. The tag can be used to categorize lookup values.

Effective Dates

Enter the dates between which this Lookup becomes active. If start date is not entered then the Lookup is valid immediately.

Once a Lookup expires, users cannot insert additional records using the Lookup, but can query records that already use the Lookup. If an end date is not entered the Lookup is valid indefinitely.

Enabled

Indicate whether applications can use the Lookup. If disabled, users cannot insert additional records using the Lookup, but can query records that already use this Lookup.

DFF:

Double brackets ([ ]) indicates a descriptive flexfield that is used to add data fields to this window without programming.