Tag Archives: Oracle Forms migration

Embedding Oracle Forms in your QAFE Application (Part 1)


Using our Oracle Forms Conversion tool, it is possible to convert your forms application to a QAFE web application. In some cases you might want to consider integrating your existing Oracle Forms application with your QAFE web application for a more gradual conversion process.

I assume your Oracle Forms application has been configured so it can be exposed through a Java applet. Documentation on deploying your Oracle Forms application as a Java applet is supplied by Oracle[1] and is only available to applications using Oracle Forms 11g or higher.

Communication between Oracle Forms and the QAFE application is done through JavaScript. In order to establish JavaScript communications between both applications, some additional configuration of your Oracle Forms and QAFE application is required.

This blog explains how to accomplish one-way communication, from your QAFE application to your Oracle Forms.

In a following blog, we will elaborate on two-way communication between your applications.

Setting up your Oracle Forms Application
Before your Oracle Forms application allows JavaScript calls, a new Oracle Form level trigger has to be made available, namely the WHEN-CUSTOM-JAVASCRIPT-EVENT trigger. Note that only one is allowed to be defined per Oracle Form.

The trigger PL/SQL logic, which handles incoming JavaScript calls can look similar to this:

In this case we define an event with the name “my-application-event” which, when raised, will set the value of BLOCK1.ITEM1 to the passed eventValue.

Observe the :system.javascript_event_name and :system.javascript_event_value system variables. The :system.javascript_event_name system variable can be used to differentiate between incoming events raised from JavaScript. Event related data is passed from JavaScript via the :system.javascript_event_value system variable. Data passed from JavaScript to Oracle Forms is passed as a single String, if multiple values need to be passed you could consider separating them using a semicolon or using JSON, then parsing this in your PL/SQL logic.

Modify your Oracle Forms application’s formsweb.cfg configuration file to include the following properties:

The applet_name property will decide the applet’s HTML id attribute of the embedded applet in the HTML output.

The enableJavascriptEvent property configures the Oracle Forms Service for JavaScript binding, allowing JavaScript events to be called to and from the Form.

Setting up your QAFE Application
After configuring your Oracle Forms application, you still have to configure your QAFE application in order to embed the Oracle Forms application, and then call the now exposed JavaScript functions.

To embed the Oracle Forms application, use the frame component in your QAFE application’s panel definition:

The source oracle-forms-applet.html contains your embedded Oracle Forms applet (note: this is an example, your HTML code might vary depending on your application setup. Specific Oracle Form related arguments and path variables have been masked):

Calling Oracle Forms events using JavaScript
Now that we have an Oracle Forms application embedded in QAFE, we want to be able to raise events within the Oracle Form. This can be done through the now exposed raiseEvent JavaScript method:

The raiseEvent JavaScript function is made available by the embedded Oracle Form, if JavaScript handling is enabled as explained earlier.

The first argument of this function is the event name corresponding with the event name defined in the WHEN-CUSTOM-JAVASCRIPT-EVENT trigger code.

The second argument is the payload string containing the string formatted argument(s).

It is recommended to wrap the raiseEvent method in a custom defined method, defining that in a separate JavaScript file (e.g. oracleforms.js) and including it in the head section of <qafe-application-root>/webapp/QAFEGWTWeb.jsp file:

Now, when defining your events in your QAFE application’s QAML code you can use the call-script built-in to call either the raiseEvent method directly, or your custom defined method:

If the steps above were succesfully executed, you should now be able to manipulate the embedded Oracle Forms application from your QAFE web application.


Oracle Forms 12c and beyond

On Tuesday March 24 2015, Michael Ferrante of Oracle presented the roadmap of Oracle Forms 12c and beyond in a webinar organized by AuraPlayer. Although his talk was protected by a “Safe Harbour” statement, some interesting topics were mentioned. Of course, it’s always possible that not all of these features will be included in the final release.

