Lookups in Oracle Apps

Lookup in Oracle Apps

 

A lookup is any predefined value that was not defined in a setup window.
Lookups in Oracle are a collection of values.
Lookups are a static collection of codes which are used by oracle for working. 

The main purpose of a lookup is to keep programs flexible and easier to configure.
 Lookups are an approach of creating a configurable “list of values” in E-Business Suite.
Maintain existing and define additional Lookups for your shared Lookup types.

What is lookup in oracle apps?

Lookup is nothing but a set of codes and their meaning.

E.g. in HCM or HRMS we have users, a user can be active or Inactive.

For this purpose oracle has provided the standard lookup called “ACTIVE_INACTIVE”.

As you can see in the above screen shot the code for ACTIVE is A and for INACTIVE is I.

In HRMS screen user will see the “ACTIVE” or “INACTIVE” but in backend it will stored as A or I.

In the below screen you can see that UAE nationalities are stored in a lookup called “AE_NATIONALITY”

Access Levels in Lookups.

There are three levels in lookups.

User: These level lookups are created by users and we can update or remove the lookup code or values from these levels of lookups.

Extensible: You can create a lookup as extensible if you want users to add or modify the lookup code or values, but user can not remove the existing codes or values.

System: These lookups are provided by oracle, we can add, Modify or delete the records from these lookups.

How to create a lookup?

Navigation:

Now enter the below details.

So in above picture you can see that i have created a lookup for STD codes.