Oracle Forms & APEX

Upgrade, modernize and add productivity

to your Forms-based legacy system

APEX MasterApp for enterprise deployment

adds ADF-like development frame **freeware**

Forms Value-upgrade

All GUI, look & feel, components are built using Native Forms Components. This secures that your legacy application remains compatible with announced future releases and upgrades from Oracle.

Consenting with the general GUI’s in a Web 2.0 environment and fit for large screens, High Definition – and zoom level set per user.

Further several productivity components are added, mainly in order to improve workflow navigation and the first step towards integration to APEX.

Forms-APEX workflow

Forms-APEX Workflow is a ready made APEX application and library for Forms. The toolset allows Forms based legacy systems to be extended and integrated with APEX – without changing a single line of code. The added value is the seamless integration between the browserless Forms application (FSAL) and the browser-based web application in APEX.

The Forms-APEX Workflow enables Forms application owners to add direct migrated mobile APEX screens as required and to add new value with APEX designs, applying modern client features. The users will enjoy seamless bidirectional workflow over tools (APEX, Forms a.o.), with a minimum of re-implementation, providing benefits fast to the Forms application. The best qualities from the mature Forms system are maintained.

The integration is based on the websocketJSI technology , a new javascript interface that was first released together with Forms R.12.2.1.3. This extends the Forms application with APEX functionality, including navigation, analysis and graphics. Any form can send a raiseEvent to the APEX application with APEX deep-linking, including payload (parameters) from the screen, and thus let APEX act, e.g. for reports, mobile forms etc.

Forms factory

For Forms related projects a shared development resource is setup at the Softbase hosting center. This setup acts as an extension / outsourcing and the customer’s development environment. The simultaneous access to the code – combined with online web meetings – provides agility and efficiency.

SoftBASE APEX MasterAPP is a development concept for APEX, supporting modularity of APEX applications in hierarchical structures.

The APEX MasterApp adds modularity to APEX, allowing new apps to inherit features like authentication, authorization and dynamic navigation. The MasterApp dynamic navigation, defined on modular level (group of applications) provides a seamless linking of APEX application into one app. This enables function-development per application, down to a single page app. Hereby APEX is augmented to fit collaboration and complex app-development – also Forms migration.

For APEX projects, instead of starting from scratch, the MasterApp provides the framework needed for simple and complex application development. The development concept is similar to what is known from ADF projects, i.e building Master Application and sub-applications. It results in low-code fugitive reusable applications, that can meet complex needs. The MasterApp is freeware.

xxxxxxx Intro to video

Development template

… derived from the APEX Application builder with features like; modularisation, authorization for modules (more apps), user administration (all apps), user groups and much more processes with menues and navigation bars. All native in Universal theme. See details

Administration for applications

… users and groups and modules (more application grouped together), dynamic menu definition per module, automatically passing values, behaving like one App. Authorization for users and groups. Dynamic theme per unit, like firm identity or department.  See details

PLPDF print

Create PDF, DOCX and XLSX documents and reports from your Oracle database – with the full PL/SQL support and MS Word template engine.

xxx
Reporting concept
Forms Pure-upgrade

The Pure-upgrade from version 10 / 11 to version 12.2.1.3 is automated and maintain the original source code without any change to the User Interface –  and the users will benefit from:

  • the usage of CLIENTDPI as a runtime parameter
  • option to apply custom color schemes.
  • no JRE, using javaws or FSAL (recommended)

This upgrade is included in our Forms Value-upgrade, with the UI, look & feel modernization. The upgrade from version 6i is partly manual, follows the steps as documented in the manual  ”Upgrading Oracle Forms6i to Oracle Forms 12c”.

Migration of Oracle Report
Development communities

Related to the large User-group organizations, there are active communities for the major tools, like Database, Forms and Reports, APEX etc. We participate here to check trends with colleagues and end-users.

GemGem

GemGem

GemGem

GemGem

GemGem

GemGem

Intro to video

Example:  an ERP-like application requires maintenance for Customers and Products, build it into the application, together with the functionality in which the Customers and Products are used. An example of this is the packaged “Sample Database Application”. The total access (authorization) is maintained within the application. If you need the functionality from another application, you either duplicate it to the other application or you use both applications with no menus between them, or hard link them together, making authorization difficult to handle.

The SoftBASE MasterApp handles this - via a foundation App 20000 and several sub-Apps, all built as a copy of App 1900, which then can be combined and reused in one or more modules. In fact, similarly to how Apps are built in Oracle ADF. Authentication, authorization and navigation is separated from the application itself. The video will demonstrate this, by building 3 new applications, based on the MasterApp, all with pages copied from the “Sample Database Application”