UNIX Fonts and Oracle Report server: a never ending nightmare
One of the more frustating experience you can have when migrating to Oracle Forms 10g is the fonts problem.
In Oracle Forms 6i, users are generally standardized on Windows and in this way, they have access to the usual fonts such as Arial, Times Roman, Courrier and Courrier New. When printing reports, either direct or through [...]
Oracle Forms 10g BI Bean
Some of our modules made use of Oracle graphics in the 6i version (C/S). We spent some time thinking about installing Graphics on 10g but eventually we opted for the BI bean instead. Why ? very simple because you can easily duplicate what you have in 6i with very nice features from the BI bean.
There [...]
A migration dashboard with Forms JavaBeans
In order to follow the migration efforts from 6i to 10g, I quickly put together a dashboard that shows the four states : migration-testing-correction-acceptance for the modules in our application.
On the left side, we can click on the buttons to show the global stats, stats per analysts, stat per application and the modules that are [...]
WebUtil to the rescue: how to maintain client-side functionalities.
Now that we have crossed the midway phase in our conversion phase, we started the evaluation of all the client side functionalities we used to have in our application. Fortunately, in Forms 10g, webutil comes already pre-installed.
Read Full Post | Make a Comment ( 2 so far )Why you need to worry about NLS_DATE_FORMAT !
One of those things that can irritate you for more than you can care of: the mix up in dates. That’s an old story for those dealing with the Oracle Db but in our case, that was something that bothered us for more than a week before we found out that we were missing the [...]
Read Full Post | Make a Comment ( 3 so far )Oracle Forms to Oracle APEX migration
Last week, one of our senior DBAs made a comment regarding our current migration. Essentially, he was referring to Oracle APEX (formerly HTML-DB) and whether we looked at Forms to APEX conversion.
Management decided a while ago that we will be migrating to Oracle Forms 10g given that the in-house expertise is mostly Oracle Forms.
Why you need a bugtracking system during an oracle Forms migration.
Any software under development should have at least two essential systems, namely a source control system and a bugtacking system.
When we planned our migration, we did include a source control based on subversion but a bugtracking system was really not thought of. While we planned on using MouliForms as our migration tool, we did not [...]
Oracle reports 10g – local printing problems
In the course of adapting our reports and submission forms to 10g, some of our users asked for a specific request. In version 6 of our application, users can either request a screen preview or print directly to the local printer.
In 10g, the local feature is lost because the processing is now done in the [...]
Week2 – Migrating a mission-critical Oracle Forms 6 application
Here we are at the end of the second week in the migration of a mission-critical Oracle Forms 6 application. The main points we dealt with are:
AIX file transfert and compile processes
LOV visual appearance (differences between 6 and 10g)
Report rdf structure search in a batch mode from a keyword-based file
Day 5 of the Forms migration
One of our developers raised the question about finding specific strings within our Reports. For example, we might have to check whether a query has schema name used in building up the query. That can be a problem if we need to move the tables to another container (this will break the query since the [...]
Read Full Post | Make a Comment ( None so far )
