Get Started

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

Submit ESS Jobs from Visual Builder: Run and monitor ESS jobs directly from VB screens

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:
    Screenshot 2024 05 05 at 23.49.24
  2. Submit Confirm Shipments ESS job through standard UI, get its Job id and analyze the output by Postman:
    Screenshot 2024 05 06 at 0.05.50
  3. Extract the relevant parameters, Job definition name and path and construct submit request like the one below:
    Screenshot 2024 05 06 at 0.12.14
  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:
    Screenshot 2024 05 05 at 23.51.19
  6. Implement Action Chain call to REST endpoint of Job submission
    Screenshot 2024 05 06 at 0.17.12
  7. If needed – use client side timeout and refresh job status
    Screenshot 2024 05 06 at 0.21.00
Table of Contents

Leave a Reply

Your email address will not be published. Required fields are marked *