Friday, August 1, 2008

Using Forms Builders with Oracle Applications Release 12

First, source the Oracle Applications generated OracleAS 10.1.2 environment file. The environment file will be located under the 10.1.2 subdirectory of the Release 12 instance home. For example, assuming Release 12 is installed under /slot01/appmgr, and the instance name is "txk123", source the following file:

/slot01/appmgr/inst/apps/txk123/ora/10.1.2/txk123.env

 

The above could also be written as $ORACLE_CONFIG_HOME/txk123.env, or $INST_TOP/ora/10.1.2/txk123.env. You can look up $ORACLE_CONFIG_HOME in the Help->About Window of a Release 12 Forms session if you are not sure of the underlying directory structure. The Forms Help->About Window displays settings for the OracleAS 10.1.2 Oracle home.

 

Second, modify the environment variable FORMS_PATH, so the referenced forms can be found. Referenced forms are only required by the builder and compiler. The compiler merges in everything it needs from the referenced form when it generates the .fmx, so the referenced forms are not used at runtime; this is the reason they are not in the default FORMS_PATH.

FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

export FORMS_PATH

 

This assumes you are working with the US English version of the form. For other languages, add the appropriate language subdirectory to FORMS_PATH in place of US. The referenced objects will then be in the correct language.

 

Launch the builder by running the following command:

frmbld.sh &

 

You must use the frmbld.sh script, under $ORACLE_HOME/bin. Do not run the executable standalone. After sourcing the 10.1.2 environment file, $ORACLE_HOME should be set to ~/apps/tech_st/10.1.2, and $ORACLE_HOME/bin should be included in $PATH.

No comments: