Oracle Application Forms Development / Modification

  1. Copy libraries.

For modification or development in oracle application, the following libraries are required to open or change application form and must be copied from $AU_TOP/resource to the local drive e.g. c:\APPS_LIBRARY where you are trying to open Form or custom.pll.

    1. APPCORE.pll
    2. APPCORE2.pll
    3. CUSTOM.pll
    4. APPFLDR.pll
    5. VERT.pll
    6. GLOBE.pll
    7. JA.pll
    8. JE.pll
    9. JL.pll
    10. GHR.pll
    11. FNDSQF.pll
    12. APPDAYPK.pll
    13. PSAC.pll
    14. PQH_GEN.pll
    15. OPM.pll

  1. Set The Forms Path.

Open Registry Editor by using regedit and edit HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME\FORMS60_PATH and point to the location where the libraries above where copied. “C:\APPS_LIBRARY” in this example, without quotes

  1. Add the FORMS60_PATH key to the environment path.

This is accessed by right-clicking “My Computer”, selecting properties, clicking on the advanced tab, selecting Environment Variables. Set value to C:\APPS_LIBRARY

Advertisements

Difference between call_form, new_form and open_form

CALL_FORM

Runs an indicated form while keeping the parent form active. Oracle Forms runs the called form with the same Run form preferences as the parent form. When the called form is exited Oracle Forms processing resumes in the calling form at the point from which you initiated the call to CALL_FORM.CALL_FORM can be instructed to hide or not hide the calling form, replace or not replace the menu, open the new form in query only mode, share or not share library data.

NEW_FORM

Exits the current form and enters the indicated form. The calling form is terminated as the parent form. If the calling form had been called by a higher form, Oracle Forms keeps the higher call active and treats it as a call to the new form. Oracle Forms releases memory (such as database cursors) that the terminated form was using.Oracle Forms runs the new form with the same Run form options as the parent form. If the parent form was a called form, Oracle Forms runs the new form with the same options as the parent form.NEW_FORM can be instructed to continue the database transaction, rollback to the current save point or perform a full rollback. It can also be instructed to open the new form in query only mode and to share or not share library data.

OPEN_FORM

Opens the indicated form. Use OPEN_FORM to create multiple-form applications, that is, applications that open more than one form at the same time.OPEN_FORM can be instructed for the two forms to share the same database session and/or library data.

Components of the standalone Oracle Forms product

The standalone Oracle Forms product is composed of the following: Forms Builder – this program is used to create and modify Forms modules.

Forms Compiler – this program is used to generate your FMX files.
Forms Runtime – this program is the engine that runs your Form logic when you form is deployed in client/server.
Forms Metric Server – this program is used in Forms load balancing.
Forms Metric Client – this program is used in Forms load balancing.
Forms CGI – this program dynamically generates the applet html that defines your form.
Forms Server – this program listens for Forms Runtime engine requests.
Forms Web Runtime – this program is the engine that runs your Form logic when your form is deployed over the web.

HOW TO IDENTIFY THE VERSION OF A FORM

It is important to identify the current version of the program that is experiencing the problem, as a bug in the version of the program you are running may be the cause of your problem.
Form
A Form version is easily obtained via the front-end application. The navigation path is as follows –

-> Help -> About Oracle Application

Dialog Box appear
Search following
“Current Form”

—————————————-
Current Form
—————————————-
Form Application : Application Object Library
Form Name : FNDSCAUS
This Is Form name Currently Open
Form Path : /d01/oracle/prodappl/fnd/11.5.0/forms/US/FNDSCAUS.fmx
Complete path of Form
Form Version : 11.5.78
Form Last Modified : $Date: 2005/05/16 11:52 $

—————————————-
Forms
—————————————-
APPSTAND : 11.5.33
FNDSCAUS : 11.5.78
FNDSCSGN : 11.5.115

—————————————-
Form Menus
—————————————-
FNDMENU : 11.5.49

—————————————-
Forms PL/SQL
—————————————-
APPCORE : 11.5.142
CUSTOM : 11.5.5.1150.1
FNDSQF : 11.5.111
GHR : 11.5.150
GLOBE : 11.5.44.115103.4
GMS : 11.5.230.90.7
IGILUTIL2 : 11.5.97
IGILUTIL : 11.5.29
OPM : 11.5.33.115100.2
PQH_GEN : 11.5.118
PSA : 11.5.162
PSAC : 11.5.16
PSB : 11.5.24
VERT : 11.5.6