Skip to content
Home / Apps / 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.

FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved error tells you that Form Builder is not able to attach the concerned library (XXX) when you open the TEMPLATE.fmb Form in Oracle Apps or forms_path is incorrect or missing.

Where XXX library could be any of these standard libraries mentioned below,

  • APPCORE, APPDAYPK, GLOBE, FNDSQF
  • JA, JE, JL, VERT, GHR, PQH_GEN,PSAC
  • CUSTOM, OPM,
  • VERT1, VERT2, VERT3, VERT4, VERT5

TEMPLATE.fmb is a master form created by Oracle which you take before creating the custom form. It has all dependent objects like block, windows, and PLL which have common functionally required to make form works in Oracle Apps Environment.

When you open the TEMPLATE.fmb file in the form builder, it checks for all dependent objects in the path mentioned in the FORMS_PATH variable. On Windows, it is C:\DevSuiteHome_1\forms\ for Developer suite 10G and C:\Oracle\Middleware\Oracle_FRHome1\forms\ for 11G developer suite.

Solution FRM-10102: Cannot attach PL/SQL library APPCORE.

  1. Copy respective PLL to FORMS_PATH
  2. Open TEMPLATE.fmb form
  3. This error should not come now.

If you still get the error then manually attach the file as below

  1. Select the attached libraries node and click on + sign on the right-hand side toolbar
  2. This opens the browser windows. Search the respective file and click on Attach
  3. Remove the hard path.
  4. The library gets attached and should be visible under the same node
  5. Do not save the form
  6. Close the form and open it again.

The error should get resolved for that PLL. You may get the error for other libraries if you are opening TEMPLATE.fmb the first time in the form builder. In this case, follow the above procedure and attach each library. Note, that you should not save the form till the time all errors are resolved.

Still getting this issue which means your forms_path is not set properly.

Follow the below steps to set the forms_path variable,

  1. Open system property
  2. Add variable forms_path
  3. Enter the path where you copied the PLL
  4. Click to restart the System
  5. Now open the form, the error should not come.

Summary

We have shown you how to resolve the FRM-10102 error. I hope you found it useful.

Please share and subscribe.

Reference – Form Builder Errors On Startup FRM-10102: Cannot attach PL/SQL library APPCORE (Doc ID 2003579.1)