Introduction
Of late I have received some feedback/inputs from some of my peers and well-wishers that my articles are getting more tech-savvy with less content (explanation) and more of screenshots. A very valid point considering few of my fast formula related articles but point well taken, going forward will try to keep things simple so as to cater to an audience with practically no hands on experience on the application.
I am sure most of the us (including those who are starting their careers either with EBS or Fusion) must have heard of terms like Lookups, Value-Sets too often and at times do get used to them without actually trying to understand what are they and why are they used.
In this article, I will try to explain what is meant by a lookup, why is it required, how many types of lookups, where it is used and so on…
So let-us start and the first and foremost question is:
What is a Lookup?
The literal meaning of lookup stands as
“an act or instance of looking something up, as information in a reference book or an online database” and the Oracle Fusion definition of Lookup isn’t too far away either, defined in the simplest terms “a lookup is a way to provide validation (using list of values) for a user input field in a user interface”. A typical example could be a field on UI form say Gender which might only allow values like ‘Male’ or ‘Female’. The application would not allow any other value apart from the ones listed in the drop down list attached to the form field.
What are the different types of Lookup?
A Lookup may be classified in multiple ways depending on the UI View Page where the same is defined and also depending upon the various customization levels (namely user, extensible and system).We would discuss both these type of classification here.
Lookup Classification Based on UI View Page Definition
Note: A reference data set may be considered as a data partitioning layer. For a set-enabled lookup the lookup-code (a lookup component discussed in detail later) is associated with specific data-set for example if the lookup-code is associated with US (short code for United States Legislation) it would not be used for EU (short code for European Union) and vice versa.
The different lookup types based on this classification are:
-
Common Lookups
These are the lookups which got migrated from the Legacy Systems as is (they belonged to the Common Lookups Category in other ERP systems) and are provided to ensure backward compatibility is maintained. They are defined in the Common Lookup View
Standard Lookups
Standard lookups are the simplest form of lookup types consisting only of codes and their translated meaning. They are defined in the Standard Lookup View
Set-Enabled Lookups
Set enabled lookup types store lookup codes that are enabled for reference data sharing. At runtime, a set-enabled lookup code is visible because the value of the determinant identifies a reference data set in which the lookup code is present.
Standard, set-enabled, and common lookups are defined in the Standard, Set-enabled, and Common views, respectively. Applications development may define lookups in an application view to restrict the UI pages where they may appear.
In lookups management tasks, lookups may be associated with a module in the application taxonomy to provide criteria for narrowing a search or limiting the number of lookups accessed by a product specific task such as Manage Purchasing Lookups
Components of a Lookup
A Typical lookup comprises of the following elements/attributes:
-
Lookup Type
Each of the lookup values (referred to as lookup-code) are clubbed into one or another groups depending on their specific use.
For example,
A MAR_STATUS Lookup Type will hold values like Single, Married, Divorced ….etc
Similarly a EMP_CAT Lookup Type will hold values like Full Time Regular, Part Time Regular, Permanent, Temporary..etc
-
Meaning
This field gives the meaning of the Lookup Type field. While the Lookup Type field holds only a short code (used for internal reference within application) and doesn’t allows spaces in between the Meaning field is the one which gives a more clear understanding of the Lookup Type.
For Example
MAR_STATUS lookup type has Meaning as Marital Status
EMP_CAT lookup type has Meaning as Assignment Category
-
Description
This field holds the complete description of the lookup type.
MAR_STATUS lookup type has description as Status of Person’s Marriage
EMP_CAT lookup type has description as Employment assignment categories.
-
Module
Each of the lookup type belongs to one or another module depending on the area where it is used. A lookup which is used for Absence Management would typically have a module name as Absence Management one which belongs to Human Resources ( MAR_STATUS is an example) will have a Module Name as HR ( stands for Human Resource)
-
Customization Level
Last but definitely not the least important attribute of any lookup this field helps us to identify whether we would be able to edit the lookup values of a lookup. They are of three types namely:
-
User: A Lookup Type which provides complete control on the lookup values. Adding, Deleting, editing…etc
-
Extensible: These lookup types have some lookup values which are pre-defined but can be extended to meet business needs. We can add/edit new values but are not allowed to make changes to existing pre-defined ones.
-
System: You are only allowed to change the Meaning field of the Lookup
If a product depends on a lookup type, the customization level should be system or extensible to prevent deletion. Once the customization level is set for a lookup type, it cannot be modified. The customization level for lookup types created using the Define Lookups page is by default set at the User level.
The various lookup Management tasks which are allowed at various customization layer when captured in a tabular format would look as:
Till now we only have covered the components of a Lookup Type but just having a lookup type does not make any sense until there are lookup values in it.
So let us spend some time to understand the various attributes of a Lookup Value too
-
Lookup Code
These are the actual values which are displayed as a List of value items on the user interface. Each value should be unique (for a specific lookup) and there should not be any spaces in between.
‘S’ which stands for Single and
‘M’ which stands for Married are typical examples for MAR_STATUS lookup type
-
Display Sequence
Each lookup code is assigned a display sequence basis which the value appears in the drop down list. We may change the sequence at any time but care should be taken that no two lookup codes hold the same sequence at any given point of time
-
Enabled
This attribute ensures whether a particular value would be displayed to the end user or not. If the ‘Enabled’ checkbox is checked than the specific lookup-code maybe used while performing transactions from user interface and if the same is unchecked the same would not be visible on the User Interface.
-
Start Date
This field holds the date from which a particular lookup-code can be used. It is always advised to have a very early date so that inconsistencies are avoided while performing transactions.
-
End Date
As the name suggests this field controls the end-date of a lookup-code. If we had a Lookup-code which was used till a particular date but is not supposed to be used post a specific date we may put the same date value here and this would ensure that the lookup-code does not shows up in the List of value post the end-date.
-
Meaning
The actual value which is displayed to the user. For example, ‘Yes’ for lookup-code of ‘Y’ and ‘No’ for lookup-code ‘N’
-
Description
This field holds the detailed info about a specific lookup-code. The field length is large enough and is used to give a clear idea to consultants and business users about a specific lookup-code.
-
Tag
One of the most important field which controls lookup code usage legislation wise. Say for example we have three legislations namely US, UK and IN and as per the country specific rules all unmarried individuals in India have a Lookup Meaning as ‘Unmarried’ for India (IN) while for US and UK they are referred to as ‘Single’. In this scenario although both the lookup-codes say U (for unmarried individuals used in India) and S (for individuals based in US,UK) would be present in the MAR_STATUS lookup type but only ‘U’ should be visible for users who belong to India legislation and similarly ‘S’ should be visible to users of ‘US’ and ‘UK legislation. In this scenario the TAG fields comes to the rescue. We would need to tag the legislation code beside the specific lookup-code value (Using a + sign followed by Legislation Code ensures the lookup-code is enabled with the legislation)
Lookup Code |
Tag |
Impact |
U |
+IN |
Used for India Legislation |
S |
+US,+UK |
Used for US and UK Legislation |
Comments
of this post, in my view its truly awesome designed
for me.
you amend your web site, how could i subscribe for a blog site?
The account helped me a appropriate deal. I were tiny bit familiar of this your broadcast provided vibrant transparent concept
I've got some ideas for your blog you might be interested in hearing.
Either way, great website and I look forward to seeing it expand over time.
from this post.
be happy. I have read this post and if I could I want to
suggest you some interesting things or tips. Perhaps you can write next
articles referring to this article. I wish to read even more things about
it!
a coworker who had been doing a little homework on this.
And he in fact bought me lunch simply because
I found it for him... lol. So allow me to reword this....
Thank YOU for the meal!! But yeah, thanx for spending time to talk about this topic here on your site.
Where else may I get that type of info written in such
an ideal manner? I have a venture that I am simply now operating on, and I've been at the glance
out for such information.
It really useful & it helped me out much. I hope to give something back and help others like you aided me.
to test the spelling on quite a few of your posts.
Many of them are rife with spelling issues and I find it very troublesome to tell the reality however I'll
certainly come again again.
You certainly understand how to bring an issue to light and make it important.
A lot more people must check this out and understand this side of your story.
I was surprised that you aren't more popular given that you surely possess the gift.
I really like what you have bought here, certainly like what you are saying and the best way by which you are saying it.
You make it entertaining and you continue to
take care of to stay it sensible. I can not wait to learn much
more from you. This is really a great site.
long) so I guess I'll just sum it up what I wrote and say, I'm
thoroughly enjoying your blog. I too am an aspiring blog writer but I'm still new to everything.
Do you have any recommendations for beginner blog writers?
I'd definitely appreciate it.
actually loved the standard info a person supply in your guests?
Is gonna be back ceaselessly to check up on new posts
will get benefit from it I am sure.
I must spend a while finding out more or understanding more.
Thank you for fantastic info I used to be on the lookout for this information for my
mission.
must be visit this web page and be up to date all the time.
visit this web page daily since it gives feature
contents, thanks
web site presents feature based posts.
person's weblog link on your page at appropriate place and other person will also do similar
in favor of you.
And i'm glad reading your article. But wanna remark on few general things, The web site style
is great, the articles is really great : D. Good job, cheers
time now and finally got the bravery to go ahead and give you a shout out
from Houston Texas! Just wanted to say keep up the excellent job!
chance (stumbleupon). I have bookmarked it for later!
suppose its ok to make use of some of your concepts!!
here every material is quality based stuff.
some friends ans also sharing in delicious. And of course, thank you
for your sweat!
de elegir los textos de tus invitaciones. Si bien encontrarás
variantes para decir lo mismo, lo mejor siempre es
seguir un estilo convencional con datos tales como día,
hora y lugar deben estar sí o sí. Cuadros Selfies son los mejores, quedan muy bien para el
diseño, Tenemos más de 50 Fondos variados para escoger,
Cuadros personalizados de colores, tipo animados o natural, Cuadros personalizados con fondos de paisajes o pinturas,
agregamos más variedad con el tiempo para que puedas tener
el detalle personalizado perfecto! Vamos, sabemos lo difícil que
es hacer un lindo regalo para un bebé y que no quede para donar
al poco tiempo (es que crecen muy rápido). Aunque si no tienes prisa,
puedes elegir un envío por Correos que es un poco más asequible de precio.
En otras bodas han dejado un poco de arena en sus frascos,
simbolizando que, aunque a partir de ahora estan juntos, van a mantener vuestra propia personalidad.
Sea cual sea su origen, el ritual de la arena es un rito que no
está vinculado a ninguna religión y simboliza la unión y unidad de dos personas en un proyecto en común.
go to see this blog on regular basis to get updated from newest gossip.
blog! I suppose for now i'll settle for book-marking and
adding your RSS feed to my Google account. I look
forward to fresh updates and will talk about this blog with my
Facebook group. Talk soon!
I'm definitely loving the information. I'm book-marking and will be
tweeting this to my followers! Terrific blog and superb style and
design.
which I think I would never understand. It seems too complex and very broad for
me. I'm looking forward for your next post, I'll try to get the hang of it!
old room mate! He always kept chatting about this. I will forward this post to him.
Fairly certain he will have a good read. Thank you for sharing!
this blog and I am inspired! Extremely helpful info specially the last section :)
I deal with such information much. I was seeking this certain information for a very lengthy time.
Thank you and best of luck.
Look complex to more brought agreeable from you!
By the way, how can we be in contact?
web for that purpose, and get the hottest news.
great written and include approximately all vital infos.
I would like to peer more posts like this .
I will be sure to bookmark your blog and may come back later in life.
I want to encourage that you continue your great job, have a nice holiday weekend!
Also visit my page :: RUAY: https://answers.productcollective.com/user/ruayshuay
they will get benefit from it I am sure.
thanks admin
It kind of feels that you are doing any unique trick. Furthermore,
The contents are masterwork. you have performed a magnificent process
on this matter!
Keep up the great writing.
regarding this paragraph, in my view its genuinely awesome
in favor of me.
happy that you simply shared this useful information with
us. Please stay us up to date like this. Thank you for sharing.
am getting that type of info written in such an ideal approach?
I've a venture that I'm simply now operating
on, and I have been on the glance out for such info.
The clarity in your put up is simply cool and i can suppose you're knowledgeable
in this subject. Well with your permission allow me to grasp
your RSS feed to stay up to date with drawing close post.
Thanks one million and please keep up the enjoyable
work.
blogosphere. Short but very accurate information… Appreciate your sharing
this one. A must read post!
fast! What host are you using? Can I get your affiliate link to your host?
I wish my site loaded up as quickly as yours
lol
as i like to gain knowledge of more and more.
Your favorite reason seemed to be at the web the easiest
thing to be aware of. I say to you, I definitely get
irked whilst other folks consider issues that they just do not recognize about.
You managed to hit the nail upon the highest as well as defined out the entire thing with no need side effect , other people can take a signal.
Will likely be again to get more. Thank you
The article has really peaked my interest. I am going to
take a note of your blog and keep checking for new information about once per week.
I opted in for your Feed as well.
of information.
blog and I am impressed! Very useful info specifically the last part
:) I care for such information a lot. I was seeking this particular info for a very long time.
Thank you and good luck.
information you have right here on this post.
I will be coming back to your site for more soon.
to read posts, except this weblog offers quality based articles.
I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She placed the shell to her ear and screamed.
There was a hermit crab inside and it pinched her ear. She never wants to go back!
LoL I know this is completely off topic but I had
to tell someone!
anyone get that kind of info in such a perfect approach of writing?
I've a presentation next week, and I am at the search for such
info.
I'd like to shoot you an email. I've got some
creative ideas for your blog you might be interested in hearing.
Either way, great site and I look forward to seeing it expand over time.
RSS feed for comments to this post