How to Create Service Connection from Cloud Fusion API in VBCS

Introduction: –

While building applications in Oracle Visual Builder Cloud Service (VBCS), one of the common requirements is to fetch real-time data from Oracle Cloud Fusion applications (like HCM, Finance, SCM, etc.).

Developers often face difficulties in configuring a service connection between VBCS and Fusion due to authentication errors, improper endpoints, or missing setup steps. This blog provides a step-by-step solution to resolve these integration issues.

Why we need to do : –

Oracle Fusion provides powerful REST APIs, but integrating them into VBCS requires careful setup. Some common challenges include:

  • Not having the correct REST endpoint structure.
  • Missing required headers or authentication details (like Basic Auth or OAuth).
  • Fusion environments requiring specific roles or privileges for REST access.
  • Confusion over when to use Catalog URL vs Resource URL.
  • JSON response structure not being parsed correctly in VBCS due to metadata issues.

How do we solve: These issues delay development and impact integration efficiency between VBCS and Fusion.

Below are the steps to create a successful service connection :

Step 1 : Open VBCS application and navigate to the service connection menu.

Step 2 :Choose Define by Endpoint.

The screen will like this:

Step 3:Copy the cloud fusion URL from your cloud fusion login.

Step 4: Get the REST API Endpoint.
Example:

  • HCM: /hcmRestApi/resources/latest/workers
  • Finance: /fscmRestApi/resources/latest/receivablesInvoices
  • (depending on the module, like HCM or Financials)

Paste both the URL and API endpoint like this.

Step 5: Give a name to the server connection created.

  • Navigate to the Page where you want to display the data.
  • Click on the Page Name to open the Page Designer.

Add a table component:

In the Design view, drag and drop a Table component from the Component Palette to the page.

Step 6: Bind the Table to Service Connection Data.

  1. Click on the Table → Data tab on  the right-side properties panel.
  2. Under Data → Add Data Provider, click “Add Variable or Data”.

 

Step 7: Click “Service Connections”. Select all the columns and click finish.

Output:

Recent Posts