Tag: form builder
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.
Recent Comments