Enable Forms 6i short keys in Forms 10g and Forms 11g

Shortcuts in Forms 10g and 11g are different from Forms 6i keys. For example, Forms 6i uses F10 as short key to save records while in Forms 10g and 11g, CTRL+S is default short key to save or commit changes. If you have migrated an app from older version then probably you would be looking some way to retain key shortcuts. Continue reading “Enable Forms 6i short keys in Forms 10g and Forms 11g”

Create Oracle lite Database (odb) using olite Mobile Development Kit

Oracle Database Lite (olite) is small-scale database for small devices. Oracle Lite can be used in following two design patterns,

  1. You can configure olite database to Mobile client and use automatic synchronization feature of olite server to replicate data between mobile device and oracle database server.
  2. You can use an independent olite database with you mobile application.

Whatever way is used, the data in the mobile is stored in small mobile database files with ODB and OBS extension. ODB file contains data while indexes are stored in OBS file. In olite version 10.2.0.1.0, all objects are stored in ODB file. Continue reading “Create Oracle lite Database (odb) using olite Mobile Development Kit”

FireFox, IE crash with Forms 10g, Replace Jinitiator with JRE

Oracle Jinitiator is no longer compatible with oracle forms services. By default, Oracle Forms services 10g uses Jinitiator 1.3.1.22 to run Forms applications. Jinitiator was compatible with Internet Explorer 6 and Firefox version 2.0. Continue reading “FireFox, IE crash with Forms 10g, Replace Jinitiator with JRE”

Sequence number for Primary key in oracle ADF, JDeveloper

If you have created an Entity object with a primary key field. The question is, how you will generate maximum serial no for primary key filed and where the logic will be placed? There are two methods to do this, using row level database trigger or using application level logic to obtain sequence no for primary key. Continue reading “Sequence number for Primary key in oracle ADF, JDeveloper”

Using transient Attribute with “Derived from SQL Expression” in JDeveloper 11g

Transient attribute can be used to calculate a value based on SQL expression. This may be very helpful, for example, you can use a transient attribute in “SCOTT.EMP” Entity object definition to get name of the department for all employees. Continue reading “Using transient Attribute with “Derived from SQL Expression” in JDeveloper 11g”

Oracle Application Development Framework (ADF) and Oracle Forms Developers

I want to share my first impression of ADF and I am sure everyone with Oracle Forms background will feel same. I have been working in oracle Forms and Reports for more than five years. I have development experience in Oracle Developer 6i/9i/10g and Forms, Reports 11g. After reading Oracle’s Statement of Direction for Forms and reports, I decided to learn ADF for web-based application development. Continue reading “Oracle Application Development Framework (ADF) and Oracle Forms Developers”

Minimizing Forms 11g Application’s First Time Startup overhead

When client accesses Forms application for the first time, java run-time classes bundled in JAR files are downloaded to client JRE cache. These files include frmall.jar, frmwebutil.jar and jacob.jar. Cumulative size of these files is more than 2mb. Continue reading “Minimizing Forms 11g Application’s First Time Startup overhead”

Key Mapping in Oracle Forms 10g and Forms 11g | Shortcut keys

Key mapping or key binding defines how an application should respond when mapped key is typed. Usually application executes some function in repose. For example in Forms 6i, when user types F9, List of value is displayed to the user. It means that key F9 is mapped to function “List of Values”. Continue reading “Key Mapping in Oracle Forms 10g and Forms 11g | Shortcut keys”

Hide username and password while calling oracle Reports

If you have not configured reports with Oracle Single Sign-on, Oracle report server explicitly requires username and password when report is called using Web.Show_document(). Username and password is required in report calling URL, for example following method calls a reports using Web.Show_Documnet(). Continue reading “Hide username and password while calling oracle Reports”