Lookup in Oracle Apps
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.
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle ADF .
ReplyDeleteActually, I was looking for the same information on internet for
Oracle ADF Interview Questions and Answers/Tips and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.