This discussion is archived
2 Replies Latest reply: Feb 18, 2013 8:55 AM by nbyrne76 RSS

Embedded oracle form question

nbyrne76 Newbie
Currently Being Moderated
Hi

We are currently working on a solution that embeds an existing oracle forms(11g) application into a jsp/adf container and communicates via javascript with different elements on the page. I have recently hit a problem when launching the application. Everything launches fine but when the applet starts I get an error FRM-92190 Javascript is unable to evaluate expression. We had this working fine for months but something has changed and I am not sure what. I have tracked the problem down to the forms_ie.js which does the following: (fails on the second line as it never finds an element called "form_plugin_info")
/*
** FILE: forms_ie.js
**
** This java script file gets included in the Forms Servlet template htm
** file basejpi.htm and webutil template htm file webutiljpi.htm.
**
** Users who have customized replacements for these template htm files
** (basejpi.htm and webutiljpi.htm) should
** modify their customized template htm files and include this java script
** (similiar to the default template files).
*/

var plugin_info = document.getElementById("forms_plugin_info");
var jversion = plugin_info.getAttribute("plug_ver");
var jcodebase = plugin_info.getAttribute("appcodebase");
var jwidth = plugin_info.getAttribute("appwidth");
var jheight = plugin_info.getAttribute("appheight");
var name = plugin_info.getAttribute("appname");

document.write('<object classid="' + jversion + '"\n');
document.write('codebase="' + jcodebase + '"\n');
document.write('WIDTH="' + jwidth + '"\n');
document.write('HEIGHT="' + jheight + '"\n');
document.write('HSPACE="0"\n');
document.write('VSPACE="0"\n');
document.write('ID="' + name + '" MAYSCRIPT>\n');
This is the code for creating the applet on the page
<OBJECT classid="clsid:CAFEEFAC-0016-0000-FFFF-ABCDEFFEDCBA"
        codebase="http://java.sun.com/update/1.6.0/jinstall-6u10-windows-i586.cab#Version=1,6,0,39"
        WIDTH="1024"
        HEIGHT="768"
        HSPACE="0"
        VSPACE="0"
        ID="forms_applet">
        <SCRIPT LANGUAGE="JavaScript" SRC="http://192.168.13.152:9001/forms/frmjscript/forms_ie.js"></SCRIPT> 
        <PARAM NAME="TYPE"       VALUE="application/x-java-applet;jpi-version=1.6.0"/>
        <PARAM NAME="CODEBASE"   VALUE="http://192.168.13.152:9001/forms/java"/>
        <PARAM NAME="CODE"       VALUE="oracle.forms.engine.Main" />
        <PARAM NAME="ARCHIVE"    VALUE="frmall.jar,locus_forms.jar,icons.jar,frmwebutil.jar,jacob.jar" />
        <PARAM NAME="serverURL" VALUE="http://192.168.13.152:9001/forms/lservlet?ifcfs=http://192.168.13.152:9001/forms/frmservlet?config=migrate&FORM=loginstart&ifsessid=formsapp.125&acceptLanguage=en-US,en;q=0.8"/>
        <PARAM NAME="networkRetries" VALUE="0"/>
        <PARAM NAME="serverArgs"
               VALUE="escapeParams=true module=loginstart userid=  debug=no host= port= term=C:\Oracle\Middleware\asinst_1\config\FormsComponent\forms\fmrwebwcs.res"/>
        <PARAM NAME="separateFrame" VALUE="false"/>
        <PARAM NAME="splashScreen"  VALUE=""/>
        <PARAM NAME="background"  VALUE=""/>
        <PARAM NAME="lookAndFeel"  VALUE="oracle"/>
        <PARAM NAME="colorScheme"  VALUE="teal"/>
        <PARAM NAME="serverApp" VALUE="default"/>
        <PARAM NAME="logo" VALUE=""/>
        <PARAM NAME="imageBase" VALUE="codebase"/>
        <PARAM NAME="formsMessageListener" VALUE=""/>
        <PARAM NAME="recordFileName" VALUE=""/>
        <PARAM NAME="EndUserMonitoringEnabled" VALUE="false"/>
        <PARAM NAME="EndUserMonitoringURL" VALUE=""/>
        <PARAM NAME="heartBeat" VALUE=""/>
        <PARAM NAME="MaxEventWait" VALUE=""/>
        <PARAM NAME="allowAlertClipboard" VALUE="true"/>
        <PARAM NAME="disableValidateClipboard" VALUE="false"/>
        <PARAM NAME="enableJavascriptEvent" VALUE="true"/>
        <PARAM NAME="MAYSCRIPT" VALUE="true"/>
        <PARAM NAME="digitSubstitution" VALUE="context"/>
        <PARAM NAME="legacy_lifecycle" VALUE="false"/>
        <PARAM NAME="JavaScriptBlocksHeartBeat" VALUE="false"/>
        <PARAM NAME="highContrast" VALUE="false"/>
        <PARAM NAME="disableMDIScrollbars" VALUE=""/>
        <PARAM NAME="clientDPI" VALUE=""/>
        <!-- Params specific to webutil -->
        <PARAM NAME="WebUtilLogging" VALUE="on"/>
        <PARAM NAME="WebUtilLoggingDetail" VALUE="normal"/>
        <PARAM NAME="WebUtilErrorMode" VALUE="Alert"/>
        <PARAM NAME="WebUtilDispatchMonitorInterval" VALUE="5"/>
        <PARAM NAME="WebUtilTrustInternal" VALUE="true"/>
        <PARAM NAME="WebUtilMaxTransferSize" VALUE="1048576"/>
        <PARAM name="applet_stop_timeout" value="800"/>
