This section explains the architecture of Applaud Products and how they integrate into your existing Oracle E-Business Suite environment.
A mobile user typically uses either Applaud's native app or a customer packaged version of the same app. A desktop user typically accesses Oracle E-Business Suite in the normal way and then accesses our app via a Menu Function on a Responsibility.
Both the mobile and desktop apps use a service-oriented architecture: once the UI code is initially downloaded to the client most server-side data is retrieved via REST APIs. The REST APIs are hosted on the Oracle E-Business Suite server (oacore - OA_HTML/applaud/api/*) and implemented using Java Servlets.
The REST APIs are HATEOS and discoverable. They use JSON as the data interchange format for fast mobile access. The JSON API standard (jsonapi.org) is used extensively.
All REST APIs are stored in a REST catalog that sits in a custom schema (typically XXAS) on the Oracle E-Business Suite database. This allows REST APIs to be added, changed, or removed dynamically without the need to restart any servers. The REST framework is largely implemented in PL/SQL, although it’s similar to Java Jersey in design (https://jersey.java.net).
Each REST API runs a SQL statement to retrieve data or runs an anonymous PL/SQL block to change data. Anonymous PL/SQL blocks typically call a wrapper PL/SQL procedure or function that then calls Oracle published APIs.