Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Oracle Fusion HCM
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

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)

apps2fusion23 PLAY

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.

 

48 FHE
Document Information Lookups
Document information lookups are described in the following table.
49 FHE
Disability Information Lookups
Disability information lookups are described in the following table.
50 FHE


Jayashree Prakash

Comments   

0 #1 Thanks 2015-05-04 16:16
Hi,
Thanks for the details on lookups.
However the images under Person Information Lookups, Document Information Lookups seem to be not appropriate.
Thanks
Quote
0 #2 Thanks 2015-05-04 16:17
Hi,
Thanks for the details on lookups.
However the images under Person Information Lookups, Document Information Lookups seem to be not appropriate.
Thanks
Quote
0 #3 Phoenix roebelenii 2021-06-22 07:10
Er bestaan veel soorten palmen, waaronder heel bekend, de Trachycarpus fortunei.
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
Quote
0 #4 poker online 2022-03-31 11:11
Peculiar article, just what I was looking for.
Quote
0 #5 my blog 2022-07-27 15:56
It's in fact very difficult in this full of activity
life to listen news on Television, therefore I only use world wide web
for that reason, and obtain the most recent information.
Quote
0 #6 mmorpg 2022-07-28 00:55
For most recent news you have to pay a quick visit
internet and on web I found this site as a most excellent web page for most up-to-date
updates.
Quote
0 #7 my blog 2022-07-29 02:54
Link exchange is nothing else but it is only placing the other person's weblog link on your page at
appropriate place and other person will also do similar in support of you.
Quote
0 #8 my blog 2022-08-04 10:09
Hello, i believe that i saw you visited my blog so
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!!
Quote
0 #9 flyff 2022-08-09 08:11
Quality content is the key to interest the viewers to pay a visit the web site, that's what
this web site is providing.
Quote
0 #10 mmorpg 2022-08-17 03:15
Thank you for the auspicious writeup. It in fact was a amusement account it.

Look advanced to far added agreeable from
you! By the way, how could we communicate?
Quote
0 #11 my blog 2022-09-20 00:34
Every weekend i used to go to see this web site, for the reason that i wish for enjoyment, since this this web
page conations really good funny data too.
Quote
0 #12 mmorpg 2022-09-21 12:40
Hi there mates, pleasant article and pleasant urging commented here, I am actually enjoying by these.
Quote

Add comment


Security code
Refresh

About the Author

Jayashree Prakash

Jayashree Prakash

Jayashree is a Oracle Fusion HCM certified consultant who has over fifteen years' experience with Oracle. She has worked as a consultant with several of Alberta's energy companies. She lives in Edmonton and her interests include staying active in the warmer months and vacationing in the Caribbean in the winter

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner