In this post, we will see how to Call ESS Job from OIC. Many of the first-time OIC developers have difficulty in understanding the Fusion ESS Job technical details and using it in Oracle integration Cloud especially when there are multiple parameters.
ESS job is a program is oracle fusion which works like a concurrent program of EBS. These programs can be run in the background and can be called from the external applications via web services with proper authentication.
Before we do anything we need to have the details of the ESS job , to get the ESS job details you need to do the following.
Let’s find out the details for example the ESS job Upload Customers, which is executed when a Customer is imported from the fusion FBDI process. The ESS job which gets triggered in the background is ‘Upload Customers’.
click on Edit Job Definition to find Job Name, Path, and other details. These values are required to be passed when calling ESS Job.
Once you have the details of the ESS Job with parameters we need to Call ESS Job from OIC.
Fusion provides ERP Integration Service to do the needful.
The ERP Integration service can be called from directly from SOAP WSDL or via ERP Adapter.
The operation you need to use to execute the ESS job is submitESSJobRequest
Note that the parameter list is coming only once, you will need to add the paramList element as many times as there are the number of arguments in the ESS job parameter.
So to call ESS Job Upload customers it would be something like this
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"> <soapenv:Header/> <soapenv:Body> <typ:submitESSJobRequest> <typ:jobPackageName>/oracle/apps/ess/financials/receivables/customerSetup/customerProfileClasses/</typ:jobPackageName> <typ:jobDefinitionName>UploadCustomerEss</typ:jobDefinitionName> <!--Zero or more repetitions:--> <typ:paramList>WPS101</typ:paramList> <typ:paramList>2727272</typ:paramList> <typ:paramList>#NULL</typ:paramList> <typ:paramList>CREATE</typ:paramList> </typ:submitESSJobRequest> </soapenv:Body> </soapenv:Envelope>
You can create a soap connection with the external report service wsdl which can be further used the the OIC process to call the ESS job.
Next, you would need to map the ESS job call with valid parameters.
When Calling the ESS job in OIC you will need to click on Repeat Node to add the number of parameters as in ESS Job
Hope this is useful and has the required details of calling an ESS job with multiple parameters in OIC.
The other important feature is to get the request id back of a submitted request, I will cover this in a separate post.
In case you need to decide which one to choose from ERP Adapter or direct SOAP WSDL do check out the post on SOAP vs Rest APIs.
The same pattern can be used to call an FBDI process. (see an example of lockbox integration)
Thanks for reading.
MOS Note Using External Data Integration Services for Oracle ERP Cloud (Doc ID 2102800.1)
We have detected that you are using extensions to block ads. This website runs on Ad revenue to manage the server hosting costs. Please help us by removing the ad blocker extension from your browser or use another browser that does not have Blockers.
Optionally if you have the option to whitelist https://wpsbutton.com in your blocker extension, please do.