How to Setup custom form development environment in Oracle Apps

This article explains how to set up custom forms development environment in Oracle Apps.

Oracle Apps use forms, OAF and ADF tools to design user interface. The look and feel are the same across all the forms, OAF pages to have consistent across Oracle Apps. Your custom form should also follow the same standards so that it does not look alien when registered with Oracle Apps.

Setup forms development environment

Oracle Apps provides a starting point as TEMPLATE.fmb and APPSTAND.fmb module.

APPSTAND.fmb:- collection of standard objects like triggers, canvas, windows, blocks, LOV.

TEMPLATE.fmb:-  sample block, canvas, window, libraries. This form inherits objects properties from APPSTAND.fmb.

This inheritance is important here, if while developing any custom form if it breaks your form behavior would change. Each child form checks these dependencies in $AU_TOP/forms/US and $AU_TOP/resource/US. There is an equivalent path in windows env forms_path. All parent objects should be there in form_path.

1. find forms_path

Below are the steps to find forms_path in Windows.

Navigate to Start–>Run and type regedit to open the registry editor. Click on Edit –> Find. Enter FORMS_PATH in the text box. Click Find Next button.

It is C:\DevSuiteHome_1\forms. All dependent objects should be under this path.

find forms_path on Windows

 

2. Copy TEMPLATE.fmb, APPSTAND.fmb and PLL

Download TEMPLATE.fmb, APPSTAND.fmb from $AU_TOP/forms/US path and common standard PLL mentioned below from the $AU_TOP/resource path. You can use any FTP client like WinSCP or Filezilla. Copy all these files to your development environment form the path shown above paragraph, in this case, C:\DevSuiteHome_1\forms.

List of Libraries (PLL),

  1. APPCORE.pll
  2. VERT.pll
  3. GLOBE.pll
  4. JA.pll
  5. JE.pll
  6. JL.pll
  7. CUSTOM.pll
  8. FNDSQF.pll
  9. APPDAYPK.pll
  10. APPFLDR.pll
  11. FV.pll
  12. HRKPI.pll
  13. GHR.pll
  14. GMS.pll
  15. IGILUTIL.pll
  16. IGILUTIL2.pll
  17. PSAC.pll
  18. PQH_GEN.pll
  19. PSA.pll
  20. PSB.pll
  21. OPM.pll
  22. APPCORE2.pll
  23. VERT1.pll
  24. VERT2.pll
  25. VERT3.pll
  26. VERT4.pll
  27. VERT5.pll
  28. IGI_CBC.pll
  29. IGI_CC.pll
  30. IGI_CIS.pll
  31. IGI_DOS.pll
  32. IGI_EXP.pll
  33. IGI_IAC.pll
  34. IGI_MHC.pll
  35. IGI_SIA.pll
  36. IGI_STP.pll
  37. FNDMOAC

3. Open TEMPLATE.fmb file

Now, launch form builder and TEMPLATE.fmb. The form should open without any error and you should see all files attached to the forms. This should work, but sometimes you may get FRM-10102 error, as form builder could not attach required libraries.

FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved.

FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved

In this case, you need to attach libraries individually as shown below.

4. Attach PLL to Template.fmb

Below are the steps to attach pll to Template.fmb.

Note:- Do not save TEMPLATE.fmb file till the time all files are attached and you do not get FRM-10102 error, else library attachment will be lost.

Launch form builder and open TEMPLATE.fmb file. Click Ok when you get error popup as shown below.

FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved

You will get an error like missing libraries. Click each library and attach it to the forms builder one by one. There is a minimum of 36 libraries you need to attach.

Select the Attached Libraries node and click on + symbol. This opens Attach Libray pop up where you can browse and select the file.

browse and select the pll file

Click the Attach button. You may get error APPCORE.pll contains a non-portable directory specification. Remove path?

Click the Yes button.

attache library

Form builder tries to attach the library. But you may get additional pll error if there is any dependency. So you need to attach that library first and then the original one.

PDE-PLI018 Could not find library FNDSQF

PDE-PLI018 Could not find library FNDSQF

File get attached to the TEMPLATE.fmb form.

PLL Library attached to TEMPLATE.fmb

Summary

We explained how to attach PLL libraries to TEMPLATE.fmb form to set forms development environment.