Form Builder Errors On Startup FRM-10102: Cannot attach PL/SQL library APPCORE

Errors: 

Unable to open Template.fmb. Getting following error

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 APPDAYPK. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library GLOBE. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library FNDSQF. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library JA. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library JE. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library JL. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library VERT. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library GHR. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library PQH_GEN. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library PSAC. This library attachment will be lost if the module is saved.

Cause:

FORMS_PATH was not set
 
FORMS_PATH should include location of pll and fmb files

Solution:

On windows7

=========

1. Open the System Properties control panel applet.
Note: To do this
Start Menu => Control Panel => System
2. Click on the Advanced tab.
3. Click on the Environment Variables button
4.Add the FORMS_PATH variable to the set of User Variables .
5. Click on the New button and enter the Variable Name and Variable Value
a). Variable Name = FORMS_PATH
b)Variable Value = full path to your pll and fmb files

Example

C:\DevSuiteHome_1\cgenf61\admin;C:\DevSuiteHome_1\forms

Optinal

6.Copy the above pll from your Unix environment i.e. ($AU_TOP/resource) to the location pointed by FORMS_PATH in the Windows machine i.e.(C:\DevSuiteHome_1\cgenf61\admin).

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM

Error:
=====
APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.

Shut down the concurrent managers. Set the basepath environment variable for the application. Restart the concurrent managers. (VARIABLE=)

Routine AFPEOT cannot construct the name of an executable file for your concurrent request 5194371.

Check that the file name components are correct and valid on your system. Check that the environment for the person who started the concurrent manager

Scenario:
=======
There is a Custom Top registered and that top is not set in the ENV while starting the conc.

Request Name:  Project Balance Head Exp

Query to Check whether the Env is set for the Particular request: 

===============================================
select variable name, value from fnd_env_context e, fnd_concurrent_processes p ,fnd_concurrent_requests r where p.concurrent_process_id =p.concurrent_process_id and p.concurrent_process_id = r.controlling_manager and e.variable_name like '%CUSTOM_TOP%' and r.request_id = &request_id;

Solution:
=======

 Ø  Make the new custom environment file in $APPL_TOP.

    i.e. $APPL_TOP/customTEST_erptestappldb.env

   Doing below entry in above make custom environment file in $APPL_TOP

   export XXCUSTOM_TOP=/testappl/apps/apps_st/appl/XXCUSTOM/12.0.0

 Ø  Add the respective Top in env file.

   $APPL_TOP/admin/adovars.env

   so that while running autoconfig it won’t remove every time.

   export XXCUSTOM_TOP=/testappl/apps/apps_st/appl/XXCUSTOM/12.0.0