Wednesday 7 February 2018

How to Create Job Set/ Concurrent Request Set in Oracle Fusion


How to Create Job Set/ Concurrent Request Set in Oracle Fusion



Hi Friends, in this post I will create Concurrent Request Set in Oracle Fusion but in Fusion this is called Job Set. In Fusion Concurrent Request Set Replaced with Job Set. I will discuss in detail about How to Create Job Set/ Concurrent Request Set in Oracle Fusion

Step 1:- First Identify the ESS jobs for Which you want to create the Job Set.

Step2:- This example will create a job set which will run two jobs:
How to Create Job Set/ Concurrent Request Set in Oracle Fusion


 Step3:- Run these ESS jobs independently in Schedules processes to get some values needed to configure JOB Set.

EXT_PortletContainerWebModule parameter is specifies the name of the web module for the Oracle Enterprise Scheduler UI application to use as a portlet for the parameters when submitting a job request. This parameter need to be the same for all the jobs that are part of the job set.

select REQUESTID, VALUE
from FUSION.ESS_REQUEST_PROPERTY
where requestid in (4484123,4484224)
and name='EXT_PortletContainerWebModule'


Step4:- Additional Runtime Parameters like Application we also need to configure the job set. We will get the application from this below query.

select REQUESTID, APPLICATION, DEFINITION
from FUSION.ESS_REQUEST_HISTORY
where requestid in (4484123,4484224)

Step5:- Create Job Set

Navigate to the product specific task. In this example "Manage Custom Enterprise Scheduler Jobs "
Click on Manage Job Sets tab.

How to Create Job Set/ Concurrent Request Set in Oracle Fusion

Step6: - Enter the new job set details.
Choose Serial or Parallel depending on how the jobs need to run.

Press on the Add Job Set Step button to add the first job details.



How to Create Job Set/ Concurrent Request Set in Oracle Fusion

Step7:- Search for first Job.Select the First ESS job
Give a name for Step ID.
 
How to Create Job Set/ Concurrent Request Set in Oracle Fusion



How to Create Job Set/ Concurrent Request Set in Oracle Fusion


Step8:- Press again on the Add Job Set Step button to add the second job details

How to Create Job Set/ Concurrent Request Set in Oracle Fusion


if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

Step9:- The diagram will look like this:


Step10:- Notice in the job set Application Defined Properties two  values are already added: srsFlag with value Y and EXT_PortletContainerWebModule with Financial Common


Step11:-  Under the System Properties add the SYS_effectiveApplication as the value of the application identified in the Step 4 SQL above in this post. In this case EarFcmEss





Step12:- Save the Job Set

Run the Created Job set As below:-

Navigate to Scheduled Processes
Choose Type Job Set
Search for the job set created

If you Want to Learn Oracle Fusion , Please Follow the Oracle Fusion Tutorial

How to Create Job Set/ Concurrent Request Set in Oracle Fusion

3 comments:

Unknown said...

Really Nice stuff.!
Can you please let us know, In case of serial step first job from job set got error out or completed with warning still I want to execute next job's. How.?

Rohit said...

Hi , In case if You want to run the Second Job when first job will be error or warning then you need to change the configurations. refer step 10 in this post , Where I have selected 'Stop' for error and Warning. you can change the value from Stop to any other value to make this Job set continue running

Anonymous said...

Please please please help:::::::::::::::::::::::::::::

I changed the EXT_PortletContainerWebModule to a wrong value by mistake, It makes the jobset not visible in Manage Job Sets tab. Is there any way to see it? It looks like it needs the right value to make the job set shown on the UI, but how to change it to the right value without seeing it in the list? Is it possible to change it through sql in database table? Or is there any other tricks?
THanks a lot for the help.

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *