Tagged SAAS EXTENSION

Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part Three: Filtering Data


Next step after what we posted here is how to implement a mechanism to filter results. Taking a look to the REST APIs we can notice that the query parameter q is the one that can help us to implement what we are pretending:

So the q parameter works as a field1<operator1>value1;fieldn<operatorn>valuen expression that can be passed as a parameter to the REST service. Let’s hands on.

Create a global variable for the search criteria:

Drag and drop an InputText onto the Page Structure pane:

Create a new Event for storing in a variable the value of the InputText when it changes:

Drag and drop a Button same way:

Create new Event and implement action chain:

In the success branch of the Rest call put a Call Component Method and select the refresh method of the table object:

In the failure branch put a Fire Notification Error and configure it as follows:

Hope it helps! 🙂

Oracle SaaS Stories: Creating a Custom App Extension with Visual Builder | Part Two: Results Pagination


In this episode we are explaining how to list data results in a table located on a page. This is the typical use case in which we want to show business data to the user according to certain criteria. For now what we want to demonstrate is how to show results in paginated mode. The good thing here is that we are not writing any line of code at all.

SaaS REST API Structure and Taxonomy

Most of the new REST APIs of Fusion SaaS have the same structure, for example in the HCM package we found:

For now we are focusing in the offset and limit parameters.

An example querying Transfer Orders

Let’s create a page that retrieves all transfer orders. First, we need to locate the service in the catalog. See here for more details.

This API retrieves all transfer orders

Create a new project in VB and then drag and drop a table in the page and click Add Data assistant:

Create a couple of global variables at application level adn set the default value for rowspertable as 10:

Select the TransferOrders endpoint and click [Next]:

Select columns to show and the table primary key:

Map the global variables to the endpoint parameters and click [Finish]:

For now we have the results in the table:

Drag and drop an InputNumber on to the Page Structure pane, above the table and set the min value to 0:

Add Assign Variables action to the Action Chain:

Add Navigate action as well:

Click on Assign Variables action and then on Assing link:

Map the value variable in the action chain to the application variable offset and click on [Save]:

Click the Navigate action and then de [Select Target] button:

Select Peer Page:

Select the page where the table is located:

We are almost done, click on the Play button:

Click on the InputNumber up and down and see how the table shows data in pages as the inputnumber changes:

So that’s all for now, in the next episode we’ll see how to filter results in the table.

Hope it helps! 🙂

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! 🙂