Scribd Logo
Upload

Welcome to Scribd!

  • 239 views

    Creating New Form in Oracle Apps

    Uploaded by

    Sudha Krishna
    The document provides steps to customize an Oracle Forms application. It involves copying template files, PL/SQL libraries, designing a new form in Forms Builder, deploying and compiling the form, registering the form in Oracle Applications, attaching it to a menu responsibility, and viewing the customized form. Key steps include renaming the template form, creating new windows, canvases, and datablocks, modifying triggers to reference the new objects, deploying and compiling the form, registering the form and linking it to a menu responsibility for users to access.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Creating New Form in Oracle Apps

    Uploaded by

    Sudha Krishna
    239 views4 pages
    The document provides steps to customize an Oracle Forms application. It involves copying template files, PL/SQL libraries, designing a new form in Forms Builder, deploying and compiling the form, registering the form in Oracle Applications, attaching it to a menu responsibility, and viewing the customized form. Key steps include renaming the template form, creating new windows, canvases, and datablocks, modifying triggers to reference the new objects, deploying and compiling the form, registering the form and linking it to a menu responsibility for users to access.

    Original Description:

    Creating New Form in Oracle Apps

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides steps to customize an Oracle Forms application. It involves copying template files, PL/SQL libraries, designing a new form in Forms Builder, deploying and compiling the form, registering the form in Oracle Applications, attaching it to a menu responsibility, and viewing the customized form. Key steps include renaming the template form, creating new windows, canvases, and datablocks, modifying triggers to reference the new objects, deploying and compiling the form, registering the form and linking it to a menu responsibility for users to access.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    239 views4 pages

    Creating New Form in Oracle Apps

    Uploaded by

    Sudha Krishna
    The document provides steps to customize an Oracle Forms application. It involves copying template files, PL/SQL libraries, designing a new form in Forms Builder, deploying and compiling the form, registering the form in Oracle Applications, attaching it to a menu responsibility, and viewing the customized form. Key steps include renaming the template form, creating new windows, canvases, and datablocks, modifying triggers to reference the new objects, deploying and compiling the form, registering the form and linking it to a menu responsibility for users to access.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 4

    Step 1: COPYING FILES FROM THE SERVER

    a) Copy TEMPLATE.fmb file from $AU_TOP/forms/US folder to a local directory. Also download
    APPSTAND.fmb file and place it in D:\DevSuiteHome_1\forms

    b) Copy All PL/SQL Libraries from $AU_TOP/resource/US folder (one time only). Download all the
    .pll and .plx files to D:\DevSuiteHome_1\forms

    LIST OF .PLL

    APPCORE.PLL
    APPCORE2.PLL
    APPDAYPK.PLL
    APPFLDR.PLL
    CUSTOM.PLL
    FNDMOAC.PLL
    FNDSQF.PLL
    FV.PLL
    GHR.PLL
    GLOBE.PLL
    GMS.PLL
    HRKPI.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

    Step 2: DESIGN THE FROM IN ORACLE FORMS BUILDER

    a) Remove the Defaults


    >Open Oracle Forms Builder
    >Open the form TEMPLATE.fmb
    >Rename the form (ex XX_abcd1)
    >Delete the followings from object nevigator.
    >Go to Data Blocks and delete BLOCKNAME, DETAILBLOCK
    >Go to Windows and delete BLOCKNAME
    >Go to Canvases and delete BLOCKNAME
    b) Create a new Window (ex WINDOW10)
    c) Create a new Canvas (ex CANVAS10) and attached it to the new Window via Property Palate
    d) Create a new Datablock (ex CUSTOMERS) wth items from a table.
    e) Create a frame in the Canvas and attached the items
    f) Modify the PRE-FORM Trigger
    >Go to triggersPREFORM
    >Original Code:

    FND_STANDARD.FORM_INFO($Revision: 120.0 $, Template Form, FND,


    $Date: 2005/05/06 23:25 $, $Author: appldev $);
    app_standard.event(PRE-FORM);
    app_window.set_window_position(BLOCKNAME, FIRST_WINDOW);

    >Modified Code:

    FND_STANDARD.FORM_INFO($Revision: 1.0 $, XXARCUST_1,CUST_FORM,


    $Date: 2010/01/06 16:25 $, $Author: Dibyajyoti $);
    app_standard.event(PRE-FORM);
    app_window.set_window_position(WINDOW10, FIRST_WINDOW);

    > Compile the code

    g) Modification for Program unit


    > Go to APP_CUSTOM*(Package Body)
    >Type your First window name in place of <your first window>
    > Compile the code
    h) If any Item in the Datablock is of Date type and you want to attach a standard calender to it
    (ex Orderdate item of Customers datablock), do the following
    > Go to Orderdate > Property palate > Subclass Information > Property Class
    > Give property class name as TEXT_ITEM_DATE
    > Attach LOV as ENABLE_LIST_LAMP
    > Create KEY-LISTVAL item level trigger & add following code into it
    calendar.show; and compile the trigger.

    Step 3: DEPLOY THE FORM IN THE SERVER

    > Upload your .fmb file

    Step 4: CREATE THE .fmx FILE IN THE SERVER


    >Type the code
    $ORACLE_HOME/bin/frmcmp_batch module=$XXAR_TOP/forms/US/CUSTOMERS.fmb
    userid=<username>/<password> output_file=$XXAR_TOP/forms/US/ CUSTOMERS.fmx
    module_type=form compile_all=special

    Step 5: REGISTARING THE FORM IN ORACLE APPS

    a) Registaring the FORM in Oracle Apps


    > Go to Application Developer > Application > Form
    > Give the details:

    FORM: CUSTOMERS(name of the custom form)


    APPLICATION: Custom AR Application
    User Form Name: CUSTOMERS_DETAIL
    Description: Customer Detail form
    > save

    b) Registaring the FORM to a form function


    > System Administrator ->Application -> Function
    > Give the details:

    Form->form:CUSTOMERS_DETAIL
    Function:XX_CUSTOMER_DETAIL
    APPLICATION: Custom AR Application
    Properties > Type: Form
    User Function Name: CUSTOMERS_DETAIL_FUNCTION

    > save
    c) Finding the menu to which the above form function is to be attached. Again the menu is attached
    to a responsibilty. So we have go in the reverse order to find the menu name.
    > System Administrator ->Security -> Responsibility ->Define
    > Press F11
    > Responsibility Name: %US%Rec (searching for US Receivables Super User)
    > Press Ctrl + F11

    > This things will come in the form


    Responsibility Name: US Receivables Super User
    Application:Receivables (will come automatically )

    >Take the Menu name >AR_NAVIGATE_GUI

    d) Attaching the function to a Submenu of the above Main menu


    > System Administrator ->Application > Menu
    > Press F11
    > Menu: AR_NAVIGATE_GUI
    > Press Ctrl+F11

    > Promt: Custom Interfaces


    > Submenu: XXAR_CUSTOM

    >System Administrator ->Application > Menu


    > Press F11
    > Menu: XXAR_CUSTOM
    > Press Ctrl+F11
    > Create a new
    > Promt: Customer Detail Form (It will display in the nevigator)
    >Function: CUSTOMERS_DETAIL_FUNCTION (Attach the function to the submenu)
    > save
    >One request has been submitted to recompile your menus in the database
    e) Viewing the request submitted in the background to recompile the menus to attach the function
    > Go to View>Requests>Find
    >The status should be :Compiled Normal

    Step 6: VIEWING THE FORM IN ORACLE APPLICATION:

    >Go to Oracle apps front end.


    >Login with username and password
    >Go to US Receivables Super User>Custom Interfaces >Customer Detail Form

    FND_STANDARD.SET_WHO doesn't work / not working


    Even though FND_STANDARD.SET_WHO is set in pre-insert and pre-update data block triggers it
    fails to show record history.

    Use app_special.enable('ABOUT', PROPERTY_ON) in WHEN-NEW-BLOCK-INSTACE trigger of


    corresponding blocks along with set_who.

    You might also like