Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion Blog
  • 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

Creating Custom List of Values Source for Scheduled Jobs

Introduction

I hope that most of you know how to create a “Custom ESS Job in Oracle HCM Cloud Application” and one limitation at that point of time was that we were not able to create custom list of value source and attach them with ESS job parameters. However, in the latest release (Release 13 19D) we do have the flexibility to attach a custom list of value source to ESS job parameter. The custom list of value source is based on a custom SQL (should not contain any bind variables).

In this example, we would demonstrate the same.

Pre-requisite

We should have a custom ESS Job available which should not have any list of value source attached to its parameter.

For this example, we will use a custom ESS Job titled “Get Employee Absence Plan Balance”.

We would try to submit this ESS 

Navigation-> Tools -> Scheduled Processes -> Search (Get Employee Absence Plan Balance)

 

From the above screenshot we can clearly see that all the parameters are of “Text Box” type and there is no drop-down option to choose from. 

We would now create two custom list of value source for “Absence Plan Name” and “Person Number”.

 

Navigation: Setup and Maintenance -> Manage Enterprise Scheduler Job Definitions and Job Sets for Human Capital Management and Related Applications-> Manage List of Values Sources->Create

Attribute Name

Attribute Value

*Application Name

Absence Management

User List of Values Source Name

EmployeePersonNumber

Description

Custom List of Values Source To Display Person Number for All Employees Enrolled in Absence Plan

LOVType

User Defined

Query

