Oracle Forms Development steps

1.      Set New Environment Variable for FORMS60_PATH

My Computer à PropertiesàAdvanced

Click on Environmental Variables  à Goto System variables

Click on New

Enter   Variable name: FORMS60_PATH

            Variable value: your local resource library path

Close and open the forms builder.

2.      Now copy the .plls from /ora_home/au/11.5.0/resource/

1.      FNDSQF

2.      JE

3.      JL

4.      GLOBE

5.      APPCORE2

6.      HRKPI

7.      PSB

8.      PSA

9.      IGI_CBC

10.  IGI_CC

11.  IGI_DOS

12.  IGI_EXP

13.  IGI_IAC

14.  IGI_MHC

15.  IGI_SIA

16.  IGI_STP

17.  GMS

18.  FV

19.  APPDAYPK

20.  APPFLDR

21.  GHR

22.  IGILUTIL2

23.  IGILUTIL

24.  JA

25.  APPCORE

26.  VERT

27.  PQH_GEN

28.  PSAC

29.  CUSTOM

30.  OPM

31.  VERT1

32.  VERT2

33.  VERT3

34.  VERT4

35.  VERT5

3.      Now copy the APPSTAND.fmb & TEMPLATE.fmb into your local directory

4.      Open the Oracle Forms Builder and try to open the libraries in the same order as above

5.      Open the APPSTAND.fmb or TEMPLATE.fmb they will be opened.

6.      Now for TEMPLATE.fmb Save as.. your required form name according to naming conversions. And change the name in FORM property palette.

7.      Open the Windows navigator and delete the BLOCKNAME window.

8.      Open the Canvases navigator and delete the BLOCKNAME canvas.

9.      Open the Data Blocks navigator and delete the BLOCKNAME data block.

10.  At data block navigator click + sign in tool palette proceed to create a data block

11.  Similarly use wizard to prepare layout as required

12.  Enter the details in PRE-FORM (Form level) trigger, for author etc., enter the first block name, and window name

13.  Enter the FORM NAME in the WHEN-NEW-FORM-INSTANCE (Form Level) trigger.

14.  Create new windows as required, and attach the window to canvas and vice versa.

15.  Include Subclass Information for all newly created things in their respective Property palette.

16.  At Program Unit: APP_CUSTOM (Package Body) enter <your first window> and <it child window> and <yet its child window> this will help to create relationship between windows viz. master-child.

17.  Save all the changes and SFTP to /ora_home/au/11.5.0/forms.

18.  Open telnet...IP address <username>, <password> cd to /ora_home/au/11.5.0/forms

19.  type the following command:

f60genm Module=<formname> Userid=<userid/password> [Parameters].

Optional parameters are (default values given):

Ex: f60genm Module=employee.fmb Userid=apps/apps Module_Type=FORM Output_File=/ora_home/cutom_folder/11.5.0/forms/US/employee.fmx

20.  The server shows all the compiled details with errors if any.

21.  Register the form as usual.

Note: To open any Oracle Standard Form copy into local system and Try to open it show what are all the libraries it needs to load, write them in a notepad and copy them from the server /ora_home/au/resource path and put in the default local resource library path