Friday, September 7, 2012

Setting up Forms60_Path in Registry


Setting up Forms60_Path in Registry

Setting up Forms60_Path in Registry

Copy all these PL/SQL libraries and the Template form in one folder.
Now we have to set the form60 path in the registry.
Go to Start -->Run -->Regedit -->HKEY_LOCAL_MACHINE -->Software -->Oracle
Here we can find the oracle homes. In these homes check for FORMS60_PATH.

Append the path of your folder where all the libraries and the form is present, prefixed with a semicolon(;).

E.g.: Before Appending “C:\forms\TOOLS\OPEN60\PLSQLLIB”
After Appending “C:\forms\TOOLS\OPEN60\PLSQLLIB;c:\forms\libraries”


Oracle has well-defined guidelines that must be followed when creating custom
forms in E-Business Suite. By following these guidelines, your custom forms will
look and feel exactly the same as standard forms, and your custom development
will remain upgrade safe. Effectively, when creating custom forms, the guidelines
and procedures followed by you are the same as those followed by Oracle’s product
development team. All the forms in Oracle E-Business Suite are based on
TEMPLATE.fmb. As with other forms in E-Business Suite, the TEMPLATE.fmb file can
be found in the $AU_TOP/forms/US directory.
The TEMPLATE form includes an example window with sample blocks, as well
as many referenced objects such as windows, canvases, blocks, Lists of Values
(LOVs), and other objects. It inherits the object groups from the APPSTAND form,
which is a platform-specific form. By starting out with the TEMPLATE form when
developing custom forms in E-Business Suite, developers ensure that they will get
the same look and properties of the standard product forms. Examples of such
properties specific to Oracle Applications are the toolbar, the menu, the calendar,
applications property classes, required Form Level triggers, required procedures,
LOVs, parameters, and many others.
Open TEMPLATE.fmb
In order to begin development, you must base your custom form development on
the TEMPLATE form (TEMPLATE.fmb). This ensures that your custom form will
inherit the shared core form components and libraries. The TEMPLATE form has
attached several libraries such as FNDSQF, APPCORE, APPDAYPF, and others that
contain many of the Application Object Library utilities.
Let us assume that you want to store all your FMB and PLL files in the folder C:\
code\forms on your Windows desktop. Transfer TEMPLATE.fmb from $AU_TOP/
forms/US from the middle-tier machine to the C:\code\forms directory on your
desktop. Now in Oracle Forms try to open TEMPLATE.fmb. You will get a message
“FRM-18108: Failed to load the following objects”. If you click on OK, you will get
another error listing the missing libraries (FRM-10102 errors). At this stage, you must
not save TEMPLATE.fmb once it is opened.
The reason we see those errors is because the TEMPLATE form itself depends on
other forms and libraries. Before you begin to transfer all the dependent objects from
the server, you must set the FORMS_PATH environment variable on your computer.
In order to do so, right-click My Computer, click on Properties, and in the Advanced
setting, click on the button labeled Environment Variable. For R12, name of the
environment variable will be FORMS_PATH and its value set to C:\code\forms.
For Release 11i, you can change the value of FORMS60_PATH in the registry to
include your directory, which is C:\code\forms in our example. After changing the
environment variable, you must restart the forms builder for this change to take effect.
In order to open TEMPLATE.fmb successfully, we have two options. The first option
is to transfer everything from the $AU_TOP/forms/US and $AU_TOP/resource
directories from the middle-tier machine to the C:\code\forms directory on the
desktop. However, in R12 instance, this will equate to transferring files over 3GB to
your desktop. Therefore, the second option is to be selective for the files being
transferred from the server. From $AU_TOP/forms/US, transfer the APP*.fmb and
FND*.fmb forms to folder C:\code\forms. Similarly, from $AU_TOP/resource, transfer
the APP*.pll, FND*.pll, VERT*.pll, PS*.pll, HR*.pll, GMS*.pll, FV*.pll, IGI*.pll, GLOBE.
pll, JA.pll, JE.pll, JL.pll, VERT.pll, GHR.pll, PQH_GEN.pll, PSAC.pll, CUSTOM.pll.

and OPM.pll libraries. If you still receive message for some other missing libraries,
then transfer those as well. Sometimes the error message for a missing library can be
misleading. For example, you might get the error, “Cannot find APPDAYPK.pll,”
despite the file being present in the C:\code\forms directory. In such cases, try to
open APPDAYPK.pll itself to see the dependent libraries that remain to be transferred
to your desktop.
Once all the required objects have been transferred to C:\code\forms, you will
be able to open TEMPLATE.fmb without any errors and at that point you can start
developing the custom form.
Steps for Developing Custom
Forms in E-Business Suite
Follow these steps to create custom forms in E-Business Suite:
1. Create TEMPLATE form Make a copy of TEMPLATE.fmb and rename
it to your custom form name. Your form name will begin with XX. For
developing HRMS-related screens, use HRTEMPLT.fmb.
2. Develop form Develop your form as per programming guidelines.
3. Generate runtime file Transfer the FMB file to midtier and compile it to
generate an FMX compiled file.
4. Register Register the form with Custom Application.
5. Create form function Create a form function attached to the form.
6. Attach to menu Attach the form function to the menu.
7. Assign to responsibility Assign the menu to the responsibility.

No comments:

Post a Comment