Current and future support
The first subject was “Current and Future Support”. Extended support for the current version 11g R2 is expected to end in 2017. The release date of Oracle Forms 12c is still to be determined, but Oracle is aiming for a 2015 release. 12c will be supported for at least 5 years after release, meaning at least until 2020.

Some time was spent on explaining features in the current version (11g R2) of Oracle Forms. This included the use of styling in the application, integration with other applications using Javascript and helpful functionality to modify triggers. This functionality includes splitting the trigger code and opening multiple PL/SQL editors. Splitting the code can be achieved by dragging the button next to the scroll bars as highlighted in red within the image below. Other PL/SQL editors can be opened by using the Shift-key and double-clicking on the image next to the trigger name.


Finally, the new features that were presented included:

  • Improved Single sign-on Integration
    A user only needs to login once with the login session being used across multiple applications. This means that the Forms application can be more easily integrated into a heterogeneous environment.
  • Browserless mode
    A browser is not required anymore. Oracle Forms can use its own browser to avoid any browser incompatibility issues.
  • Integration of Forms2XML
    Before, the Forms2XML application was available as a stand-alone command line application. In 12c, it will be integrated in the Forms builder.
  • Improved usability of the Forms Builder
    The user is able to drag and resize items within the canvas with increased flexibility.

As mentioned above, the Oracle Forms 12c release date is as of yet unkown. Oracle will publish the webinar online in the near future.

QAFE at #oow14 – Day 3

It’s a wrap! Our third and final day at the Oracle OpenWorld exhibition grounds is over. A very busy day again with non-stop demo’s all morning. We’d like to thank everyone who took time to meet us.

If you want to know more about QAFE, you can join our webcast at October 6th,

  • Oracle Forms to HTML5 – 1pm (GMT+2)
  • Oracle Forms to ADF – 1:30pm (GMT+2)

QAFE at #oow14 – Day 2

Day 2 of the exhibition has passed at Oracle OpenWorld. Again, it was great to meet – and talk to – a lot of you. Impressions of the day below.

— QAFE (@QAFE) September 30, 2014


If you were not able to meet up with us yet, stop by tomorrow!

QAFE Forms Conversion release 1.7

We’ve just released QAFE Forms Conversion version 1.7.

This update contains stability improvements and bugfixes. We’re also introducing some exciting new features in this release. Below is the list with the most important changes.

  • Unique id’s for all code
  • Auto overflow implementation from block definition
  • Endless scrolling default in datagrids (same as Oracle Forms)
  • Full implementation of LOV’s: no manual coding required
  • Graphics handling
  • Code reduction in the output code
  • Automated Script output for Master Detail
  • Graphics Text processing also included
  • Handling of Viewport information
  • More detailed information in conversion summary
  • Better layout with less code

We plan to release more often. We have some features planned for our next release which reduce the time needed for possible manual work after conversion.

This release is available now and can be used with the QAML Builder. Download and install the software from here.

For any questions or remarks, don’t hesitate to contact our support team  at and stay tuned for our next update!

QAFE 2013… Gearing up for 2014

The end of a truly dynamic year is near.

This was a year of growth, learning and worldwide exposure for QAFE.

Oracle OpenWorld confirmed that people are still looking for ways to solve their Oracle Forms issues, which allowed us to showcase QAFE in about 80 demos in just 3 days. And we determined a new solution direction for customers that follow an Oracle and ADF strategy.

Meantime our workforce doubled in size, we had more revenue than expected; I had not imagined that QAFE would grow to be so big, so quickly!

Looking forward to 2014. It will be a year of further expansion, searching for new partners and future proofing even more customers by delivering the best solutions.

I want to thank you all for your support and I can’t wait to see what 2014 brings.


Have a great year!

Rokesh Jankie

Oracle Forms Modernization at Oracle OpenWorld

QAFE will be at Oracle OpenWorld in two weeks to showcase Oracle Forms Modernization, QAFE style.

Forget investing heavily to modernize your Oracle Forms. QAFE features an automated migration process that guides you through the process, while doing the work for you.

