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
Application Screenshot
Similarly we need to create one more List of value for Absence Plan Name
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.
Comments
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
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
Is it a Search functionality that limits that?
Thanks,
Rita
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.
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.
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!
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
new reader. What might you recommend in regards to your publish that you
made some days in the past? Any sure?
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
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
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.
Тһ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
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/
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/
other web site which provides these kinds of data
in quality? aid ukraine: https://www.aid4ue.org/articles/
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/
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/
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/
for that reason, and obtain the most recent news.
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
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
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!
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
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
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
RSS feed for comments to this post