This discussion is archived
4 Replies Latest reply: Feb 26, 2013 9:07 AM by Michael Ferrante (Oracle) RSS

migration from form 11.1.1.4.0 to 11.1.2

960926 Newbie
Currently Being Moderated
Hi Seniors/Guru

Currently we have forms/reports version 11.1.1.4.0 and we want to upgrade with 11.1.2. We have around 200 forms and 250 reports. My question is do we have to open each and every forms/reports and save it to 11.1.2 and compile it OR is there any script is avaiable to save and compile from 11.1.1.4 to 11.1.2.


Please guide me. Appreciate your help.

thanks!
  • 1. Re: migration from form 11.1.1.4.0 to 11.1.2
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    Refer to MyOracleSupport Note 955143.1
  • 2. Re: migration from form 11.1.1.4.0 to 11.1.2
    GavinWoods Explorer
    Currently Being Moderated
    Hi,

    Its a simple re-compile to move from 11.1.1.4 to 11.1.2. The only challenge you'll have is probably just installing the 11gR2 environment, which basically its a completely new install of the Forms environment.

    Per the Oracle Note frank posted, it can help show you how you can write a batch script on compiling your forms in batch. It would be essentially the same compile scripts that run on your 11.1.1.4 environment.

    If you run into any roadblocks/challenges with your upgrade to 11.1.2, feel free to contact me via: http://pitss.com/us/

    Thank you,

    Gavin
  • 3. Re: migration from form 11.1.1.4.0 to 11.1.2
    960926 Newbie
    Currently Being Moderated
    Hi Gavin,

    Appreciate your reply,Gavin please find below is my problem.

    Compiling is not the issue but I want to save from in 11.1.2 from 11.1.1.4.0 and then complie it. (I have complilation script)

    Because what happen our some forms are saved in 10g and some of are in 11.1.1.4.0. We want to save all in 11.1.2 so it will not open in lower version because may be you aware if we open in lower version form behaviour is change. i.e button becomes list box.

    Ok anyways I want script which open form and save it and close it through command line. Because as I discussed we have lots of forms and reports. So please guide me how we can do that OR is it possible.

    Seniors/guru please help.

    Thanks!
  • 4. Re: migration from form 11.1.1.4.0 to 11.1.2
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    Your problem is still unclear.

    When you use the command line options (or script) the source files (fmb, mmb, pll) are automatically converted to the current version. Once this occurs, the source files will no longer be accessible using older versions of the product. My recommendation is that you include the compile_all=yes option to your script. This will ensure that all the code is evaluated and properly generated. For example:
    <blockquote>frmcmp.sh module=myform userid=scott/tiger@orcl compile_all=yes</blockquote>
    If you are coming from older versions, some minor manual changes may be required. This is expected. The older the original source file, the more likely chance that you will need to open the form in the Builder and make modifications. This is one reason why we encourage you to always be on current versions.

    Older compiled executables (fmx, mmx, plx) and source files should be removed from the FORMS_PATH

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points