oracle application 11i


    OVERVIEW OF FORM CUSTAMIZATION

    Share
    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:26 am

    The following Diagram shows how the form customization is done at different levels:



    Mandatory Form and Libraries

    * In order to develop a form for Customization first we have to install the Oracle Forms Developer Version 6i on our local system.

    * FTP the Mandatory form i.e., TEMPLATE.fmb and required Pll’s from Vision Instance to the local machine.

    * The TEMPLATE.fmb file would be under the following path:/d01/oracle/visappl/au/11.5.0/forms/US/

    * The PLL’s would be under the following path: /d01/oracle/visappl/au/11.5.0/resource/

    * The PLL’s are:

    Mandatory Form and Libraries



    * In order to develop a form for Customization first we have to install the Oracle Forms Developer Version 6i on our local system.

    * FTP the Mandatory form i.e., TEMPLATE.fmb and required Pll’s from Vision Instance to the local machine.

    * The TEMPLATE.fmb file would be under the following path:/d01/oracle/visappl/au/11.5.0/forms/US/

    * The PLL’s would be under the following path: /d01/oracle/visappl/au/11.5.0/resource/

    * The PLL’s are:
    Mandatory Form and Libraries



    * In order to develop a form for Customization first we have to install the Oracle Forms Developer Version 6i on our local system.

    * FTP the Mandatory form i.e., TEMPLATE.fmb and required Pll’s from Vision Instance to the local machine.

    * The TEMPLATE.fmb file would be under the following path:/d01/oracle/visappl/au/11.5.0/forms/US/

    * The PLL’s would be under the following path: /d01/oracle/visappl/au/11.5.0/resource/

    * The PLL’s are:
    APPCORE.pll
    APPCORE2.pll
    APPDAYPK.pll
    APPFLDR.pll
    CUSTOM.pll
    FNDSQF.pll
    FV.pll
    GHR.pll
    GLOBE.pll
    GMS.pll
    HRKPI.pll
    IGILUTIL.pll
    IGILUTIL2.pll
    JA.pll
    JE.pll
    JL.pll
    OPM.pll
    PQH_GEN.pll
    PSA.pll
    PSAC.pll
    PSB.pll
    VERT.pll
    VERT1.pll
    VERT2.pll
    VERT3.pll
    VERT4.pll
    VERT5.pll
    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:26 am

    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(Wink.

    E.g.: Before Appending “C:\forms\TOOLS\OPEN60\PLSQLLIB”

    After Appending “C:\forms\TOOLS\OPEN60\PLSQLLIB;c:\forms\libraries”







    Develop the form using Form Builder Tool



    * Open the Forms Builder tool and click on the “Build a form based on a template” radio button
    * Choose the TEMPLATE.fmb form from your local working directory.
    * SAVE your new FORM as with a different filename. Also rename the module with the same name as the filename.
    * Create your blocks, items, triggers and relationships as per requirement.
    * Save your FORM frequently!!





    Apply property classes to each item to ensure the same look and feel as the rest of Oracle Apps forms.

    For each Module, Canvas, Window etc., apply the Property Classes that is most appropriate.



    Item Type Property Class

    * Module MODULE
    * Canvas CANVAS
    * Window WINDOW
    * Data Block BLOCK
    * Row ID ROW_ID
    * Text Item TEXT_ITEM
    * Display Item DISPLAY_ITEM or EXT_ITEM_DISPLAY_ONLY
    * Creation Date CREATION_OR_LAST_UPDATE_DATE
    * Last Update Date CREATION_OR_LAST_UPDATE_DATE



    To apply the property class, click on the small button (on the right) on the “Subclass information” property of the property sheet of each item. In the “Subclass Information” Window choose the property class radio button. Then choose the correct property class for the current item.

    Note: You cannot apply property classes to multiple items at once.



    Changes to be made in the Triggers and Program Units

    Modify specific trigger properties and program units to ensure the form will appear properly in Oracle Apps.



    * In the Property Palette of your module modify the ‘First Navigation Data Block’ property to the name of your first data block.
    * In the APP_CUSTOM.CLOSE_WINDOW program unit modify the following line: if (wnd = '<first window>') then app_window.close_first_window; by changing <first window> to the name of your first window

    Note: Also make sure the ‘Window’ property for your canvases are set to the proper window





    Transferring the “.fmb” file from local system to Vision Instance



    Now we have to transfer the form from local system to the Vision Instance.

    For this you have to go to the command prompt. Go to the directory where the fmb file is there.



    * Now give ftp pratik (this is our local instance)
    * Give the proper user name and password.
    * Now type bin (because we have to transfer the “.fmb” file in binary format)
    * Now give mput.<FILENAME.fmb>





    Generating the “.fmx” file on the Vision Instance



    * Logon To Pratik using Telnet. (i.e telnet pratik)
    * Give proper username and password
    * Change Directory ( cd /d01/oracle/visappl )
    * Set the Environment variable by issuing this command: . ./VIS.env
    * Now change Directory ( cd /d01/oracle/visora/8.0.6 ).
    * Again set the Environment variable by issuing this command: . ./VIS.env
    * Switch to your folder where “.fmb” file is present by issuing this command: cd
    * Set the character mode for the “.fmb” file by issuing this command

    chmod 755 FORMNAME.fmb

    * In order to Generate the “.Fmx “ file for the “.Fmb” file, issue the following command

    f60gen module=FORMNAME.fmb userid=apps/apps output_file=FORMNAME.fmx module_type=form batch=yes compile_all=special



    Note: Type this command in a single line.



    * Set the character mode for the fmx file. chmod 755 FORMNAME.fmx

    * Now copy this “.fmb” and “.fmx” files to the US directory. For this we have to give the command as cp FORMNAME.* /d01/oracle/visappl/cust/1.0/forms/US



    We have successfully generated the “.fmx” file for the “.fmb” file, and also we have copied both these files in the US directory. Now we have to assign the Menu for our FORM, which we have created.
    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:27 am

    Registering the Form in Oracle Applications



    In order to Register a form in Oracle Applications, first we need

    Application Developer Responsibility

    If this responsibility is not there, then assign this responsibility to your username.

    Choose the APPLICATION DEVELOPER Responsibility

    First we have to define the form
    Application à Form

    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:28 am

    The Values entered in the “Form” and “User Form Name” Fields in above window must be identical with the module name of the Form Created.



    Now we have to define the Function for the Form



    Application à Function

    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:29 am

    Now go to the tab page with the name “Form”

    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:29 am

    Here we have to select the form name from the Lov. This must be same as the name of the Form, which we have given, in the first form. (i.e Application à Form)



    Now we have to assign the menu for the form.


    Application à Menu



    Here we have to decide, in which responsibility we have to put this form.



    Suppose if we want to put our form in Oracle Payables responsibility then



    Give this “AX Payables Supervisor “ in the User Menu Name field in Query Mode.



    We will get the following screen.

    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:30 am

    Now we have to decide under which submenu the form should be kept. Suppose if we want to put our form under invoices then copy the Submenu value for the Invoices.



    The submenu value for the Invoices here is AP_INVOICES_GUI12

    Now copy this value and press f11(i.e go to the enter query mode)

    And give this value in User Menu Name field. If we do this we will get the following screen.

    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  shrikantgarud on Mon Dec 03, 2007 9:31 am

    Now insert a new record in the tabular block and save the form.

    Now we can view our form on the Application.



    The form is successfully registered to the Oracle Apps. In order to navigate to the registered form



    Switch to the Respective responsibility i.e., Oracle Payables.



    Invoices à Test Form


    Sponsored content

    Re: OVERVIEW OF FORM CUSTAMIZATION

    Post  Sponsored content


      Current date/time is Sat Sep 23, 2017 5:26 pm