Visual Builder Cloud Service - Web Application Design

Designing Forms in Visual Builder Cloud Service

In this post I will give you an overview of how to design a form in VBCS and make use of the available REST services in Fusion ERP Cloud to view the data.

VBCS can only work with REST services as of now but we can leverage Integration cloud to convert web services into REST services and make them available to VBCS.

The example provided below designs a simple form with a table and connect to ERP Cloud to get the inventory item details.

Create a new application and add the relevant details and click on Finish.

Now click on Service Connections and add the relevant details.

Create a new Service Connection and select the source as Define by Specification

Enter the relevant details and click on next

select the items end point and click on create

Now navigate to Web Applications and create a new Web Application as shown below.

Design the form and add the table component to the form as shown below.

Click on the Add Data property to map the underlying source data for the table. Select the item end point and click on next.

Select the columns which are to be displayed on the form.

Click on Next and associate any query parameters if required. In this example we don't have any query parameters to add so click on Finish.

We can now view the data in the Design View as shown below.

We can also change the column name by editing the headerText tag as shown below.

Click on Run icon to run the application.

The form would be displayed in a new window.

Subscribing to Oracle Fusion ERP Events in OIC

Oracle Integration Cloud enables us to subscribe for the Events in ERP Cloud. In this example I will showcase how you can use item creation event and populate the data into VBCS business objects.

In order to enable ERP Cloud to send across the events to OIC we need to create a csf key as shown below.

Enter the details for enabling the business events notifications from ERP Cloud by configuring the below.

Csf-key – fill in identitydomain and service details

User name – OIC Username

Password – OIC Password

Create a business object in VBCS to store the item data as shown below.

Create an ERP Cloud Adapter in OIC and enter the relevant details

Create a REST Adapter to insert data into the Business Object create in VBCS

Create a new App Driven Orchestration integration

Add the ERP Cloud Adapter and configure it as shown below.

Now add the REST Adapter and configure it as shown below.

The sample json data which I have used is as given below

Json Sample :

{ "id" : 123, "itemNumber" : "abcd", "description" : "abcd", "organizationId" : 2345  }

Now Map the data as shown below.

Validate the mappings and save the changes.

Add the business identifier for tracking’s.

Save the changes and activate the integration.

Now create the item via a web service call in SOAP UI.

In the monitoring dashboard you could see the message being received in OIC.

Now navigate to VBCS and check for the data created.

A form can be designed in VBCS to view this information.

Managing Application Data in VBCS

Overview

Business Objects in Visual Builder Cloud Services enable us to create and store data for the custom objects. The underlying data is exposed to the web / mobile applications via REST API's.

In this article I will give an overview of how to create custom table, access data via REST API's and options available in VBCS to import or export data. Do bear in mind that there is a limitation on the data storage capability in VBCS if you are planning to store large volume of data then i recommend using Database Cloud Service (DBCS).

Creating tables in VBCS

Navigate to Business Objects and Click on + icon at the to

Enter the name for the Business Object and click on the tick icon

Navigate to Fields tab and add the relevant columns to the business object.

I have added couple of columns to this table ( ItemNumber and Description)

Note that the id and the WHO Columns will be added automatically.

Accessing tables in VBCS

I will use the REST endpoint (POST method) to populate the data into the Item Object

Similarly, you can also insert the data by clicking on the Add Row button as shown below.

Exporting / Importing Data inVBCS

Use Export All Data option from Data Manager to export the data objects available with in an application.

A zip file would be generated will the all the business objects data in csv format.

Similarly, you can use import from file to upload all the business objects data into VBCS.

Edit Business Objects Data in Excel

In the new release of VBCS we can also edit the business objects in Excel. Installing this Plugin enables a new menu item on the excel application.

Oracle PaaS Products - Name Changes

Oracle has recently ( Jan-2019) renamed some of the services available under PaaS portfolio.
The details of these changes are as given below.