Friday, January 2, 2009

FORMS GENERATION

FORMS GENERATION
goal: How to Regenerate a Form, Library or Menu
fact: Oracle Forms
fact: Oracle Application Object Library

fix:
Oracle Forms executable used to generate forms depends of platform andOracle Applications versions :
Unix Windows 95 Windows NT

10.7SC N/A f45gen.exe f45gen32.exe
10.7NCA f45gen N/A f45gen32.exe
11.0.x f45gen N/A f45gen32.exe
11.5.x f60gen N/A f60gen.exe
Commande line is :
module= userid=APPS/output_file= module_type=form batch=yes compile_all=special
Examples :
f45gen32.exe module=APXINWKB.fmb userid=apps/apps output_file=APXINWKB.fmxmodule_type=form batch=yes compile_all=special


/TEST/testora/8.0.6/bin/f60genmodule=/TEST/testappl/au/11.5.0/forms/F/ARXTWMAI.fmb userid=APPS/APPSoutput_file=/TEST/testappl/ar/11.5.0/forms/F/ARXTWMAI.fmxmodule_type=form batch=yes compile_all=special

Notes :1. If you have to generate many forms in Oracle Applications you can runadadmin, menu 'Maintain Applications Files' => 'Generate form files'.2. You could also run Forms Designer to generate a particular form, you needto be connected to the database and must verify that you have access to dependentmodules where objects may be referenced.3. If you have
errors like:

FRM-10054: Cannot attach library ...FRM-10083: Cannot Open ...FRM-18108: Failed to load the following objects...

check FORMS45_PATH or FORMS60_PATH variable, it must contain at leastresource paths where reside libraries (*.pll, *.plx files) and directorieswhere reside form source files (*.fmb).
GENERATION OF LIBRARY
Same executables used to generate forms but command line changes :
apps/module_type =library compile_all=special
Examples :
f45gen ARXTWMAI.pll apps/apps module_type =library compile_all=special

GENERATION OF MENU
It is unusual to generate a forms menu as there is only one in OracleApplications and few patches bring new version.

Syntax is:
module= userid=apps/output_file= module_type=menu batch=yes compile_all=special

Example:
f60gen module=FNDMENU.mmb userid=APPS/APPS output_file=FNDMENU.mmxmodule_type=menu batch=yes compile_all=special


goal: How to manually generate an 11.5 form on Unix - f60gen
fact: Generic Unix
fact: Oracle Application Object Library 11.5

fix:
1. Add $AU_TOP/resource to the FORMS60_PATH: $ FORMS60_PATH=$AU_TOP/resource;$FORMS60_PATH$ export FORMS60_PATH
2. Issue the following from the command prompt:
$ <8.0.6>/bin/f60gen \ module=$AU_TOP/forms//form name.fmb \ userid=APPS/ \ output_file=/forms//form name.fmx \ module_type=form \ batch=yes \ compile_all=special

2 comments:

Unknown said...
This comment has been removed by the author.
Unknown said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.