Migrate Application from ADF to VBCS

Migrate Application from ADF to VBCS

In the last couple of years, customers and partners want to use JavaScript based UI development, and want tools used by Oracle to maintain the business continuity and UI. Oracle released JET to help customers, especially if they are working on the Oracle platform and looking to leverage things like the Oracle Alta UI, Oracle Redwood UI or REST services exposed from Oracle SaaS applications.

Oracle SaaS Application

In this context, one of our customers started moving Oracle ADF applications and functionalities to the all new VBCS.

Below are some of the challenges we faced while migrating the ADF applications to VBCS:

Development of Pagination for Tables

As traditional pagination looks simplified and easy to navigate, customers have preferred it over the new load To Scroll tables and for this Oracle has reintroduced the Paginated Tables, yet aren’t fully supported and rebuilt in OJET. Our customer was looking for the same and this could be archived by creating Pagination Data provider on Array Data Provider, using sample code:

Sample code

Exposing database

Oracle REST Data Services is a Java Enterprise Edition (Java EE), or a middle tier like OIC can also be used for data extraction and handling. But ORDS provides enhanced security, file caching features, and support to Restful Web Service. ORDS has a feature of Auto REST and PLSQL Gateway, as security and data privacy are concerns in the digital world. It is best to expose SQL queries via PLSQL than enabling the whole database table via Auto REST for use in the application.


The SQL queries are written inside the handler block, which is linked to a particular template and a module with the schema of Database.

Schema of database

In the above example, there are four parts:

  1. SQL Query (SELECT * FROM emp)
  2. Template: Employees
  3. Module: rest
  4. Schema:’USERTEST1′

And similarly, other CRUD Operations can also be defined for use in Applications.

Migration of applications

While migrating ADF applications from development environment to production, there is only movement of tables, view query, sequences etc. For movement ORDS REST, Objects needs to be extracted and recompiled into the production environment.

Performance tips

OJET Data provides collections, but ADP and SDP are most prominently supported by objects e.g.,tables, list etc.

performance tips

As per the above table, the data provider types can be used as per requirement and none are taken for ADF as an LOV as directly linked to the component via SQL.

Read Files via JavaScript

Bulk loading of data is often required by the business e.g., Bulk Hiring, Bulk Transfers of employee between department or entities etc.

VBCS (OJET) is client facing so bulk uploading can be processed in Back End API or in client browser. There are advantages as well as disadvantage of it.

Advantages of Using JavaScript:

  1. The status of data can be seen shown before data is inserted into DB for further processing.
  2. Parsing of Data by JavaScript is fast as compared by Backend API
  3. If Data status is errored, they can be can easily removed and reuploaded.
  4. UI is more modern and reflect present HTML standards


  1. Dataset greater than 1000 rows can take more time to process than traditional ADF Application and should be broken down into smaller sets of 200 or 500 for quick turnaround.

When creating application on VBCS, the business must have a long term outlook. This will greatly help the design and usage of the application. For more details on creating and enhancing VBCS applications, connect with us.

Leave a Reply

Retype the CAPTCHA code from the image
Change the CAPTCHA codeSpeak the CAPTCHA code

SOAIS - Worksoft Newsletter

To view on your browser, click here
Facebook Twitter LinkedIn
Dear Default Value,

Welcome to SOAIS Newsletter of September 2021!

Continuous Testing with Remote Execution
The speed of innovation continues to increase, driving rapid and relentless change for today’s ever-evolving IT landscapes, creating greater risk as IT and business teams scramble to ensure timely delivery. How can your organization keep pace? Test more, worry less. With Worksoft’s Connective Automation Platform, you can easily build and maintain automated tests, accelerating testing time without losing scope or volume. You can schedule and execute remote, continuous tests to intercept defects sooner and prioritize remediation - without sacrificing your nights and weekends. Explore how continuous test automation and remote execution can empower your organization.

Click here to connect with us to get more information on our services.

Skip Costly Rework with Dynamic Change Resiliency​

Change resiliency is imperative in ever-evolving IT environments. Our patented object action framework streamlines change management by assigning object definitions to your shared assets. The same object may be used in a thousand automation steps, but it can be easily updated by making one simple change to the model definition. The change automatically propagates to every single instance where that object may have been used without a single line of code or manual human involvement. For more change readiness you can also engage our Impact Analysis for SAP to predict how changes in SAP transports will affect your business processes. 

Please click here to watch the video to get a gist.

SOAIS Blog – Nuts and bolts of Certify Database Maintenance​

One of the key thing, which is often missed by the organizations, who have invested in using Worksoft Certify for automating their Business Process Validation initiatives, is implementing a Database Maintenance Plan. While the business and the test automation consultants get excited about the shiny new thing that they have got and start building the regression suite; planning and executing a database maintenance plan for most of the customers gets pushed down the priority list. However, since all the test assets in Certify are stored in a Database, a robust database maintenance plan is very important to maintain smooth operation of Certify with acceptable performance criteria. The customers usually start facing issues once they have built significant number of Certify processes which they have started executing on regular basis. Such executions add a lot of data to the tables storing results data and increase the overall size of the Certify database.

Please click here to read the complete blog.

Worksoft Blog – Process Intelligence: A Multi-Dimensional Approach

The ability to extract process knowledge has become easier through the years. Technology has evolved to the point where we can deploy capabilities that connect at multiple levels to extract different types of process insight. In the past, organizations were forced to spend enormous energy extracting data manually from different applications and databases. Then, they would have to use things like spreadsheets to transform the data and convert it into meaningful information. 

Please click here and read the complete blog.
Unit 9, Level 5, Navigator, ITPL,
Bangalore - 560 066.
Phone: +91 80 40071234
Suite 101, 1979, N Mill St,
Naperville, IL 60563
Phone 1-800-262-2427
Please click here to Unsubscribe / Unsubscribe Preferences

Leave us your info