How to Compile custom Oracle forms (fmb) and libraries(PLL) using frmcmp

This article explains how compile custom forms (fmb), libraries(pll) using frmcmp utility in Oracle Apps. 

frmcmp_batch

frmcmp_batch or frmcmp_batch.sh is a UNIX level utility to compile custom form(.fmb) and libraries(.pll) in Oracle Apps R12.

Syntax

frmcmp_batch Module= Userid=<userid/password> [Parameters]

Optional parameters are (default values given):

Steps to compile custom form (.fmb)

  1. Open Putty and login to Oracle Applications UNIX server( apps tier).
  2. sftp custom form(.fmb) file from a source location to $AU_TOP/forms/US. You can also move it to the respective custom top like $XXINV_TOP/forms/US, if you do not have access to $AU_TOP.
  3. Set FORMS_PATH as shown below.
FORMS_PATH=$FORMS_PATH:$AU_TOP/forms/US

Note: – Above step is applicable only when you are compiling form on respective custom top.

  1. Run below command to compile form
frmcmp_batch custom_form.fmb apps/$apps_password

This starts the compilation of the form and log messages are displayed on the terminal. This command informs you at the end of *.fmx is created or not.

If you get an error like bad bind variable ‘parameter.G_query_find’ then that means you are compiling on custom top and not set the forms_path variable.

Steps to compile PLL(CUSTOM.pll)

  1. Open Putty and login to Oracle Applications UNIX server( apps tier).
  2. sftp custom.pll file from a source location to $AU_TOP/resource/US.
  3. Run below command to compile form
frmcmp_batch custom.pll fmb apps/$apps_password module_type=LIBRARY

Summary

We have covered how to use frmcmp_batch command to compile form and pll lirbray. I hope you found this useful. Please share and subscribe.