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/

HOW TO ACTIVATE THE WHO COLUMNS FOR ORACLE FORMS ?

First, You need to create who columns on the table.
You can use this script to do following.

1
2
3
4
5
 ALTER TABLE table_name ADD creation_date DATE;
 ALTER TABLE table_name ADD created_by NUMBER (15);
 ALTER TABLE table_name ADD last_update_date DATE;
 ALTER TABLE table_name ADD last_updated_by NUMBER (15);
 ALTER TABLE table_name ADD last_update_login NUMBER (15);

After, activate the who columns for a oracle forms you need to do following.
1) You have to call an following API in PRE_INSERT and PRE_UPDATE triggers.

1
 fnd_standard.set_who();

2) Compile and try again.