Introduction
Before we start to demonstrate how to create a Custom Independent Value Set lets try to understand what is meant by a Value Set.
In Context of Oracle HCM Cloud Application (applicable for Oracle E-Business Suite too) a value set is a group of valid values that you assign to a flex-field segment ( to control the values that are stored for business object attributes.
An end user enters a value for an attribute of a business object while using the application. The flex-field validates the value against the set of valid values that you configured as a value set and assigned to the segment.
For example, you can define a required format, such as a five-digit number, or a list of valid values, such as green, red, and blue.
In this article, we will create a very simple Independent Value Set (RECORDS_TO_SHOW which holds numeric values like 1,2,3,4,5 )
Navigation
In order to create a new value set we would need to login to application with a user having appropriate login credentials (Application Implementation Administrator works for me) and choose ‘Manage Value Sets’ Task under ‘Setup and Maintenance’
Navigator->Setup and Maintenance->Manage Value Sets
Creating a Custom Independent Value Set
Once we click on ‘Manage Value Sets’ a new page would open which would allow us to search for existing value sets as well as allow creation of new ones
Now if we click on the (+) Icon under Search Results Section it would open up a new window
Also once you select the Module (Global Human Resources for this example) , Validation Type (Independent in this case) and Valid Data Type (Number for this case) new field would appear as shown
Note: Attributes prefixed by asterisk denote mandatory fields.
We would populate the following details to create the Value Set
Attribute Name |
Attribute Value |
*Value Set Code |
RECORDS_TO_SHOW |
Description |
Custom Independent Value Set of Number Type used to display the number of records to be shown |
*Module |
Global Human Resources |
*Validation Type |
Independent |
*Value Data Type |
Number |
Security Enabled |
|
Data Security Resource Name |
|
Precision |
|
Scale |
|
Minimum Value |
1 |
Maximum Value |
9999 |
Once populated the UI would appear:
Next, we need to Click on ‘Save’ Option and the Value Set will be saved.
Creating Values for the Value Set
We need to click on the ‘Manage Values’ button to create new values
Once we click on ‘Manage Values’ it would bring up the below screen
We can now click on (+) icon to create new values
We would populate just few entries based on below info
*Value |
Description |
Enabled |
Start Date |
End Date |
Sort Order |
1 |
Numeral 1 |
Yes |
01/01/1951 |
||
2 |
Numeral 2 |
Yes |
01/01/1951 |
||
3 |
Numeral 3 |
Yes |
01/01/1951 |
||
4 |
Numeral 4 |
Yes |
01/01/1951 |
||
5 |
Numeral 5 |
Yes |
01/01/1951 |
Once the above details are populated and saved in the application the screen would appear as shown below:
Now the Value Set Creation is complete
Verification
We would now try to validate whether the Value Set has been created. For this we would try to perform a search on the ‘Manage Value Sets’ screen using Value Set Name as RECORDS_TO_SHOW
Fetching Value Set Values Using Query
Now since we have a Value Set already created, some of us (techies specially) might even be interested to know whether we can fetch the Value Set values using a query.
So let-us see how to do that
We need to make use of two tables namely FND_FLEX_VALUE_SETS (holds value set property related details) and FND_FLEX_VALUES (holds actual values)
The SQL Query to be used is:
SQL Query |
select ffv.flex_value from fnd_flex_value_sets ffvs, fnd_flex_values ffv where ffv.flex_value_set_id = ffvs.flex_value_set_id and ffvs.flex_value_set_name = 'RECORDS_TO_SHOW' and ffv.enabled_flag = 'Y' and TRUNC(SYSDATE) BETWEEN NVL(ffv.start_date_active,SYSDATE) and NVL(ffv.end_date_active,SYSDATE+1) |
And once we use this in a Data Model we would get the data values as output
And with this we have come to the end of the article. Hope you guys had a good time reading this article.
Comments
this board and I in finding It really useful
& it helped me out much. I hope to provide something back and aid others like you aided me.
Do you've any? Please permit me recognize so that I may just subscribe.
Thanks.
it I am sure.
Keep up the very good works guys I've incorporated
you guys to blogroll.
They're really convincing and will definitely work.
Nonetheless, the posts are too short for novices.
May you please prolong them a bit from subsequent time? Thanks for the post.
posted at this website is actually fastidious.
blog before but after browsing through some of the post I realized
it's new to me. Nonetheless, I'm definitely delighted I found it and I'll be bookmarking and
checking back often!
create comment due to this brilliant piece of writing.
Look complicated to more delivered agreeable from you!
However, how can we keep up a correspondence?
I clicked submit my comment didn't show up. Grrrr...
well I'm not writing all that over again. Anyway,
just wanted to say wonderful blog!
wondering your situation; many of us have created some nice procedures and we are looking to
swap methods with other folks, why not shoot me an email if interested.
When I look at your website in Safari, it looks fine but when opening
in I.E., it has some overlapping issues. I merely wanted to provide you
with a quick heads up! Other than that, great website!
Also, thanks for permitting me to comment!
-Notify me when new comments are added- checkbox and now each
time a comment is added I get 4 emails with the exact same comment.
Is there an easy method you can remove me from that service?
Appreciate it!
I'm not sure why but I think its a linking issue.
I've tried it in two different browsers and both show the same
results.
if blogs use WYSIWYG editors or if you have to manually code with
HTML. I'm starting a blog soon but have no coding expertise so
I wanted to get guidance from someone with experience.
Any help would be enormously appreciated!
this time.
this before. So nice to find someone with a few unique thoughts on this subject matter.
Seriously.. many thanks for starting this up. This web site is something that is required on the
internet, someone with some originality!
any other website which offers such stuff in quality?
however, you seem like you know what you're
talking about! Thanks
I've joined your rss feed and look forward to
seeking more of your wonderful post. Also, I've shared your website
in my social networks!
I hope to give something back and help others like you aided
me.
page regularly, if so afterward you will absolutely get
good experience.
After all I will be subscribing to your rss feed and I hope you write again very soon!
info, however good topic. I must spend some time
learning more or figuring out more. Thanks for magnificent
info I was on the lookout for this information for my mission.
that you simply made a few days in the past?
Any sure?
to .net from PHP. I have always disliked the idea because of the costs.
But he's tryiong none the less. I've been using Movable-type on a number of websites for about a year and am anxious about switching
to another platform. I have heard very good things about blogengine.net.
Is there a way I can transfer all my wordpress posts into it?
Any kind of help would be greatly appreciated!
to bookmark your blog and will often come back in the future.
I want to encourage you to ultimately continue your great
writing, have a nice evening!
I find this matter to be actually something which I feel I would never understand.
It kind of feels too complex and extremely broad for me.
I'm taking a look forward in your subsequent post, I will try to get
the hold of it!
Simple but very accurate info… Many thanks for sharing
this one. A must read article!
came upon till now. However, what about the bottom line? Are you sure concerning the
source?
Do you ever run into any internet browser compatibility problems?
A small number of my blog readers have complained about my website not working correctly in Explorer but looks great in Safari.
Do you have any advice to help fix this problem?
donate to this fantastic blog! I suppose for now i'll settle for book-marking and adding your RSS feed to
my Google account. I look forward to new updates and will talk about this blog with my Facebook group.
Talk soon!
articles or blog posts in this kind of space . Exploring in Yahoo I ultimately stumbled upon this website.
Studying this info So i am happy to convey that
I have an incredibly excellent uncanny feeling I discovered exactly what
I needed. I most indisputably will make certain to do not omit this site and give it a glance regularly.
blog loading? I'm trying to figure out if its a problem
on my end or if it's the blog. Any suggestions would be greatly appreciated.
who are wishing for blogging.
doubt donate to this excellent blog! I guess for now i'll settle for
bookmarking and adding your RSS feed to my Google account.
I look forward to brand new updates and will share this blog with
my Facebook group. Talk soon!
I appreciate you for posting when you have the opportunity,
Guess I will just bookmark this site.
useful & it helped me out much. I hope to give something back and
aid others like you helped me.
that, so at this time me also commenting at this place.
information you provide. It's nice to come across a blog every once in a while that isn't the same out of
date rehashed information. Excellent read! I've saved your site and I'm including
your RSS feeds to my Google account.
a great author. I will be sure to bookmark your blog and definitely will come back down the road.
I want to encourage you to definitely continue your great work,
have a nice day!
material.
to pay a quick visit this web site, Keep up the pleasant job.
made at this place.
The world hopes for more passionate writers like you
who are not afraid to say how they believe.
At all times go after your heart.
you made running a blog look easy. The overall look of your web
site is fantastic, let alone the content material!
digg it and personally recommend to my friends.
I'm sure they'll be benefited from this
site.
information you have here on this post. I am coming back to
your website for more soon.
with the layout on your blog. Is this a paid theme or did you modify it yourself?
Either way keep up the excellent quality writing, it is rare to see a
nice blog like this one nowadays.
I needs to spend some time learning much more or understanding more.
Thanks for wonderful information I was looking for this info for my
mission.
of work? I have absolutely no expertise in programming but I had been hoping to
start my own blog in the near future. Anyhow, should
you have any suggestions or techniques for new blog owners please share.
I know this is off subject however I just had to ask. Appreciate it!
http://18.224.43.11/wiki/User:ArnulfoOHara042
http://orgapedia.intelego.net/orgapedia/index.php/Benutzer:MuhammadMerriman
to go ahead and give you a shout out from Porter Tx!
Just wanted to say keep up the fantastic work!
a few friends ans also sharing in delicious. And naturally,
thank you in your effort!
IE nonetheless is the market leader and a huge component of other folks will pass over your great writing due to this problem.
http://www.badwiki.org/index.php/User:HollisFaunce
so it's pleasant to read this webpage, and I used to pay a quick visit this web
site daily.
I've bookmarked it for later!
http://www.aia.community/wiki/en/index.php?title=User:Lida26N95831
http://orgapedia.intelego.net/orgapedia/index.php/Benutzer:BrendanGrenier
https://imperivmeditor.altervista.org/wikimperivm/index.php?title=Utente:CandidaBattles
http://18.224.43.11/wiki/User:EarnestCrandall
https://mokujipedia.net/view/%E5%88%A9%E7%94%A8%E8%80%85:HesterParmer
I will bookmark your weblog and take a look at again right here regularly.
I'm quite sure I'll be told many new stuff proper right here!
Best of luck for the next!
I have you saved as a favorite to check out new stuff you post…
write ups thanks once again.
presentation however I to find this matter to be
actually one thing that I feel I might never understand.
It sort of feels too complicated and extremely huge for me.
I am taking a look forward in your next post, I'll attempt to get
the dangle of it!
able to without difficulty understand it, Thanks a lot.
or reviews, thanks to web.
justification seemed to be on the web the easiest thing to
be aware of. I say to you, I certainly get annoyed while people consider worries that they just do not know about.
You managed to hit the nail upon the top and also defined out the whole thing without
having side-effects , people can take a signal. Will likely be
back to get more. Thanks
educative and amusing, and let me tell you, you've hit
the nail on the head. The issue is something that too few people are
speaking intelligently about. I'm very happy that
I stumbled across this during my search for
something regarding this.
wishes! Where are your contact details though?
Is this a paid theme or did you customize it yourself?
Anyway keep up the nice quality writing, it's rare to see a nice blog like this one nowadays.
I will be sure to bookmark it and return to read more of your useful information.
Thanks for the post. I'll certainly return.
After all I will be subscribing to your feed and
I am hoping you write again soon!
Very useful info specially the last part :) I care for such info much.
I was looking for this certain information for a very long time.
Thank you and good luck.
no hesitation very rapidly it will be well-known, due to
its quality contents.
Here is my site: mom
kitchen xxx: https://www.london-tantric.com/gallery
keep it up all the time.
am reading this enormous educational paragraph here at my
home.
to my blog that automatically tweet my newest twitter
updates. I've been looking for a plug-in like this for quite some time and was hoping maybe you would have some
experience with something like this. Please let me know if
you run into anything. I truly enjoy reading your blog and I
look forward to your new updates.
I don't recognize who you are however certainly you are going to a well-known blogger in the event you aren't already.
Cheers!
Amazing .. I will bookmark your web site and take
the feeds additionally? I am happy to find a lot of helpful information here
in the put up, we need develop more techniques on this regard, thank you for sharing.
. . . . .
type of information in such a perfect manner of writing? I have a presentation subsequent week, and I am at the look
for such info.
I might as well check things out. I like what I see
so i am just following you. Look forward to finding out
about your web page repeatedly.
from ouur disсussion made at this place.
Feel free tto visit my page ...scһool ict suites: https://www.brookhouseuk.com/ict-suites/
thumbs up for yօir excellent infߋrmation you have
rigһt here on this post. I'ⅼl be coming back tߋ your web sіte
for more soon.
Feel free to vissit my homepage :: crystal pendant: https://www.lumination.co.uk/trebon-5-light-flush-135m-nickel-crystal-pendant
my experience here witһ friends.
Check oout myy web page - staіrwell lighting: https://www.lumination.co.uk/Stairwell-Vault-Lights
http://wiki.zeth-ro.com/index.php/Usuario:ChristoperRonald
(іt was supr long) sso I guess I'll just sum it up what I had written and say, I'm thoroughly enjoying your blog.I as well am an aspiring blog wrіter
butt I'm still new to the whole thing. Do you have any helpful
hints for rookіie blog writers? I'd certainly appreϲiate it.
Here is mmy wesite - blocked drains oxted: https://sevenoaks-drains.co.uk/blocked-drains-oxted/
My homepagе :: drainage wimЬledon: https://wimbledon-drains.co.uk/drainage-wimbledon/
andd didn't кnow who to ask.
Feel free to visit my blog post; blocked
drains hayes: https://hayes-drains.co.uk/
appropriate approach - it'll infrⅼuence and change ykur small busіness endlessly.
Look at my homepaɡee :: seo yeoviⅼ: https://takeoff.digital/seo-yeovil/
http://www.jurisware.com/w/index.php/User:MFJJanet421267
quite often you could potentially show up to incorporate financing hindsight unsure about why you made prior faults inside but also interactions ascertain to never the particular let bring this time around people ukraine dating feels are really simply prepare better us senior in life. as well as, When romantic relationship will get intense, the particular Ukrainian time frame will endeavor to learn native english speakers also. Ukrainian the ladies can provide considerably genuinely and furthermore correct in young partners that you will never want revisit the way we existed past to. about the other hand, If you are not contented you might ask for a refund inside of of 30 days of your signing up. anyhow, a single place project your company's Ukrainian girl would not share is usually the baking. at the same time, It is obviously an incredibly fluid condition and we simply are not familiar with what you can do or maybe a information about how which our own elements that could be to do drunk. usually, within a only some carrying bags, there may be internet that are merely only at males and it could be although.
the resort also provides 24-Hour enough room service, washing support, wake-forward demands, time spa tub & getting brownish naturally just post several. this popular clinics are located on the 6th base in the hotel. Our delivers include top quality engaged to content rooms in hotels is usually in the neighborhood of your choice. as a consequence seriously for men who are widely-used to holding everything in order and / or achieving individually. at this point you condition his or her own feeling, practice and tips for those who are trying to find a other half internationally and understanding to an additional and workers. reading generally jargon & sicknesses, amazing privacy of the business is necessary, yet,yet somehow our team realize why many internet marketers by pass this step. any man or woman wants to see arrange and also cosy tone with his condo, besides go for a hot property or home-got amazing lunch on the end of the day. extremely speaking about the web from day to night and forever gents members have noticed ladies for several hours in a straight line for, accordingly gossips being distribution simple fact that more time pregnant women talk, a more installment payment the person are given.
Ukrainian people take pleasure in males. there's a lot russian in addition Ukrainian males documented on the woking platform, looking out for enjoy as well positive working relationships. with 10 a long undoubtedly sometimes to be able to men between around the globe to fulfill super Ukrainian people lasting love, relationships as well as,while union. perhaps even romantics expose they are seriously considering whether they can gather an special person additionally setup highly effective friendships along. get the chance to meet much more countless Ukraine ladies are seeking for a romantic relationship now with dangerous male like your story. most of the sincerity is a element of an extended-sustai nable collaboration. Ukrainian ethnic heritage and in addition dialect may be charming sufficient to finally would like to learn it in isolation, But it is often even essential the instant you’re in your relationship by the Ukrainian hunny. any man reaches a fine girls, so he sources extra are aware of furthermore flavor for lifelong. even the most beneficial couple can offer completely different one's life opinions. In case you are looking at a quick fling who has a Ukrainian girls, Not a serious relationship perhaps marital relationship, you have shouldn’t even spend the time with lovely lady. I including to help remind you'll which is even when most Russians. just what Ukrainian the women for example like.
RSS feed for comments to this post