How To Call ESS Job from OIC [Call FBDI Process]

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.

  • Login with admin user , go to Functional Setup Manager
  • Search Task Manage Enterprise Scheduler Job %
  • Select the Job for FIN / SCM / HCM as needed
  • Edit
  • Tab Parameters
manage-ESS-job-fsm

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’.

FSM-manage-ESS-job

click on Edit Job Definition to find Job Name, Path, and other details. These values are required to be passed when calling ESS Job.

ess-job-details
  • Click on Tab UploadCustomerESS; Parameters to see the arguments of the ESS Job. In this example we see we have 4 parameters Batch Name, Data File, Batch Id, Attribute4. These need to be passed in this order to the ESS job call via ERP integration Service to make it run successfully.
ess-job-parameters

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.

ERP integration Service to Call ESS Job from OIC

The ERP Integration service can be called from directly from SOAP WSDL or via ERP Adapter.

ERP integration Service SOAP WSDL

https://(FADOMAIN)/finFunShared/FinancialUtilService?WSDL

For BIP Report
https://(FADomain)/xmlpserver/services/ExternalReportWSSService?wsdl

Operation submitESSJobRequest

The operation you need to use to execute the ESS job is submitESSJobRequest

submit-ess-job-payload

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.

ESS job Parameters & Sample Payload

So to call ESS Job Upload customers it would be something like this

submit-ess-job-parameters-payload
<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>
Note the WSDL format of the ExternalReportWSService
https://(FADomain)/xmlpserver/services/ExternalReportWSSService?wsdl

SOAP Connection

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.

ess-job-soap-connection

Next, you would need to map the ESS job call with valid parameters.

call-ess-job-from-oic

ESS Job parameters in OIC

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

ess-job-parameters-oic

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.

References :

MOS Note Using External Data Integration Services for Oracle ERP Cloud (Doc ID 2102800.1)

FAQs

wpsadmin
2 Comments
  1. In The article above you said
    The other important feature is to get the request id back of a submitted request, I will cover this in a separate post.
    Where is the separate post?

  2. Hi David,
    Use the rest API to submit the ESS job and capture the request id in the response
    https://docs.oracle.com/en/cloud/saas/financials/22b/farfa/op-erpintegrations-post.html

Leave a reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO
Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart