Oracle PaaS: Using the SaaS Worker API

Business Transactions are primary for an organization and Integrating multiple applications can help in decreasing load on ERP and increased business activity for an organization.

One of our customers had a requirement to transfer employees between Departments seamlessly and make sure the required business validations are triggered.Due to limitation in SaaS,our customers’ business validation could not be well implemented within the SaaS assignment transaction rules.

For achieving the same, our PAAS team has built a Web Application through which following the business rules were validated and a transfer transaction was created:

  1. Department manager must be auto populated for the Employee along with Department.
  2. Department must be validated against the Business Unit.

The transfer transaction for an employee is then handled in Oracle Integration Cloud via App Driven Orchestration (RESTful Service)which is invoked Ad-Hoc by PAAS.

In App Driven Orchestration (RESTful Service) of OIC, following rules were implemented:


  1. Department and Department manager

SaaS API’s Used for Transactions

  1. Employee API
  2. Worker API

Employee SaaS API was used for transfer transactions, but it cannot be used when an employee is having a resignation row as assignment is terminated with a specified date.

For employees having resignation row transfer transaction could only be achieved by Worker SaaS API, and it involved the following calls:

  1. Add ManagerSaaS API
  2. Add Assignment details
  3. Add Assignment Flex Fields Details


And additionally,we need Looping through each work relationship for fetching employees’ active work relationship in Worker SaaS API. The transfer transaction done in one call of Employee SaaS API could only be done in three calls of Worker SaaS API and this led to an increase in transaction time for a request.

The transaction time when using Worker API was brought down by following methods:

  1. Using Hexadecimal code from Employee’s SaaS API.
  2. Effective use of parameters and headers while calling URLs to add manager, assignment details and assignment Flex Fields Details.

Real-time integration of any third-party applications with Oracle cloud is getting more focused in the market and is helpful in organization’s growth as it enables unified application architecture.

To know more about integrating external/On-premise applications to ERP, contact us.

Leave a Reply

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