HOW TO COMPILE ORACLE FORMS IN 11i AND R12

Firstly,

  • uncompiled Oracle forms files extension is .fmb
  • compiled Oracle forms files extension is .fmx

Different scripts used for 11i and r12.

Oracle E-Business Suite 11i

  • f60gen module=$AU_TOP/forms/US/formName.fmb userid=apps/appsPwd output_file=$applicationBasePath/forms/US/formName.fmx

Oracle E-Business Suite r12

  • frmcmp_batch module=$AU_TOP/forms/US/formName.fmb userid=apps/appsPwdoutput_file=$applicationBasePath/forms/US/formName.fmx module_type=form batch=NO compile_all=special

You can use the following query to find applicationbasepath:

1
2
3
4
 SELECT fa.basepath
  FROM fnd_application fa, fnd_application_tl fat
 WHERE     fa.application_id = fat.application_id
       AND fat.application_name = :Application_Name;

Default Oracle Forms Path:

  • $AU_TOP/forms/US/