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 integration is based on the websocketJSI , 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 development

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.

The APEX MasterApp adds modularity (grouping of Apps), allowing new Apps to inherit features like authorization, navigation and 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.

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”