How can I copy and compile forms?

Make sure while copying the pll files from AU_Top to local drive or vice versa from winscp make sure your Transfer Settings is changed from default to Binary.

Before compiling make sure you set environment settings in putty. Ask your DBA if it is the first time.

How to compile forms?
 For example if its custom.pll

frmcmp_batch module=CUSTOM.pll userid=apps/$pwd output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special

FRM-10142

If you face this issue when you click on run form button in forms builder, Start OCJ4 server and go to edit click on preferences --> click on runtime and Type your application server URL or click on reset it to default and start running the form again

Forms Builder Settings

Forms Builder

Step 1

Open WinSCP and go to AU_TOP

/<Root> à Dev2_Bin à Pebbles à Apps à Apps_st à appl à auà12.0.0.0 à Resource

Copy all PLL files to your local drive to any folder say forms

1.       You can select PLL files by right clicking on WinSCP and sort by column options and copy and paste it to your local drive

2.       Copy APPSTAND.FMB and STANDARD.FMB file as well

Step 2

I assume you have Devsuite folder in your C Drive as you have devsuite installed

Copy tnsnames.ora file to your DevsuiteàNetworkàAdmin folder in devsuite and save it.

Step 3

Open Regedit and press CTRL+F and type FORMS_PATH. There add the path of the folder where you copied the pll files from AU_TOP to the existing path and save it

Step 4

Right click on forms builder icon, click on properties and give the path of the same folder in Start in checkbox and save it.

Now open APPSTAND.FMB file and Any one pll file. You should be good if you do not face any error.

PDE - PLI018 could not find library FNDSQF

If you face this kind of error in forms open WINSCP and go to AU_TOP and copy all the pll files from resource folder to local computer and try to load it again. If you face the same error you may need to check the path of FORMS_PATH in regedit and add this folder path over there

Forms Builder

Step 1

Open WinSCP and go to AU_TOP

/<Root> à Dev2_Bin à Pebbles à Apps à Apps_st à appl à auà12.0.0.0 à Resource

Copy all PLL files to your local drive to any folder say forms

1.       You can select PLL files by right clicking on WinSCP and sort by column options and copy and paste it to your local drive

2.       Copy APPSTAND.FMB and STANDARD.FMB file as well

Step 2

I assume you have Devsuite folder in your C Drive as you have devsuite installed

Copy tnsnames.ora file to your DevsuiteàNetworkàAdmin folder in devsuite and save it.

Step 3

Open Regedit and press CTRL+F and type FORMS_PATH. There add the path of the folder where you copied the pll files from AU_TOP to the existing path and save it

Step 4

Right click on forms builder icon, click on properties and give the path of the same folder in Start in checkbox and save it.

Now open APPSTAND.FMB file and Any one pll file. You should be good if you do not face any error.

Forms: Ora 12154 TNS: Could not resolve service name

When you face this kind of error check for your tnsnames.ora file. If it doesn't exist in devsuite-->Network-->admin folder, make sure that you keep tnsnames.ora file in the folder and check whether the tns do contain data about the database which you are about to connect

FRM-10102: Cannot attach PL/SQL library APPCORE

FRM-10102: Cannot attach PL/SQL library APPCORE


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

Solution :: Need to add FORMS_PATH  in registry of windows.

Press Win R to open windows Run and put regedit to edit the windows registry.
and search ofr FORMS_PATH
and custom Forms and plls path in this variable

====================================