When attempting to compile with $ORACLE_INSTANCE/bin/frmcmp_batch.sh on AIX 5, 6, or 7 (64-bit), the AIX Forms Compiler fails with FRM-91500 errors. However, compiling with $ORACLE_HOME/bin/frmcmp works when using an X Terminal display such as VNC.
Solution:
Per Oracle Support Article 1085526.1 and Bug 9575535, this is an 11g specific bug with running the compiler on AIX. This issue is relevant for all releases 11.1.1.X – 11.1.2.X.
- Open the Oracle Support Article noted above, and download the fmrcvt220.res file from the link provided in the article.
- Backup and replace $ORACLE_HOME/forms/admin/terminal/fmrcvt220.res with the res file downloaded from Oracle Support.
Once the new res file is deployed, attempt to re-compile.
NOTE: This is not an official patch from Oracle. Oracle states this is simply a workaround until an official patch is released.
NOTE: In addition, make sure that you have the proper environment variables set in your AIX environment. More information on this may be found in the following knowledge base article (it is written for Linux, but the environment variables will work the same for other UNIX environments): https://pitss.com/us/2012/10/08/frm-91500-compiling-oracle-forms-linux/
UPDATE: This issue occurs with the newest patchset of Oracle Forms 11gR2 (11.1.2.1). If this workaround was applied to your Forms 11.1.2.0 environment and the 11.1.2.1 upgrade was applied, you will need to re-apply this workaround.
Source: Oracle Support note 1085526.1