Would you like to see QAFE do that live? Come and meet us at Oracle OpenWorld! Fill out this form so we are able to keep in touch. We look forward to meeting you in person!

Breaking news -> QAFE release 2.2, get it today!

As of today QAFE Platform 2.2 is available for download! The new release provides a number of new and enhanced features for an even greater productivity boost. And, best of all: we integrated QAFE Forms for Oracle Forms modernization into this particular release.

Why is this breaking news?

It is the *first time* in the history of Oracle Forms that a modernization Proof of Concept will not cost you 20, 30 or 40K. Our brand new wizard will do the job for you, free of charge.

So here’s your chance: download the new version. Simply upload a form and see what happens!

Go to for instant access to a free PoC!

How QAFE helps Oracle Developers to enter the world of Modern Web Applications!

As mentioned in this article, Oracle is not giving up on PL/SQL.

“PL/SQL is absolutely not going to go away. It’s critical technology in so many parts of the Oracle technology stack. And even if it weren’t, there are literally millions of lines of PL/SQL code out there that have been running in mission-critical applications for decades. So, I think that everybody should be quite confident that PL/SQL is not only going to stick around, but it will be enhanced. The PL/SQL team is still working hard at making it the best possible database programming language.”


Most developers love having all the logic in *one* programming language. Java or .NET (or other languages, but I’m focussing on the mainstream for Enterprises). As a result many applications perform poorly, because it doesn’t make sense to get the information from the datasource first and then start filtering in memory. The memory usage on the server side becomes huge, especially if millions of users are to use your application.

In QAFE we like to think best of breed: use the best technology for the correct purpose. As the Oracle database is here to stay, we have to use the power of that technology to the fullest. That is why QAFE works seamlessly with PL/SQL, allowing PL/SQL developers to be more productive and reuse his/her skills. While offering an easy transition to Java and SOA, in order to write Web2.0 applications and integrate with other databases and Java logic in a transparent way.

P.S. Good to see that Oracle is also implementing new features like Function Result Cache, a much needed feature in Enterprise Applications (QAFE already implemented this for all databases of course).

P.P.S. Would you like to know more about modernizing Oracle Forms with QAFE? Simply fill out this form and we will contact you.

How QAFE complies with Gartners recommendations for Oracle Forms Modernization and Migration

Recently Gartner published this recommendation for Oracle Forms Modernization and Migration. Key Findings and Recommendations learn that Application Development organizations should:

1. Update to a supported version to gain advantages in centralized management and deployment.

2. Modernize and integrate SOA and other middleware best practices and infrastructures (specifically Oracle’s Fusion Middleware stack and Java development tools).

3. Migrate next-generation development projects to industry-dominant technologies (for example, Java, Microsoft .NET and open-source software) to align with industry best practices in the future.

With QAFE you effectively tackle the second and third recommendation. QAFE not only supports a Service Oriented Architecture, it offers great tools to get an instant overview of your Architecture. On top of which – point 3 – QAFE is industry-dominant in more than one way: it helps you to go cloud on basically any given platform, while being able to render applications to any given web technology.

This makes QAFE an instantly deployable, future-proof platform for your entire Enterprise Applications Development roadmap. With Oracle Forms, to quote Gartner’s bottom line “as a supporting player, bridging the gap between older deployed systems that need to integrate and interoperate with newer platforms and application architectures”.

To address Gartner’s first recommendation in closing: Update to a supported version to gain advantages in centralized management and deployment. In our demo center in The Netherlands we have QAFE running on an Oracle Exalogic Elastic Cloud, integrated with Oracle WebCenter, Oracle Policy Automation and Oracle NoSQL: proving that QAFE and Oracle are what Oracle calls ‘Engineered to work together’.

So whether you you decide to move ahead with Oracle in centralized management, or you prefer to reinvigorate Oracle Forms on an other platform, QAFE has got your back. Call us anytime for a demonstration, +31 70 319 5000, or use this contact form for more information on Oracle Forms Modernization via email.