Introduction
As most of us might be aware by now that we cannot accommodate custom code (pl/sql program, unix script, java program and other code snippets) in Oracle Cloud (includes HCM,PPM,SCM,ERP) . We may create custom ESS Job for Reports though. As such, it always makes sense to be aware of the list of delivered scheduled processes available in the application. While this kind of information was available in ETRM (Electronic Technical Reference Manual) for EBS the Cloud equivalent OER (Oracle Enterprise Repository) unfortunately does not provides such details but rather mentions to fetch the same from “Manage Custom Enterprise Scheduler Jobs for <specific names>” (for this example lets take “Manage Custom Enterprise Scheduler Jobs for HCM Core Setup and Related Applications”) The problem however is that the specific scheduler jobs does not allows “Blind Search” and so no results are returned (screenshot below)
As such it is a real challenge to get the complete list of ESS (Oracle Enterprise Scheduler Service) Jobs available in system.
An Enhancement Request has already been logged with the product development team BUG 25049339 and it is mentioned that the same is fixed in 11.13.17.09.0
Good that we have details about the version when the same will be available, but until then we need a workaround and creating a BI Report is one.
So lets see how do we create a Custom BI Report to fetch ESS Job Details from the environment.
Creating BI Report to Fetch ESS Job Detail
The most important piece of information for building such a report is to be aware of the Tables which holds such data and also the join. Fortunately for me I got this info from a question raised in “My Oracle Support Community” and the sql query provided is below:
|
SQL Query |
|
select p.code privilege, t.name, t.description, perm.code code, perm.resource_type_name, perm.action from fusion.ASE_PRIVILEGE_B p, fusion.ASE_PERMISSION_B perm, fusion.ASE_PRIVILEGE_TL t where p.privilege_id = perm.privilege_id and p.PRIVILEGE_ID=t.PRIVILEGE_ID and t.language='US' and sysdate between p.effective_start_date and nvl(p.effective_end_date, sysdate) and sysdate between perm.effective_start_date and nvl(perm.effective_end_date, sysdate) and perm.resource_type_name='ESSMetadataResourceType' |
Using this query we will build a Data Model and then prepare a report from the same.
The Report when executed would provide data as below:
One can run this report and get the complete list of ESS Jobs available in any environment at any point of time. So, while we wait for a delivered solution for this I hope this workaround can help us achieve what we need and enable us to get an idea of the delivered Scheduled Processes.
Apps2Fusion Articles 
Comments
I might state. That is the very first time I frequented your website page and thus far?
I amazed wioth the analysis you mare to make this actual post incredible.
Wonderful process!
Feel free to visit my blog post: osrs gp price: https://probemas.com/blog/how-much-is-osrs-gold-worth-today
audio songs current at this web site is actually fabulous.
Havve a look at mmy page - OSRS
quest guide: https://webmobistar.com/most-profitable-osrs-bosses-for-farming-gold/
We are a group of volunteers and starting a new initiative in a community in the
same niche. Your blog provided us valuable information to work on. You have
done a wonderful job!
Also visit my blog post; OSRS quest guide: https://Getassist.net/make-money-playing-mmorpgs/
web site, I truly appreciate your way of blogging.
I aeded it to my bookmark site list and will bee checking back
in the nar future. Take a look at my website as
well and leet me know your opinion.
my blog post; best mmo games: https://getassist.net/make-money-playing-mmorpgs/
Your sit provided us wjth useful information to wolrk on. You've
done ann impressive process and our entire neighborhood can be grateful to you.
my website :: 2007 RuneScape: https://Probemas.com/osrs-max-main-rentals
to protect against hackers? I'm kinda paranoid about losing everything I've worked hard on. Any tips?
My web site: osrs: https://getassist.net/make-money-playing-mmorpgs/
appreciate your techniaue of blogging. I saved as a favorite it to my bookmark webpage list and will be checking backk soon. Take a look at my website as well and let me know your opinion.
My blog post: buy RuneScape membership (Rich: https://probemas.com/buy-runescape-membership)
you should publish more on this topic, it might not be a taboo
subject but typicaly people do noot speak about such issues.
To the next! Best wishes!!
My blog; RS 2007: https://Probemas.com/osrs-max-main-rentals
found this web page as a most excellent web page for most recent updates.
but your sites really nice, keep it up! I'll go ahead and bookmark your website to come back later on. Manyy thanks
The sketch is attractive, your authored material stylish.
nonetheless, you command get bought an impatikence over that you wksh be delivering
the following. unwell unquestionably come furtner formerly agyain since exactly the same
nearly a loot often inside case you shield this increase.
Review my web blog :: buy RuneScape accounts (Hester: https://probemas.com/buy-osrs-account)
your site came up, it appears to be like good. I have bookmarked it in my google bookmarks.
Hi there,just turned into aware of your weblog through Google, and located that it is really informative.
I am going to watch out for brussels. I'll
be gratefl should you proceed this in future. A lot of folks can be benefited out oof your writing.
Cheers!
Also visit my webpage - MMO games (getassist.net: https://getassist.net/make-money-playing-mmorpgs/)
I will bookmark your blog and take a look at again right here frequently.
I'm rather sure I will learn lots off new stuff right here!
Best of luck for tthe next!
I have read this put up and iif I may I want to recommend you some interesting issues or
suggestions. Perhaps you can write subsequent articles
regarding this article. I want to read even more
issues about it!
Here is my wweb blog: Runescape Membership - Https://Probemas.Com: https://probemas.com/buy-runescape-membership,
Feel free to visit my web-site; buy OSRS membership: https://Probemas.com/buy-runescape-membership
through more, thanks for the info!
I'll be sure to bookmark it and return guide to
RuneScape: https://probemas.com/buy-runescape-membership read more of your useful info. Thanks for the post.
I'll certainly return.
that's both educative andd interesting, andd without a doubt,
you've hit thee nail on the head. The problem is something that too few people are speaking intelligently about.
Now i'm very happy I came across this durng my hunt for somethihg regarding this.
Also visit my web-site online games; Donnie: https://getassist.net/make-money-playing-mmorpgs/,
Good day! This is my first visit to your blog! We are a collection of volunteers and starting a new
project in a community in the same niche. Your blog provided us beneficial
information to work on. You have done a wonderful job!
I'm trying to find out if its a problem on my end or if it's the blog.
Any responses would be greatly appreciated. aid
ukraine: https://www.aid4ue.org/about/
this submit used to be great. I do not realize who you might be but certainly you're going to a well-known blogger for those who aren't already.
Cheers!
website. I'm hoping to see the same high-grade content from you later on as well.
In truth, your creative writing abilities has motivated me to get my own blog now ;)
read stuff from. Thank you for posting when you've got the opportunity, Guess I'll
just book mark this web site.
three emails with the same comment. Is there any
way you can remove people from that service? Many thanks!
out loads. I hope to give a contribution &
help different users like its aided me. Good job.
by accident, and I am surprised why this coincidence didn't took place earlier!
I bookmarked it.
And i'm glad reading your article. But should remark on few general things, The website style is wonderful, the articles is really nice :
D. Good job, cheers
Reading through this post reminds me of my good old room mate!
He always kept chatting about this. I will forward this page to him.
Fairly certain he will have a good read. Thank you for sharing!
website in internet explorer, would test this? IE nonetheless is the marketplace leader and a large
component of folks will pass over your magnificent writing because of this problem.
aid for ukraine: http://www.pagespot.com/__media__/js/netsoltrademark.php?d=monoslide.com%2F__media__%2Fjs%2Fnetsoltrademark.php%3Fd%3Dtogelmaster.org aid for ukraine: http://i24news.com/__media__/js/netsoltrademark.php?d=Www.Judyjames.org%2F__media__%2Fjs%2Fnetsoltrademark.php%3Fd%3Ds128.asia%26num%3D999%26
articles I'd state. This is the first time I frequented your web page and to this
point? I surprised with the research you made to make this
actual publish incredible. Great task!
wordpress
plugins: http://maricopaedu.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wp themes: http://www.takhlis.net/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
talents and also with the layout to your weblog.
Is that this a paid theme or did you modify it your self?
Anyway keep up the excellent quality writing,
it's rare to look a nice weblog like this one these days..
wp themes: http://gibwinebar.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
wordpress themes: http://fridaysindiana.com/__media__/js/netsoltrademark.php?d=www.blogexpamder.com
are looking to swap solutions with other folks, please shoot me an e-mail
if interested.
RSS feed for comments to this post