oracle.forms.jdapi.JdapiException: FRM-10102
The problem
I am using Oracle Forms Migration Assistant GUI to upgrade the forms from 6i to 11g. After I choose the module and connect to the database and click finish, I get the followingERROR opening C:\Users\sbotros\Desktop\FORM\APDPXXFX.fmb :oracle.forms.jdapi.JdapiException: FRM-10102: Cannot attach PL/SQL library Ofg4bsl. This library attachment will be lost if the module is saved.FRM-10102: Cannot attach PL/SQL library Ofg4TEl. This library attachment will be lost if the module is saved.FRM-10102: Cannot attach PL/SQL library Ofg4mes. This library attachment will be lost if the module is saved.Obviously some of the PL/SQL libraries he can't find
The Solution
When you run the Migration Assistant you probably run the following file 'frmplsqlconv.bat' and then the Migration Assistant Wizard pops up. What I have noticed that this file has its own FORMS_PATH which it reads from those libraries. P.S. open the file using Notepad++ or other text editors...........
set FORMS_PATH=%FORMS_PATH%;D:\ORACLE\Middleware\Oracle_FRHome1\forms;
..........
What I did was add the path where my libraries are so the file became like this
..........
set FORMS_PATH=%FORMS_PATH%;D:\ORACLE\Middleware\Oracle_FRHome1\forms;D:\LIB;
..........
The additional part is in BOLD and voila. run again every thing will run smoothly.
Please leave any comment if something is not clear.
