Integrating Oracle Forms with REST Services

Using or calling REST from Oracle Forms allows the application developer to access data from sources other than an Oracle database. To get started using REST with Forms, you will need to first understand the REST API(s) you plan to use.

In modern applications, data is often gathered from various resources in order to present a singular representation of that data. For Forms, the ability to access data through a REST service call offers the ability to obtain lightweight data quickly and easily. It also provides a way to access data from third-party services with minimal effort.

When registering with a REST service, the REST service typically asks for two pieces of information:

  • The type of client or application. Oracle Forms runs as a confidential client in a web application.
  • The redirect URI. This is the listener servlet URL such as https://example.com:9443/forms/lservlet. The port number—in this example, 9443—should specify a port that accesses WebLogic directly (without going through Oracle HTTP Server) even when REST services will be accessed in SSO mode.

Once this information is provided, the REST service provides REST server URL(s) and various authorization tokens that may be required when accessing REST service operations. The authorization tokens, and potentially REST server URLs, need to be stored as credentials in Oracle Platform Security Services [OPSS].