Friday Jun 27, 2014

Partner Webcast – Modernizing Oracle Forms for the Cloud era

Oracle Forms is one of the most widely used tools for building applications for the Oracle database.  Many organizations still run enterprise Oracle Forms applications created in the 90s, leading in thousands of customers successfully running their core business systems on Oracle Forms technology. They now wonder about the future of their application.

While Forms has been used widely, there has been no simple way to take your existing Forms into the cloud era to address requirements such as mobile, mobile applications and integration.  Oracle provides a roadmap to modernize applications based on Oracle Forms technology by providing an incremental approach for developers who need to extend their business platform to Java

[Read More]

Tuesday Feb 25, 2014

WebLogic Suite: Foundation Infrastructure for Oracle iAS (Internet App Server) Implementations

What's New for Oracle WebLogic Server

WebLogic has become the strategic application server infrastructure for Oracle Fusion Middleware and Applications.

It is designed to provide a standards-based, mission critical and secure platform for organizations developing and deploying large-scale, cloud environments.

Oracle iAS capabilities like Oracle TopLink and Oracle Coherence along with layered products such as Oracle Forms, Oracle Reports, Oracle Discoverer and Oracle Portal and others have been certified with the WebLogic Server infrastructure.

The J2EE runtime underlying Oracle Internet Application Server, Oracle Containers for J2EE (OC4J) has had key capabilities converged and certified with WebLogic Server. The goal has been to enable Oracle customer investments in Oracle Internet Application Server to move forward seamlessly.

[Read More]

Sunday Dec 01, 2013

Partner Webcast – Oracle Forms Modernization Practices - 12 Dec 2013

Oracle Forms & Reports, a component of Oracle Fusion Middleware, is Oracle's long-established technology to design and build enterprise applications quickly and efficiently. It has proved to be extremely successful, both among third party ISVs as well as at Oracle itself – Oracle’s E-Business Suite is an example. Although this technology is now 20 years old, Oracle remains committed to the development of Forms and Reports, and to the ongoing release as components of the Oracle Fusion Middleware platform. This continuing commitment to Forms technology enables you to leverage your existing investment by easily upgrading and integrating existing Oracle Forms applications to take advantage of the latest web technologies like ADF, Service Oriented Architecture (SOA), Business Process Management (BPM) and others. 

Many organizations run enterprise Oracle Forms applications created in the 90s. If you’ve done investments in Oracle Forms and you are looking for a way to modernize your solution you should be aware of the modernization strategies that exist for your Oracle Forms applications.

[Read More]

Friday Mar 08, 2013

Another dynamic form in ADF

I have been recently helping one of Oracle Partners in migrating their Forms application to the ADF technology. It was a retail store solution and one of the main requirements was to provide quick and automatic way to scan and enter the items at the cashier desk. The bar code scanner is a relatively simple device and can be treated simply as an additional keyboard attached to the cashier’s computer. To automate entering consequential items at the desk we need to have a web page with a form which is able to dynamically create new rows (for new items) detecting some kind of key sequence e.g. enter. This way the cashier does not have to even touch the keyboard to repetively add new items to current transaction.

I have created a simple demo application based on the famous HR schema where the roles of the transaction items play the rows in the REGIONS table – this is just for sake of simplicity to reproduce it without creating additional schemas or tables.

[Read More]

Tuesday Apr 03, 2012

Partner Webcast - Upgrade Oracle Forms to 11g version

Oracle Forms, a component of Oracle Fusion Middleware, is Oracle's long-established technology to design and build enterprise applications quickly and efficiently. The latest Oracle Forms release is 11g, and it’s the only release supported right now. During this webinar we are going to explore the architecture and the new features of Oracle Forms 11g, describe the steps required to upgrade from the previous Oracle Forms releases.  If you’re still on Forms 10g or earlier you should not miss a chance to join this webinar. 

[Read More]

Thursday Nov 24, 2011

Forms&Reports upgrade characterset issues


This quick post is based on my findings during recent IMC workshops, especially those related to upgrading the Forms 6i/9i/10g applications to Forms 11g platform. The upgrade process itself is pretty straightforward and it basically requires recompiling your Forms application with a latest version of frmcmp tool. For some cases though, especially when you migrate from Forms 6i which is a client-server architecture to a 3-tier web solution (Forms 11g), you need to rewrite some parts of your code to make it run on new platform. The things you need to change range from reimplementing (using webutil library) typical client-site functionality like local IO operation, access to WinAPI, invoking DLLs etc. to changing deprecated or obsolete APIs like RUN_PRODUCT to RUN_REPORT_OBJECT. To automate those changes Oracle provides complete Java API  which allows you to manipulate the code and structure of you modules (JDAPI). To make it even easier we can use Forms Migration Assistant tool (written in Java using JDAPI) which is able to replace all occurrences of old API entries with their 11g equivalents or warn you when the replacement is not possible. You can also add your own replacement definitions in the file. But you need to be aware of some issues that can be encountered using this tool.
First of all if you are using some hard-coded text inside your triggers you may notice that after processing them by the Migration Assistant tool the national characters may be lost. This is due to the fact that you need to explicitly tell Java application (which MA really is) what kind of characterset it should use to read those text properly. In order to do that just add to a script calling MA the following line: 


when the particular encoding must match the NLS_LANG in your Forms Builder environment (for example for Polish characterset you need to use ISO-8859-2).

Second issue you can encounter related to national charactersets is lack of national symbols in you reports after migration. This can be solved by adding appropriate NLS_LANG entry in your reports environment. Sometimes instead of particular characterset you see "Greek characters" in your reports. This is just default font used by reports engine instead of the one defined in your report. To solve it you must copy fonts definitions from your old environment (e.g. Forms 10g installation) to appropriate directory in new installation (usually AFM folder). For more information about this and other issues please refer to

at My Oracle Support site.

That's all for today, stay tuned for more posts on this topic!



Oracle ECEMEA Partner Hubs
Migration Center Team

We share our skills to maximize your revenue!
Adopt and implement the latest of Oracle Technology in your solutions.

Stay Connected
Google+ Subscribe


« October 2015