2 Replies Latest reply on Aug 13, 2019 8:47 AM by Peter Rauxloh

    Healthy forms installation cannot find FMX file

    Peter Rauxloh

      Hello All,

      Hopefully this is an easy one but I could not find an explanation


      We have carried out a test installation on a new VM of  WLS and Forms builder version, in order to test this version's  improved image handling abilities.

      On this machine I can run up  node manager, WLS admin and WLS admin FORMS server are all running, both WLS EM and the WLS admin console are reachable, and I can make an SQLPlus connection to my database.

      When I try http://localhost:9001/forms/frmservlet I get the familiar Installed Successfully! form showing.  All good.


      Problem is that when I try and run up the form I have created to test the new image functionality, 




      it does not find it, but just returns the same successful install message.

      The compiled form welcome_cde.fmx exists in the standard local directory C:\FORMS\PRDOUCTION, and this path is present in the FORMS_PATH variable as shown


      Finally the path variable visible form the command prompt on the machine has been altered to include those Oracle elements that are in the path variable on my working machine:


      PATH=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Java\jdk1.8.0_221\bin;C:\Oracle\Middleware\Oracle_Home\jlib;C:\Oracle\Middleware\Oracle_Home\bin;C:\Oracle\Middleware\Oracle_Home\forms;C:\Users\pradmin-mola\AppData\Local\Microsoft\WindowsApps;


      Otherwise I have compare the forms environment settings on my working and and believe they are identical.


      I would be very grateful if anyone could point me in the direction of things to check - and please do not assume to much knowledge - I may have omitted a basic step!




      Thank you in advance




      My Forms platform is :

      Oracle Cloud compute platform Windows Server 2012 R12 64bit

      Forms [64 Bit] Version

      Oracle Toolkit Version (Production)

      PL/SQL Version (Production)

      Oracle Procedure Builder V12. - Production

      PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)

      Oracle Query Builder - Production

      Oracle Virtual Graphics System Version (Production)

      Oracle Tools GUI Utilities Version (Production)

      Oracle Multimedia Version (Production)

      Oracle Tools Integration Version (Production)

      Oracle Tools Common Area Version

      Oracle CORE Production

      Java Version: Oracle Corporation, 1.8.0_77


      My database platform is

      Oracle Database 12c Standard Edition Release - 64bit Production in the Oracle cloud on a Linux box


      WLS is

      WebLogic Server Version:



        • 1. Re: Healthy forms installation cannot find FMX file
          Michael Ferrante-Oracle

          Problems are not "hard" or "easy"... they are just puzzled that have not yet been solved.


          Fortunately in your case the problem looks like a simple one.  Look closely at your URL.  See anything odd?




          "forms" should be "form"


          Regarding improved image handling, for the most part nothing happens automagically.  One of the main enhancements added was the ability to use an image's native format without compressing or otherwise altering it.  This is available for image items and images shown on the canvas.  Regarding image items, if an image was stored in the db through an image item using READ_IMAGE... whatever its format compression was done to it at that time cannot be changed.  So any improvement would only be against image uploaded with these changes.  Also, to enable this functionality you must set the image item property "Image Format" to Native

          If you would like to have your existing images benefit from these changes, at least somewhat, but do not want to alter your form, refer to the two new environment variables FORMS_MAP_GIF_IMAGE_TO_NATIVE and FORMS_MAP_JFIF_IMAGE_TO_NATIVE.  Details on how to use these can be found in the New Features Guide.




          Keep in mind that if you choose to use Native image formats, the compression usually performed by Forms will not occur.  This means if you upload a 10M image, the same 10M file will be returned at runtime.  This can greatly degrade performance if there are many images shown at one time (e.g. multi-record blocks)


          Also new is the ability to load images with READ_IMAGE file using a URL.  However, images loaded via a URL cannot be saved in the DB.


          READ_IMAGE_FILE('http://example.com/myimage.gif', 'URL', 'BLOCK1.Image1');


          SET_CANVAS_PROPERTY (CANVAS1', BACKGROUND_IMAGE, 'http://example.com/images/myImage.gif');


          Also added was the Fill option for Sizing Style:

          1 person found this helpful
          • 2. Re: Healthy forms installation cannot find FMX file
            Peter Rauxloh

            Hi Michael,

            I am in your debt once again, because your suggestion about form=welcome_cde rather than forms=welcome_cde  worked.

            This was rather odd because we have always used  the version  forms=welcome_cde.   However trying the form= version on our live installation this also works.  I guess is just a bit more picky?

            Thanks once again and also for the tips on showing the images.

            All the best