<COMMENT>
<EMBED  id="forms_applet"
        SRC="" PLUGINSPAGE="http://javadl.sun.com/webapps/download/GetFile/1.6.0_10-b33/windows-i586/xpiinstall.exe"
        CODE="forms_applet"
        TYPE="application/x-java-applet"
        java_codebase="http://192.168.13.152:9001/forms/java"
        java_code="oracle.forms.engine.Main"
        java_archive="frmall.jar,locus_forms.jar,icons.jar,frmwebutil.jar,jacob.jar"
        WIDTH="1024"
        HEIGHT="768"
        HSPACE="0"
        VSPACE="0"
        NAME="forms_applet"
        serverURL="http://192.168.13.152:9001/forms/lservlet?ifcfs=http://192.168.13.152:9001/forms/frmservlet?config=migrate&FORM=loginstart&ifsessid=formsapp.125&acceptLanguage=en-US,en;q=0.8"
        networkRetries="0"
        serverArgs="escapeParams=true module=loginstart userid=  debug=no host= port= term=C:\Oracle\Middleware\asinst_1\config\FormsComponent\forms\fmrwebwcs.res"
        separateFrame="false"
        splashScreen=""
        background=""
        lookAndFeel="oracle"
        colorScheme="teal"
        serverApp="default"
        logo=""
        imageBase="codebase"
        recordFileName=""
        EndUserMonitoringEnabled="false"
        EndUserMonitoringURL=""
        heartBeat=""
        MaxEventWait=""
        allowAlertClipboard="true"
        disableValidateClipboard="false"
        enableJavascriptEvent="true"
        MAYSCRIPT="true"
        digitSubstitution="context"
        legacy_lifecycle="false"
        JavaScriptBlocksHeartBeat="false"
        highContrast="false"
        disableMDIScrollbars=""
        clientDPI=""
        WebUtilLogging="on"
        WebUtilLoggingDetail="normal"
        WebUtilErrormode="Alert"
        WebUtilDispatchMonitorInterval="5"
        WebUtilTrustInternal="true"
        WebUtilMaxTransferSize="1048576"
        applet_stop_timeout="800"
>
</EMBED>
</COMMENT>   
</OBJECT>
My question is what is the purpose of the forms_ie.js, should we be using it when we are not running with the standard htm templates and if we should how do I amend my code to include it.

Thanks

Neal

Edited by: nbyrne76 on Feb 18, 2013 3:12 AM
  • 1. Re: Embedded oracle form question
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    The reason the java script (js) files were added was the result of a change implemented by the browser vendors (Microsoft in this case). Without going into any deep detail, the addition of these files was necessary in order to get the Forms applet to load after certain restrictions were added to IE. It has been suggested that the restrictions which once cause the need for these files has since been removed/changed. Therefore, it may+_ be possible to now remove these files and their references.  Oracle is investigating this possibility, but currently has not completed any formal testing to prove if they are needed any longer.

    Feel free to remove them and make the appropriate changes to the corresponding template html files. Test drive it and let us know what you find. ;)

    Keep in mind that from an Oracle Support point if view, removing these files and altering this part of the template(s) may not be considered "supported".
  • 2. Re: Embedded oracle form question
    nbyrne76 Newbie
    Currently Being Moderated
    Thanks for the response Michael - I actually traced my problem to a missing js file in my project(even though chrome dev tools was stopping on the forms_ie.js) so my fault but thanks for the in insight into this additional file - always good to add to the knowledge base!

Legend

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