HOW TO GET A CALENDER IN DATE FIELD IN ORACLE FORMS?

  1. Set the LOV of the item for which calendar to be attached as ENABLE_LIST_LAMP LOV, which  is included in the TEMPLATE form.
  2. Set Validate from List to ‘No’  in the property palette of that item.

    forms_date

  3. Then in KEY-LISTVAL trigger of that item  write
    calendar.show;

    form_builder_calender_show

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:

 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/