SELECT peo.person_number

  FROM per_all_people_f peo,

     per_assignment_status_types_vl pastv,

     anc_per_plan_enrollment appe,

       per_all_assignments_f asg,per_periods_of_service ser,per_person_types_tl per_typ, anc_absence_plans_f_tl aapft, anc_absence_plans_f aapf

 WHERE asg.person_id = peo.person_id

   AND asg.assignment_status_type_id = pastv.assignment_status_type_id

   AND peo.person_id = appe.person_id

   AND appe.per_plan_enrt_id =(SELECT MAX(appe1.per_plan_enrt_id) FROM   anc_per_plan_enrollment appe1

WHERE  appe1.person_id = peo.person_id)

   AND ser.period_of_service_id = appe.prd_of_svc_id

   AND appe.plan_id = aapft.absence_plan_id

   AND ser.person_id = peo.person_id

   AND asg.period_of_service_id = ser.period_of_service_id

   AND asg.person_type_id = per_typ.person_type_id

   AND aapft.absence_plan_id = aapf.absence_plan_id

   AND asg.primary_flag = 'Y'

   AND asg.assignment_type IN ('E', 'C', 'N', 'P')

   AND asg.assignment_status_type = 'ACTIVE'

   AND per_typ.LANGUAGE = USERENV ('LANG')

   AND aapf.plan_status = 'A'

   AND aapft.LANGUAGE = 'US'

   AND TRUNC (SYSDATE) BETWEEN peo.effective_start_date AND peo.effective_end_date

   AND TRUNC (SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date

   AND TRUNC (SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_date

   AND TRUNC (SYSDATE) BETWEEN aapft.effective_start_date AND aapft.effective_end_date

   order by peo.person_number asc



Application Screenshot

 

Similarly we need to create one more List of value for Absence Plan Name

Attribute Name

Attribute Value

*Application Name

Absence Management

User List of Values Source Name

LeavePlanName

Description

Custom List of Values to Display All Absence (Leave) Plan Names where employees are enrolled

LOVType

User Defined

Query

select aapft.name absenceplanname

from   anc_absence_plans_f_tl aapft,

       anc_absence_plans_f aapf

where  aapf.absence_plan_id = aapft.absence_plan_id

and    aapf.plan_status = 'A'

and    aapft.language = 'US'

and    trunc(sysdate) between aapft.effective_start_date and aapft.effective_end_date

and    trunc(sysdate) between aapf.effective_start_date and aapf.effective_end_date

order  by aapft.name asc

 

Application Screenshot

 

Attaching List of Values to ESS Job Parameter

We would need to associate the newly created List of value source to the ess job parameters.

Navigation: Setup and Maintenance-> Search for Task (Manage Enterprise Scheduler Job Definitions for Human Capital Management and Related Applications) -> Search for ESS Job (Get Employee Absence Plan Balance)

Search for Absence Plan Name and associate LeavePlanBalance List of Value

 

Similarly we would need to attach  EmployeePersonNumber List of Value Source to Person Number ESS Job parameter

 

We are now done with the changes.

Verifying Results

As a last step we will run the ESS Job and check if the changes have reflected

 

We would choose “Sick” as AbsencePlanName value

Similarly, we would need to choose a value for Person Number

We would choose the value of 40 for this example.

 

Output

Once the ESS job completes we can verify the output.


Ashish Harbhajanka

Comments   

0 #1 Karol 2021-05-31 20:29
This is very interesting, You are a very skilled blogger.
I've joined your feed and look forward to seeking more of your
excellent post. Also, I have shared your site in my
social networks!

My blog Karol: http://www.pushenbbs.com/home.php?mod=space&uid=509628
Quote
0 #2 uhuyedemegexv 2021-06-05 13:24
http://slkjfdf.net/ - Earazi Aqokule ynm.cnxn.apps2f usion.com.qij.w k http://slkjfdf.net/
Quote
0 #3 ogxexetuweqa 2021-06-05 13:31
http://slkjfdf.net/ - Puralo Autieqiru jfa.mflq.apps2f usion.com.tzd.y a http://slkjfdf.net/
Quote
0 #4 onicugoegbaq 2021-06-06 08:19
http://slkjfdf.net/ - Ajaqiso Izawagi yyb.vupb.apps2f usion.com.dbk.x s http://slkjfdf.net/
Quote
0 #5 udupoxabaxina 2021-06-06 10:45
http://slkjfdf.net/ - Itirom Iohuwaghi rjx.empv.apps2f usion.com.pgy.c g http://slkjfdf.net/
Quote
0 #6 aduqasugajew 2021-06-06 11:02
http://slkjfdf.net/ - Uprpuj Iuhatiqjo app.itsh.apps2f usion.com.kep.z u http://slkjfdf.net/
Quote
0 #7 adiqeuje 2021-06-06 11:26
http://slkjfdf.net/ - Ojiwadu Usaxoluyu ppr.bmtn.apps2f usion.com.jzi.u t http://slkjfdf.net/
Quote
0 #8 upufupobeto 2021-06-06 12:46
http://slkjfdf.net/ - Orurej Oqunlavi ypp.hhnk.apps2f usion.com.cbv.w h http://slkjfdf.net/
Quote
0 #9 evikotenavaz 2021-06-06 14:53
http://slkjfdf.net/ - Asujuyor Udivetot yer.mmsp.apps2f usion.com.ypk.t y http://slkjfdf.net/
Quote
0 #10 uvibuficak 2021-06-09 20:32
http://slkjfdf.net/ - Uipoxed Oyigoof eew.neva.apps2f usion.com.rql.t q http://slkjfdf.net/
Quote
0 #11 odmobefudm 2021-06-09 21:07
http://slkjfdf.net/ - Escayacan Obenas jto.glaa.apps2f usion.com.eaa.l r http://slkjfdf.net/
Quote
0 #12 arudaramip 2021-06-24 12:43
http://slkjfdf.net/ - Aobazel Uwsixa esk.wbls.apps2f usion.com.mmj.e c http://slkjfdf.net/
Quote
0 #13 suharanacu 2021-07-08 04:31
http://slkjfdf.net/ - Tiyomov Ibukox bwt.zndb.apps2f usion.com.nlw.c s http://slkjfdf.net/
Quote
0 #14 stomach flu cure 2021-07-09 19:51
Nice answers in return of this matter with real arguments
and telling all regarding that.

Here is my webpage ... stomach flu cure: https://groovy-directory.com/gosearch.php?q=Push+IV+Hydration+Las+Vegas&search-btn.x=15&search-btn.y=8
Quote
0 #15 Rita Limonnik 2021-12-13 01:01
Since adding Custom LOV, I can't see any Standard LOV...
Is it a Search functionality that limits that?
Thanks,
Rita
Quote
0 #16 AptUV 2022-02-26 12:52
cephalexin
Quote
0 #17 katalog firm 2022-04-14 11:02
I blog frequently and I genuinely appreciate your information. This great article has truly peaked
my interest. I will book mark your website and keep checking for new information about once per week.
I subscribed to your Feed as well.
Quote
0 #18 news 2022-04-20 15:12
Keep this going please, great job!
Quote
0 #19 news 2022-04-24 18:18
Have you ever considered writing an ebook or guest authoring on other websites?
I have a blog based upon on the same information you
discuss and would really like to have you share some stories/informa tion. I know my readers would appreciate your work.
If you're even remotely interested, feel free to shoot me an email.
Quote
0 #20 adult coloring pages 2022-05-06 22:29
Hello there, I found your web site by way of
Google whilst searching for a comparable subject, your web site came up, it seems great.
I have bookmarked it in my google bookmarks.

Hi there, simply became alert to your blog via Google, and located that it's really informative.
I'm gonna watch out for brussels. I'll be grateful should you proceed this in future.
Lots of other folks might be benefited out of your
writing. Cheers!
Quote
0 #21 calendário 2022 2022-05-07 17:19
I was suցgested this blog by my ϲousin. I am not sure whether this post is written by him as nnо one else
know such Ԁetailed about my trⲟuble. Yoߋu are wonderful!
Thanks!

Αlso visit my webpage ... calendário 2022: http://hiro36.s21.xrea.com/montarju4/montarju.cgi
Quote
0 #22 adult coloring pages 2022-05-08 06:56
fantastic points altogether, you simply gained a logo
new reader. What might you recommend in regards to your publish that you
made some days in the past? Any sure?
Quote
0 #23 calendário de agosto 2022-05-08 11:15
Gоod day! Ꭲhis post coulԁ not be written ɑny better!

Reading through this post reminds me of my previous room mate!
He always keрt talking about tһis. I will forward this page to
him. Pretty sure he will havе a good read. Thank yoᥙ for sharing!


Feel free to surf to my blog ... calendário de аgosto: http://games.xwmm.cn/home.php?mod=space&uid=21304&do=profile&from=space
Quote
0 #24 7 ka calendar 2022-05-09 09:29
You're so cool! I don't think I've truly read something like this
before. So great to find somebody with original thoughts on this subject matter.
Really.. thanks for starting this up. This web site
is one thing that is required on the web, someone with a bit of originality!


my web site :: 7 ka calendar: https://forum.mavvo.com.tr/leesa6697-uye.html
Quote
0 #25 private blog network 2022-05-15 08:42
I think that what you posted was very logical.
However, think about this, what if you added a little information? I am not suggesting your
content isn't good, but what if you added a post title that makes
people want more? I mean Creating Custom List of Values Source for Scheduled Jobs is kinda plain. You
might peek at Yahoo's home page and watch how they create news titles to get viewers to click.
You might add a related video or a related pic or two to get
people interested about everything've written. In my
opinion, it could make your website a little bit more interesting.
Quote
0 #26 Printable Calendar 2022-05-24 15:01
Tһank you foг anotһer magnificent article.
Тһe place else may anyone get that кind of info in such an ideal approach οf writing?
I've a presentation next weeк, and I аm at the search fоr sᥙch infօrmation.

Mу web site: Printable Calendar: http://gripco.biz/__media__/js/netsoltrademark.php?d=www.science.org.au%2Fsearch%3Fsearch%3Dhttps%253A%252F%252Ft.me%252Fs%252Fprintable_calendar%26g-recaptcha-response%3D03AGdBq27c6l5HKGhH_ydjSU-IBT8zB7HeIB0EAKe62EVwH-07H4Q8Shtvos5FCrzKR28cg1VL49GLWSQFGxwZuI7qtpbZhKk9affA159OSpv198Hz5E9-HR6qG5QrV2ncc6P_96qPRj1fTjZNv0Sk15Aeucyos7mKOdZscwVlY2xTsa3-SBFpNmzILR8W5V5LcMN-AJu-fQmMOsTa6mCZE-sSjQz7U5KLK5cOr8y-VAx2vmil2EnubC1TMl0CfGIYEhm_rWCyXl6XOOF2keT0OYGDOJfzkSR9ERimcqXjuur1p3NQ6SgXpiKwiIA0lgUT-Ll_4GhamNWG_Om6A4_1yb0xJwb3JIiyK7auO6GgOltpNX8lYr0Qtae3uvALTU9rvUpJn01jijpAx3cIo9SrX9kGcOtlqJpsP52l7DMnublwArL3AbWMgpq5RJSwM0tt0oH0zp1xLdJ98nFNzwZltFFs-JoW0Mk2ToNKqps4_ldl8UFFxm6BHZHBvKThcAIxekxxi1amI-uRDehw0Q824esy4pdpK4LULQ
Quote
0 #27 aid ukraine 2022-06-08 05:47
It's the best time to make some plans for the longer term and it's time to be
happy. I've read this submit and if I could I want to suggest you
some attention-grabb ing things or suggestions.
Perhaps you could write subsequent articles regarding
this article. I desire to read more issues about it! aid ukraine: https://www.aid4ue.org/about/
Quote
0 #28 donate for ukraine 2022-06-08 05:52
I have fun with, result in I found just what I was having a look for.
You've ended my 4 day long hunt! God Bless you man. Have
a great day. Bye donate for
ukraine: https://www.aid4ue.org/about/
Quote
0 #29 aid ukraine 2022-06-08 06:14
I know this web page gives quality depending content and extra stuff, is there any
other web site which provides these kinds of data
in quality? aid ukraine: https://www.aid4ue.org/articles/
Quote
0 #30 aid for ukraine 2022-06-08 06:18
Hey just wanted to give you a quick heads up and let you know a few of the images aren't loading correctly.
I'm not sure why but I think its a linking issue.
I've tried it in two different web browsers and both show the
same outcome. aid for ukraine: https://www.aid4ue.org/articles/
Quote
0 #31 aid for ukraine 2022-06-19 15:34
Excellent blog right here! Additionally your web site lots up very fast!
What host are you the usage of? Can I get your affiliate hyperlink to your host?
I want my site loaded up as fast as yours lol aid
for ukraine: https://www.aid4ue.org/articles/
Quote
0 #32 elogeon 2022-06-21 15:29
Bpnfok Fluconazole No Prescription https://newfasttadalafil.com/ - Cialis Iuyxcy cialis 5 mg son prix Eurilv cheap cialis online canadian pharmacy Kuuahj Xsuynk One of the most commonly used radionuclide substances is technetiumm. https://newfasttadalafil.com/ - buy cialis online Chemotherapy is the first treatment tried with the goal of achieving complete remission.
Quote
0 #33 help refuges 2022-07-02 15:55
Greate pieces. Keep posting such kind of info on your page.

Im really impressed by it.
Hi there, You have done a great job. I'll definitely digg it and
for my part recommend to my friends. I'm confident they'll be benefited from this
website. help refuges: https://www.aid4ue.org/about/
Quote
0 #34 Nikole 2022-07-24 17:37
Good blog post. I absolutely love this site. Thanks!
Quote
0 #35 my blog 2022-07-26 06:49
It's actually very complex in this busy life to listen news on Television, therefore I just use web
for that reason, and obtain the most recent news.
Quote
0 #36 alouxuzon 2022-07-28 14:22
http://slkjfdf.net/ - Osidavx Eqidacap puo.treh.apps2f usion.com.jjf.x h http://slkjfdf.net/
Quote
0 #37 uunavovi 2022-07-28 14:47
http://slkjfdf.net/ - Enuleegfa Unotaxi eww.ejsn.apps2f usion.com.uzm.t x http://slkjfdf.net/
Quote
0 #38 aotuxbefaufl 2022-07-28 22:35
http://slkjfdf.net/ - Gutove Awoddib jgx.gwhy.apps2f usion.com.xxs.i u http://slkjfdf.net/
Quote
0 #39 my blog 2022-07-30 08:33
Howdy just wanted to give you a quick heads up. The words in your article seem to be running off the screen in Ie.
I'm not sure if this is a format issue or something to do with internet browser compatibility but I thought I'd post to let you know.
The layout look great though! Hope you get the issue solved soon. Cheers
Quote
0 #40 flyff 2022-08-05 05:07
I don't know if it's just me or if everybody else encountering
issues with your blog. It looks like some of the text on your posts are running off the screen. Can somebody
else please comment and let me know if this is happening to them as
well? This might be a issue with my browser because I've had this happen before.
Kudos
Quote
0 #41 my blog 2022-08-22 03:31
You really make it seem so easy with your presentation but I find
this matter to be really something which I think I would never understand.
It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!
Quote
0 #42 wp plugins 2022-09-18 10:14
Hello there! Would you mind if I share your blog with my twitter
group? There's a lot of folks that I think would really appreciate
your content. Please let me know. Thanks

wp themes: http://masaht.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com

wordpress plugins: http://idheritage.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #43 wp themes 2022-09-18 23:50
Oh my goodness! Amazing article dude! Thank you, However I am having troubles
with your RSS. I don't understand why I cannot subscribe to it.
Is there anybody getting similar RSS problems? Anybody who knows the answer can you kindly respond?
Thanks!!

wordpress plugins: http://kiaofmentor.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wp plugins: http://createyourownfuturecountry.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
Quote
0 #44 wp themes 2022-09-20 08:16
Hey there would you mind letting me know which webhost you're working
with? I've loaded your blog in 3 completely different
browsers and I must say this blog loads a lot
faster then most. Can you suggest a good internet hosting provider at a fair price?
Kudos, I appreciate it!

wordpress themes: https://www.youtube.com/redirect?q=https%3A%2F%2Fwww.blogexpander.com%2F&gl=MK
wp themes: http://forsythcafe.com/__media__/js/netsoltrademark.php?d=www.blogexpander.com
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

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

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner