Visual Builder Extension for Fusion SaaS: submit ESS jobs directly from Visual Builder

General

Oracle Visual Builder Studio allows us to extend existing Visual Builder screens or create new App UIs.
The automatically provisioned backends allow convenient access to Oracle Fusion REST resources but submitting and monitoring ESS jobs is not a straightforward task.
This post will show how ESS job submissions can be easily achieved in Visual Builder Studio.

Use Case

Submit a standard Ship Confirm ESS job for a given shipment.

High Level Implementation Details

1. Create a custom backend to access ESS rest APIs described here https://docs.oracle.com/en/cloud/saas/applications-common/24b/farca/op-ess-rest-scheduler-v1-requests-get.html.
2. Submit ESS job manually from Fusion to get a valid ESS Job Id
3. Use Postman to extract ESS Job details
4. Prepare a Postman version of ESS Job submission and verify of works as expected inside Fusion
5. By using the sample requests and responses received in Postman create service connections for query and job submissions
6. Implement the call to Submit a new job request in Javascript Action Chain
7. Optionally implement request polling and monitoring

Detailed Implementation Details

1. Create an ESS backend for your extension:
   
2. Submit Confirm Shipments ESS job through standard UI, get its Job id and analyze the output by Postman:
   
3. Extract the relevant parameters, Job definition name and path and construct submit request like the one below:
   
4. Verify the ESS jobs works as expected
5. Create backend service connection with query and submit endpoints from https://docs.oracle.com/en/cloud/saas/applications-common/24b/farca/op-ess-rest-scheduler-v1-requests-get.html:
   
6. Implement Action Chain call to REST endpoint of Job submission
   
7. If needed – use client side timeout and refresh job status