The following video illustrates the following examples
ABC Corporation would like to document the Marital Type as Divorcee for Great Britain. (MAR_STATUS)
ABC Corporation would like to record Social Security Number for the employees in the US (Lookup Type: PER_NATIONAL_IDENTIFIER_TYPE)
Define Lookups
Lookups are containers for the list items that appear in an application. Users select one of the items from such lists to enter a value on the application UI.
Lookups consist of:
1. Lookup Type - A lookup type is a static list of values users use to make entries in the application. This is the name of the field that appears on the setup UI and not on the application UI where you make the selection.
2. Lookup Code - An internal application code for each lookup that is not visible to users.
3. Meaning - The actual UI term associated with the lookup code. It is the item that appears in the list on the application UI against the specific field name, and can be selected by the users to indicate their choice.
4. Tag - The description or a label associated with that lookup.
5. Enabled (status) - Determines the availability of the meaning (the value or the item) within the selection list for that lookup type. If you do not enable it, the value does not appear in the selection list at runtime.
There are three different categories of lookups:
1. Standard Lookups
- These are the simplest form of lookup types consisting of lookup codes and their meanings.
2. Common Lookups
- These are predefined lookups and are available for internal system administrative use and are used by more than one application.
3. Set-enabled Lookups
- These lookups contain lookup codes that are part of a reference data. You can use sets to enable different values in that lookup for different sets of users. At runtime, a selected attribute determines which set-enabled lookup will be visible to the
users. For example, the attribute east-coast or west-coast in the determinant 'location' determines whether it is the 'east-coast' or the 'west-coast' location, depending upon the selected lookup.
Lookup codes and their meanings are valid between a specified date range. If a date range is not specified, the lookup codes and meanings have indefinite validity from the time they are created.
Enabling Lookups
You can create new lookup types and also add new lookup codes and meanings to the existing lookup types, depending upon the access permissions granted to you. But for the lookups and lookup values to appear as values in the lists, they need to be enabled.
To enable a lookup type, you need to enable at least one of its lookup codes and that code must be in a valid date range.
You can access this task from the Setup and Maintenance menu.
Customizing Lookups
Oracle applications contain certain predefined system lookups that are locked for editing. You can only customize the lookups that are left open for extensibility. Even if a lookup is available for customization, the customization levels may vary depending upon the access restrictions. For example, you may modify the meanings of certain predefined lookup codes but may not have the permission to create new lookup codes.
Person Information Lookups
Person information lookups are described in the following table.
Document Information Lookups
Document information lookups are described in the following table.
Disability Information Lookups
Disability information lookups are described in the following table.
Comments
Thanks for the details on lookups.
However the images under Person Information Lookups, Document Information Lookups seem to be not appropriate.
Thanks
Thanks for the details on lookups.
However the images under Person Information Lookups, Document Information Lookups seem to be not appropriate.
Thanks
Doordat deze zodanig goed over de kou kan, komt 'ie zo bekend.
Een warm weersgesteldhei d is dikwijls de eerste gedachte
indien iemand het heeft over tropische planten.
Here is my website Phoenix roebelenii: http://science-Marketplace.org/user/profile/332241
life to listen news on Television, therefore I only use world wide web
for that reason, and obtain the most recent information.
internet and on web I found this site as a most excellent web page for most up-to-date
updates.
appropriate place and other person will also do similar in support of you.
i came to return the want?.I'm trying to find things to enhance my website!I suppose its good enough to use some of your
ideas!!
this web site is providing.
Look advanced to far added agreeable from
you! By the way, how could we communicate?
page conations really good funny data too.
RSS feed for comments to this post