1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Custom Form Development

Discussion in 'Oracle Apps Technical' started by jagadekara, Mar 20, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    On the CLIENT machine create a FOLDER as say: c:\custom_test

    In custom_test folder creates 2 folders forms, resource

    Copy TEMPLATE.fmb, APPSTAND.fmb, .pll files to CLIENT

    • Copy TEMPLATE.fmb , APPSTAND.fmb from AU_TOP/forms/US to c:\custom_test\ forms directory copy all .pll files from /Applvis/visappl/au/11.5.0/resource to c:\custom_test\resource using ftp
    • On windows go to command prompt
    • Cd c:\custom_test\forms
    • ftp cloneserver
    • username: applmgr password: applmgr
    • now you are at ftp prompt
    • bin
    • prompt
    • cd visappl/au/11.5.0/forms/US ( here apparently cd $AU_TOP does not work)
    • get TEMPLATE.fmb
    • (file copied)
    • get APPSTAND.fmb
    • (file copied)
    • lcd ./resource (check this. Basically you need to be in c:\custom_test\resource. You can go to that directory and then run ftp)
    • cd visappl/au/11.5.0/resource
    • mget *.pll
    • ( now all .pll files are copied to c:custom_test/resource)

    SET env variable FORMS60_PATH through regedit

    • Regedit/HKEY_LOCAL_MACHINE/software/oracle
    • Double click FORMS60_PATH
    • At the end of existing value data add: ;c:\custom_test\froms;c:\custom_test\resource

    Now open TEMPLATE.fmb and make the following changes

    • DELETE BLOCKNAME &DETAIL BLOCK FROM DATABLOCK,DELETE BLOCKNAME FROM CANVAS AND WINDOW
    • Create a window NEW_WIN, canvas NEW_CAN
    • Create a new block based on the table you created in your custom schema
    • In pre-form trigger: app_windows.set_window_position(‘NEW_WIN’)…….
    • In program units open custom_package.AP_cutom_pacakge body
    • Change : if (wind=’NEW_WIN’);
    • Template name = TEST_FORM
    • Save as TEST_FROM to c:\custom_test\forms
    • (????????SET THE WINDOW NAME AS U HAVE CREATED NEW WINDOW IN PRE-FORM TRIGGER BY BLOCKNAME?????)

    DEPLOY the FORM (upload it to AU_TOP/forms/US)

    • Go to command prompt (on client)
    • cd c:\cutom_test\forms
    • ftp cloneserver
    • cd visappl/au/11.5.0/froms/US
    • bin
    • prompt
    • put TEST_FORM.fmb


    Changing ORACLE_HOME (/Visdb/visdb/9.2.0 to /Applvis/visora/8.0.6)

    • thru putty login as applmgr
    • pwd: /Applvis
    • echo $ORACLE_HOME: shows /Visdb/visdb/9.2.0
    • cd visora
    • cd 8.0.6
    • . VIS_cloneserver.env (this changes ORACLE_HOME apparently based on pwd?)
    • echo $ORACLE_HOME: shows /Applvis/visora/8.0.6
    • now ORACLE_HOME is 8.0.6 (forms/reports home)
    • pwd : gives /Applvis/visora/8.0.6

    COMPILE and generate FMX

    • (now you are in /Applvis/visora/8.0.6 directory and ORACLE_HOME is set to /Applvis/visora/8.0.6)
    • pwd: gives /Applvis/visora/8.0.6
    • f60gen module=$AU_TOP/forms/US/TEST_FORMS.fmb module_type=form user=apps output_file=$TEST_TOP/forms/US/TEST_FORM.fmx compile_all=special batch=no
    • this generates TEST_FORM.fmx and puts in TEST_TOP/forms/US

    FORM REGISTRATION

    • Login to applications with application developer responsibility
    • Application/form
    • Enter the following details
    o Form: the fmx name (TEST_FORM)
    o Application: Oracle Receivables (as per Amer) –give appropriate name based the intended use of this form
    o user form name: TEST_FORM_U (this will appear in LOV)
    o SAVE

    Attach the FORM to FUNCTION
    (Create a new function)
    Application/function
    Enter the following details
    o Function: TEST_FUNCT
    o User function name: TEST FUNCTION
    o Form: TEST_FORM (previously registered)
    o SAVE

    Attach FUNCTION to MENU
    Application/menu
    • Enter the following details
    o Menu: test_menu
    o User menu name: test menu
    o Seq: 1
    o Prompt: test form
    o Function: TEST_FUNCT( previously deined)
    o SAVE

    Attach MENU to RESPONSIBILITY

    Attach RESPONSIBILITY to USER

    Login as the new USER