Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Open Form Template

    Uploaded by

    Redrouthu Jayaprakash
    The document provides steps for customizing an existing Oracle Forms template by modifying the window, canvas, and datablock names, updating triggers, and registering the customized form in Oracle Applications. This includes modifying package bodies, enabling list of values and calendars, setting user information on insert, and adding the form to the menu.

    Copyright:

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

    Open Form Template

    Uploaded by

    Redrouthu Jayaprakash
    8 views4 pages
    The document provides steps for customizing an existing Oracle Forms template by modifying the window, canvas, and datablock names, updating triggers, and registering the customized form in Oracle Applications. This includes modifying package bodies, enabling list of values and calendars, setting user information on insert, and adding the form to the menu.

    Original Description:

    Oracle Form Template Based

    Original Title

    Open Form Template (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides steps for customizing an existing Oracle Forms template by modifying the window, canvas, and datablock names, updating triggers, and registering the customized form in Oracle Applications. This includes modifying package bodies, enabling list of values and calendars, setting user information on insert, and adding the form to the menu.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    8 views4 pages

    Open Form Template

    Uploaded by

    Redrouthu Jayaprakash
    The document provides steps for customizing an existing Oracle Forms template by modifying the window, canvas, and datablock names, updating triggers, and registering the customized form in Oracle Applications. This includes modifying package bodies, enabling list of values and calendars, setting user information on insert, and adding the form to the menu.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 4

    Open Template

    Save As <Custom Name>


    Change the Form Name
    Goto Window > Remove the existing window name
    Goto Canvas > Remove the existing Canvas name
    Goto DataBlock> Remove the existing Block name

    Then we have to create new window, Canvas and DataBlock


    Go to window and click new
    Go to property pallet change the name of the window

    Click on Subclass information


    Change the property class
    Window
    Go to canvas > create New canvas
    Property pallet
    Change the name and sub-class info is canvas

    Go to Datablock
    It will open Data Block Wizard.

    Before crate a view on the tables

    Finish the datablock and finish canvas

    Now set the block name , subclass info as Block

    Now we have to update triggers.

    Fre-Form trigger
    Remove the window name and give our window name
    Compile it.

    Next goto WHEN-NEW-FORM-INSTANCE


    Remove the template and give the our template name.

    Go to program units:
    Modify the package body

    We have to modify the which form you want to open

    Then update the triggers


    Go to Datablock
    Items
    Attached the calendar to the date item
    Enable list of values to the column
    Go to property pallet > List of values (LOV)
    Select Enable List lamp
    So update the trigger the trigger is Key list val
    CALENDAR.SHOW();
    Compile it and the calendar is enabled.

    Enable Who columns


    Go to block level triggers.
    Select start trigger > others
    There we have two triggers
    Pre-Insert and pre-update

    PRE-INSERT
    Insert the id /sequence to the column
    SELECT sequence.nextval
    INTO block_name.item
    FROM dual;
    FND_STANDARD.SET_WHO(); This is the API we want to call

    Compile Form and save it.

    Migrate .fmb to AU_TOP>Forms folder


    Compile Form now

    Connect putty

    Or if it is windows CTL+K

    Now Open apps


    Register form in oracle
    Application Developer > Application >Forms

    Use form name as user form name for clarity

    Go to Function
    Function name and User function name is same name as above
    In the form tab, here we have to give the user form name
    Save the task and add this function to Menu
    Menu >
    Menu name <New name>

    Sequence = 1
    Prompt : Demo

    Save the records and submit

    You might also like