Oracle Forms 10g BI Bean

0

Posted by Hafed | Posted in Forms, oracle | Posted on 20-09-2008

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 might be a slight learning curve here but it really boils down to reading the instructions that come with the BI bean and some testing. That’s all.

Note: make sure you set your classpath to the folder where you have your JARs.

A migration dashboard with Forms JavaBeans

4

Posted by Hafed | Posted in Forms, oracle | Posted on 20-09-2008

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 problematic.

Oracle forms migration dashboard

The gauge is a Javabean that I put together following an example I found on the OTN network. There are a number of properties that can be set on this javabean. I really did not spend that much time on the graphics part of the gauge but eventually I will have to do it since our application itself might include some versions of this gauge in the future.

Oracle forms PJC - gauge

There is also a timer (invisible on this canvas) that I borrowed from the Oracle foms 10g demos. The timer is set to 20 min and a custom event trigger is set to query a table that holds the module’s names and their states.