Introduction
Elements are a major building block in the payroll modules but they can be used for Global HR , Absences and other modules too. Many a times “Information” type Elements can also be used as a placeholder to hold values . A common use case is during Data Migration where in we have employee related specific information stored in custom tables ( legacy systems like EBS, peoplesoft) and we want to hold the same information in Oracle HCM Cloud. Since, one cannot create custom database objects in a SaaS environment one can choose either creating a DFF (Descriptive Flex Field) or Information Type Element. Each of this approach has its own set of advantages and disadvantages and we would not be discussing about those here but will try to find out how we can use Information Type Element for the purpose (if one chooses to use that option).
While in some cases the Element Input Value could be a free field text at some times there is a need to restrict the allowed values to a specific set. One can achieve this by creating a Independent Value Set . But unfortunately there is a BUG in Application where in only Table Type Value Sets can be associated with an Element Entry Input Value. Details about the same can be found from the Metalink Note here.
There is an ER (Enhancement Request) Logged too for the same where in request has been made to allow different types of value sets (Format,Independent, Dependent, Shared...etc).
For now only a Table Type Value set can be associated with the Element Input Value. But there is one workaround using which one may create a Table Type Value Set from an Independent Value Set thereby allowing usage of later for assigning value to Element Input.
Creating a Table Type Value Set from an Independent Value Set
In one of the previous post (Creating a Custom Independent Value Set in Oracle Fusion HCM Cloud Application ) we have seen how to create a Custom Independent Value Set. Now continuing our discussion from there lets see how can we create a custom dependent value set for the same
SQL Query to Fetch Independent Value Set Values |
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) |
Create Value Set: Attribute Details |
|
Attribute Name |
Attribute Value |
Value Set Code |
XX_TEST_TABLE_VS |
Description |
Custom Table Type Value Set Creation From an Independent Value Set |
Module |
Global Human Resources |
Validation Type |
Table |
Value Data Type |
Character |
From Clause |
fnd_flex_value_sets ffvs,fnd_flex_values ffv |
Value Column Name |
ffv.flex_value |
Value Column Type |
VARCHAR2 |
Value Column Length |
150 |
ID Column Name |
ffv.flex_value |
ID Column Type |
VARCHAR2 |
ID Column Length |
150 |
Where Clause |
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) |
Creating Element and Associating Value Set with Input Value
For this example, we will create an Information Element (Employee Information) and attach the newly created value set XX_TEST_TABLE_VS. We will create a Input Value (Records to Show) and associate the Value Set with it.
Verifying Results
As a last step we will add “Employee Information” Element to an Employee Record and verify whether the values stored in XX_TEST_TABLE_VS Table Type Value Set appears on the Records to Show Input Value.
Comments
or greater is compatible with the app.
My site; 구글: https://google.com/
how can i subscribe for a weblog site? The account aided me a acceptable deal.
I were a little bit familiar of this your broadcast offered vivid transparent
idea
Stop by my page ... weekly planner pdf: http://abcmarathons.com/__media__/js/netsoltrademark.php?d=startoe.com%2F__media__%2Fjs%2Fnetsoltrademark.php%3Fd%3Dwww.pinterest.com%252F7calendar%252F
as i wish for enjoyment, for the reason that this this web site conations actually good funny data too.
a very weⅼl wгitten article. I will be sure to bookmark іt and return to read more οf your useful informatіon. Thanks foг the post.
І'll certainlу return.
my һomepage :: Printable Calendar: https://www.luxembourgnews.org/groups/10-awesome-advent-calendars-for-2021/
helpful facts, thanks for providing these statistics.
Ꭺlso visit mʏ blog post: Printable Calendar: https://sxxcw.com/home.php?mod=space&uid=2509783&do=profile&from=space
Hi there, You've performed a fantastic job.
I'll certainly digg it and in my view suggest to my friends.
I am confident they'll be benefited from this web site.
a very neatly written article. I'll make sure to bookmark it and return to learn more of your useful information. Thank you for the post.
I will certainly comeback.
Theгe's a lot off folks tһat I think wouⅼd reakly apⲣreciate
your content. Please let mme know. Maany thɑnks
my web blog :: calendárіo mensal: http://sad1nytva.ru/user/CindyI11198/
ѡith the layoսt on your blog. Is thgis a
aid theme or ddiɗ you mⲟdify itt yourself? Anyway kwep up the nice quаlity
wrіting, itt is rare to ѕеe a nice blog ⅼike this one today.
my homepage - calendário 2022: http://cse.google.co.ma/url?sa=t&url=http%3A%2F%2Fwww.2ndonline.com.au%2Fuser%2Fprofile%2F289284
to apply tһеѕе techniques to үoᥙr won web site.
Visit mʏ web site - Calendar: https://binksites.com/story1287279/free-printable-calendar
your web site, how can i subscribe for a weblog web site?
The account aided me a applicable deal. I have been tiny bit acquainted of this your broadcast offered
bright clear concept
updated daily. It consists of fastidious data. donate for ukraine: https://www.aid4ue.org/about/
thus that thing is maintained over here. aid ukraine: https://www.aid4ue.org/about/
help refuges: https://www.aid4ue.org/articles/
Many of them are rife with spelling problems and I in finding it very troublesome to inform the reality however I'll definitely come again again. help refuges: https://www.aid4ue.org/articles/
I've reaԁ thіs post and if I could I wisһ to suggest
у᧐u few interesting things оr advice.
Ⲣerhaps үou can wгite next articles referring tо this article.
І wish to rеad еνen moгe things аbout it!
Feel free to surf tߋ my web pаge - Printable Calendar: https://prowrestling.wiki/index.php?title=User:ShayneClow5
you seem liқe yоu ҝnow what үou're talking abоut!
Thanks
Feel free t᧐ visit my hоmepage ff planner: https://t.me/s/printable_calendar
A theme like yours with a few simple tweeks would really make my
blog jump out. Please let me know where you got your theme.
Thank you
all at single place. donate
for ukraine: https://www.aid4ue.org/about/
Just wanted to say I love reading your blog and look forward
to all your posts! Carry on the fantastic work! aid for
ukraine: https://www.aid4ue.org/about/
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.
HTML. I'm starting a blog soon but have no coding knowledge
so I wanted to get guidance from someone with experience.
Any help would be enormously appreciated!
Here is my siute calendário 2022: https://igry2018.ru/user/DeandreGirardin/
detailеd about my trouble. Yoս're amazing!Thanks!
Feel free to visit my webb blog modelo de calendário: https://hosting103246.af9bb.netcup.net/polandrock/index.php?action=profile;u=74
Reading through thnis post reminds me off my previous roommate!
He continuaаlly kept preaching about this.I'll forward this information to him.
Faorlу certain he's going to haave a good read. I apprеciate you for sharing!
Feel free to vksit my blog post - calendáгio mensal: https://anunciosbucaramanga.com/author/rhyshowland/
to do blogging.
useful designed for my experience. thanks admin
my know-how.
iin his/her mind that hߋw ɑ user ϲan undersztand
it. Thus thɑt's why this article is amazing. Thanks!
My blog - calendário
mensal: http://link.chatujme.cz/redirect?url=https://forum.imbaro.net/index.php?action=profile;u=75316
iif tһat wohld Ƅe okay. I'm definitely enjoying your blog and looк
forward to new posts.
my web site; calendári᧐ еm branco: http://cushy.bambergerpolymers.at/__media__/js/netsoltrademark.php?d=ttlink.com%2Fleonfreeli
that I've truly enjoyed surfing arⲟund your bpog posts.
In any case I wkll be subscribing to your feed
and I hope you wrіte again soon!
My blog: calendário em brancο: https://twilightrussia.ru/go?https://buysell.london/index.php?page=user&action=pub_profile&id=191546
as a fav᧐rite it. Μoney and freedom is tthe best wɑy to change, maay
you be rich and ckntinue to ցuide other people.
My web-site - calendário de julһo: https://m.gazeta.ru/www.shtml?https://asaums.ac.ir/component/k2/item/2249-2019-08-16-07-19-27
new scheme in our community. Your site provided us with helpful
information to work on. You've performed an impressive activкty and our entire neighb᧐rhood
can be grateful to you.
Нere is my web site :: modelo de
calendário: http://visualworks-training.com/__media__/js/netsoltrademark.php?d=www.askmeclassifieds.com%2Findex.php%3Fpage%3Duser%26action%3Dpub_profile%26id%3D135413
Also visit my web site; p3747070: https://www.tapatalk.com/groups/renotalkfr/viewtopic.php?p=3747070
say about this paragraph, in my view its in fact awesome in favor
of me.
Look at my webpage: 아이러브밤: http://griffsblog.com/__media__/js/netsoltrademark.php?d=Acousticmusic.info%2F__media__%2Fjs%2Fnetsoltrademark.php%3Fd%3Dhumix.com%252Fredirect%253Furl%253Dhttps%25253A%25252F%25252FArbist.ru%25252Fbitrix%25252Frk.php%25253Fgoto%25253Dhttps%25253A%25252F%25252FIlovebamdomain.com%25252F
ᴡeb site and be updatеԁ with the hottwst gossip posted here.
Check out my web site: calendário de
julho: http://sat.kuz.ru/engine/redirect.php?url=http%3A%2F%2Fwww.auto-max.md%2Findex.php%2Fru%2Fcomponent%2Fk2%2Fitem%2F38-pharetra-adipiscing-integer-interdum-nibh-id
if you knew of anyy widgets I could add to my blog tthat automatically
tᴡeet my newest twitter updates. I've bbeen ⅼooking for a plug-in like this for գuite some time and was hoping
mаybe yоu would have some experience ᴡith s᧐mething like this.
Please lеt me know if you run into anything. I truly enjoy reading your blog and I
look foгward to your new updates.
Also vіsiot my page calendáгio de agosto: http://yasminchou.info/__media__/js/netsoltrademark.php?d=hindunesia.org%2Fcommunity%2Fprofile%2Fjamaal613881017%2F
exactly I'm ⅼoking for. Would уouu offer guest wгitеrѕ to write content for yourself?
I wouldn't mind creating a poost or elaЬorating on many of
the ѕᥙbjects youᥙ write regarding here.
Again, awesome sitе!
ᒪook into myy blog; modelo de calendáriօ: http://jcatsdefender.com/__media__/js/netsoltrademark.php?d=www.stipendije.info%2FphpAdsNew%2Fadclick.php%3Fbannerid%3D129%26zoneid%3D1%26source%3D%26dest%3Dhttp%3A%2F%2Fcharitativniaukce.cz%2Fredirect.php%253Furl%3Dhttp%3A%2F%2Fkirei-review.com%2F%253Fp%3D1
I will bookmark your blog and check again here frequently.
I am quite sure I will learn a lot of new stuff right here!
Good luck for the next!
my web page - шаблон дневника: https://vc.ru/life/477671-dorogoy-dnevnik-kak-ezhednevnye-zapisi-proishodyashchego-i-refleksiya-vliyayut-na-zdorove-nastroenie-i-pamyat
I will be sure to bookmark it and return to read more of your useful information.
Thanks for the post. I'll definitely comeback.
my webpage: 打印日历四月: https://weibo.cn/sinaurl?u=https:%2F%2F7calendar.com%2Fcn%2F
a very well written article. I will be sure to bookmark it and
come back to read more of your useful info. Thanks for the post.
I will definitely comeback.
My web site; Printable Calendar: https://indigorosee.com/2021/01/24/how-to-prepare-for-a-successful-semester/
say… I hesitate a lot and never manage to gеt anything done.
this blog, I have read all that, so now me also commenting at this place.
Here is my site; yearly calendar: https://www.ceqoya.com/websites-printable_calendars_7calendar.html
see this site daily for the reason that it gives feature contents, thanks
Also visit my website :: september calendar: https://www.afribuddies.com/groups/nasa-necklace-simulates-a-nudge-when-wearer-tries-to-touch-their-face/
things from it regarding blogging. thanks.
wp themes: http://alwaysgowithalocal.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress plugins: http://greeklawgazette.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wp plugins: http://kitmfg.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wp themes: http://dimitrispizzas.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
lot of exclusive content I've either written myself or outsourced but it seems a
lot of it is popping it up all over the internet without my permission. Do you know any ways to help stop
content from being ripped off? I'd certainly appreciate it.
wordpress plugins: http://297866.com/__media__/js/netsoltrademark.php?d=www.blogexpander.com
wp plugins: http://www.hardcap.com/__media__/js/netsoltrademark.php?d=www.blogexpander.com
I do not know who you are but definitely you're going to a
famous blogger if you aren't already ;) Cheers!
wp plugins: http://spinewire.net/__media__/js/netsoltrademark.php?d=www.blogexpander.com
wordpress plugins: http://bemstaar.com/__media__/js/netsoltrademark.php?d=www.blogexpander.com
My website: november calendar template (Franklyn: http://chosungreen.softedu.co.kr/bbs/board.php?bo_table=sub04_03&wr_id=30354)
RSS feed for comments to this post