Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part One: Connect Visual Builder to Fusion SaaS API Service Catalog


Visual Builder Cloud Service (aka VBCS), one of the 3 legs of Oracle Integration Cloud (aka OIC), is a low code development environment that is one of the main mechanisms for extending Oracle Fusion SaaS Apps.

In this episode we are connecting VBCS to a SaaS instance, so we can get the different endpoints provided and then use it in the application.

What you need is:

  • a user with access to OIC instance
  • same user with access to SaaS instance

Step 1: Create a new VBCS app

OIC -> Visual Builder
Click [New] on the top right
Select SaaS Template
Provide values and click [Finish]

Step 2: Configure

Go to hamburger menu on top right and select [Settings]
Click on [Services] tab and provide the info

The url to provide has the following format: https://instancefqdm/helpPortalApi/otherResources/latest/interfaceCatalogs

where instancefqdm is your SaaS instance such as https://<id>-<env&gt;.fa.<datacenter>.oraclecloud.com

Click on [Test] button

Step 3: Import the catalog

Click on [Service Connections] icon on the left
Click on [+ Service Connection]
Click on [Select from Catalog]
Click on [FA Services]
Click on one depending on the functional area you want to work with
Wait for the endpoints to appear, expand and select endpoints desired
When you are done click on [Create] on right down corner
Click on [Endpoints] tab and find your endpoints in there

Step 4: Use an endpoint for listing Contacts in a table

Click on [Web Applications] icon on the left, expand flows, expand main, select main-start, locate Table in the Components panel and drag and drop onto the view or onto the Page Structure panel. Click on [Add Data] on the right
Select Contacts and click [Next]
Select or drag&drop fields in the Columns panel. Select the Primary Key and click [Next]
Leave things as it is for now and click [Finish]
Click the “play” button up right
And here it is, you have your contacts page created

And that’s all folks for now, hope it helps! 🙂

One Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.