Oracle Forms & APEX

Gateway to the future with readymade tools

for your Forms-based legacy system

APEX MasterApp for enterprise deployment

and templates for new “Reports”, like PLPDF

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. With 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. Further any Forms screen, can interact bidirectional with webpages, like Google maps, document handling, calendar, email.

All without code change and based on native Oracle components. Implementation at a fix cost pr. Form and an update service is available.

Forms & APEX Factory

Lately we have had deliveries of integrations, upgrades and modernizations from our Forms & APEX Factory without any on-site consulting – all handled via a shared development resource setup at the Oracle cloud (or Softbase hosting center). This setup acts as an extension of the customer’s development environment. The simultaneous access to the code – combined with SKYPE-meetings – provides agility and efficiency.

Due to clear documented procedures, this works even long distance, latest customer resides in Bangkok.

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 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)

The upgrade from version 6i is partly manual, follows the steps as documented in the manual  ”Upgrading Oracle Forms6i to Oracle Forms 12c”.

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.

Reporting concept

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”