Oracle Fusion Application : Create Custom ESS Job to run BIP Report

In this post I will list the steps required to create a new custom ESS job to be used to run a BIP report which takes a parameter input.

Assuming that you have already created a BIP report, lets begin!

1. Login to Oracle Application Cloud
2. Navigate to Setup & Maintenance
3. In Search Task, search for 'Enterprise Scheduler Jobs for Financial and Supply Chain Management%'

4. Click on the task
5. On the Manage Job Definition Tab you will see a Action icon like below

6. Click on Action and select Create

7. On the Job Definition page above,  fill the details like below:

Display Name: Test ESS Job [a meaningful name]
Name: Test_ESS_Job [Identifier without spaces]
Path: fscmess/testjobs/ [relative folder which will be created under path /oracle/apps/ess/custom/]
Description: Custom ESS Job
Job Application Name: FscmEss
Enable submission from Enterprise Manager: Unchecked
Job Type: BIPJobType
Bursting report: Checked if you have bursting for your report else Unchecked
Class: (Auto populated)
ReportID: /Custom/Samples/Test BIP Report.xdo [path of your report on BI Catalog]
Allow multiple pending submissions: False
Enable submission from Schedule Process: Checked

8. On the parameter tab below click on Actions > Create
9. Enter the details like below

Parameter Prompt: Identifier
Data Type: String
Read Only: Unchecked
Page Element: Text Box
Default value:
Tool Tip:
Required: Checked
Do not Display: Unchecked

10. Save and Close
11. Done

To submit/run this job:

1. Navigate to Schedule Processes > Schedule New Process > Search (Test Ess Job)
2. Select
3. Enter parameter id and submit.
4. Refresh to view the status of the process.
5. Check your report output in process log.



Helpful?? Please comment

Happy Learning!!

SOA 12c : Export/Import ESS job from one environment to another

In the current version of SOA once you create an ESS job we have to use the below process to migrate it to another environment.


For executing the below we will have to use WSLT.

Steps:
1. Login in to your server
2. Navigate to bin: cd $SOA_HOME/common/bin
3. Run : ./wlst.sh

4. Run: connect('weblogic','password','t3://adminserver_hostname:adminserver_port');
This will connect you to the ESSserver.

5. Run: exportMetadata(application='EssNativeHostingApp', server='ess_server1', toLocation='/home/temp/EssDevExport.zip');

6.importMetadata(application='EssNativeHostingApp', server='ess_server1', fromLocation='/home/temp/EssDevExport.zip');

These steps will export the metadata of your ESS jobs and you can then import the same into another environment.

Helpful?? Please Comment.

Happy Learning!!

SOA 12c ESS : Oracle Enterprise Scheduler Service - Creating Job definition & Schedules

Part of SOA Suite 12c, Oracle Enterprise Scheduler is primarily a Java EE application that provides time and schedule based callbacks to other applications to run their jobs.
Oracle Enterprise Scheduler applications define jobs and specify when those jobs need to be executed, and Oracle Enterprise Scheduler gives these applications a callback when that time or when a particular event arrives.

Oracle Scheduler (ESS) is not part of your development activities. It is more considered a runtime configuration. This basically means that at runtime you can decide to create new jobs and apply scheduling configuration.

In this post we will learn how to schedule a web-service using ESS which broadly this requires 3 steps:
1. Create Job Definition
2. Define a Schedule
3. Submit a Job request

We will also learn how to Cancel Job requests.

Lets Start by creating a Job Definition.

1. Take the WSDL URL of your service, SOA(from EM) or OSB(from sbconsole)
2. Login to EM  console
3. In the left-pane, Topology Navigator,  navigate to ESSAPP under Scheduling Services



4. Right click on ESSAPP > Job Metadata > Job Definition

5. Select Create

 

6. On the Create Definition screen, fill the below fields and leave rest as default.

Name: HelloWorldJob
Display Name:  HelloWorldJob
Package: soa [you can leave blank or put soa, osb, etc to logically group your jobs]
Description: HelloWorld Job
Job Type: OnewayWebserviceJobType [you can select the job type based on your WSDL's Message Exchange Pattern; sync, asysnc, oneway]

 

7. Click on the 'Select Web Service..' button
     a. Paste the WSDL URL
     b. Select Web Service Type : SOA [if OSB service you can select Service Bus] 
     c. Click on Go

    



      

d. Select the Service, Port Type, Operation and provide your dummy Input.

e. Click on OK.

All WSDL and payload information is displayed as a set of system properties in the definition like below:




8. Click on OK [top-right corner of page] to create the Job Definition.


Now we will create a Job Schedule and Submit Job Request

1. Navigate to  ESSAPP > Job Requests >Submit Job Request



2.  Click the search icon for Job Definition and select the Job definition created above and click OK.

 


3. On the right-hand select radio 'Specify schedule'

 

4. Click on OK to create schedule and submit Job.

Now we will Search Job Request that we created and scheduled above.

1. Navigate to ESSAPP > Job Requests > Search Job Requests 

 


2. Click on Search. It will list all the job requests.

Note : In the list you will see 2 things:
 a. RequestID with row values n/a - this is the parent job id
 b. RequestIDs with Parent ID as the above - these are the schedule requests

Parent IDs are in wait state until the schedule is complete or cancelled.
Request IDs will be in wait sate till the scheduled execution time, then change to either Succeeded or Error.

3. You can go to the composite Flow Instances, you will see the completed flows.

If you want to Cancel the Job Request, here is what you should do.

1. Navigate to ESSAPP > Job Requests > Search Job Requests
2. Click on Search
3. In the list navigate to the Parent ID (will have n/a for values and WAIT state)
4. Click on the Request ID hyperlink, 
5. Right side of page click on Action and Cancel.
6. On the Search page you will see that the parent and pending jobs are cancelled. 

Helpful? Please Comment.

Happy Learning!!