Oracle Forms

Hi All

I am unable to run forms from within my recently installed/configured Forms Builder application. I am simply choosing Program->Run Form from the toolbar. The form seems to starts to deploy, A message appears in the browser top right - ORACLE FORMS. This then disappears and is replaced by a blank browser screen. What am I missing? Please help.

Oracle Version                    : 12.2.0.1.0

FMW/FRS                           : 12.2.1.2.0

DB Oracle Home                 : C:\Oracle12c\DB\Oracle_Home

FMW Oracle Home             : C:\Oracle12c\Middleware\Oracle_Home

FRS Domain                       : C:\Oracle12c\Middleware\FRS\Forms\Domain

Forms Home                       : C:\Oracle12c\DB\Oracle_Home\forms

fmwconfig/TNS_ADMIN      : C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig

WLS_SERVER config         : C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config

I am starting the various node manager and weblogic servers in the following order:

C:\Oracle12c\Middleware\FRS\Forms\Domain\bin\startNodeManager.cmd                         - Node Manager

C:\Oracle12c\Middleware\FRS\Forms\Domain\bin\startWeblogic.cmd                                 - AdminServer Server

C:\Oracle12c\Middleware\FRS\Forms\Domain\bin\startManagedWeblogic WLS_FORMS   - WLS_FORMS Server

I have set the web browser to chrome and also tried firefox but with same results, and set the run time Application Server URL to http://LAPTOP-9R3NTMTP:9001/forms/frmservlet. I have tried both test.fmx and mysimpleform.fmx in both the Application Server URL ( http://LAPTOP-9R3NTMTP:9001/forms/frmservlet?form=test.fmx/mysimpleform.fmx) and by setting the form parameter in the formsweb.cfg config file (form=test.fmx/mysimpleform.fmx), and added my FMX directory to the FORMS_PATH environment variable in default.env.

What am I missing guys? Any help would be greatly appreciated. I've been trying to look for log files to see if I can see exactly what is being sent to OHS, but am not able to find any (must not be looking in the right places).

I have included copies of both the formsweb.cfg and default.env files below.

C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config\formsweb.cfg:

# formsweb.cfg defines parameter values used by the FormsServlet (frmservlet)

# This section defines the Default settings.  Any of them may be overridden in the

# following Named Configuration sections.  If they are not overridden, then the

# values here will be used.

# The default settings comprise two types of parameters: System parameters,

# which cannot be overridden in the URL, and User Parameters, which can.

# Parameters which are not marked as System parameters are User parameters.

# SYSTEM PARAMETERS

# -----------------

# These have fixed names and give information required by the Forms

# Servlet in order to function.  They cannot be specified in the URL query

# string.  But they can be overridden in a named configuration (see below).

# Some parameters specify file names: if the full path is not given,

# they are assumed to be in the same directory as this file.  If a path

# is given, then it should be a physical path, not a URL.

# USER PARAMETERS

# ---------------

# These match variables (e.g. %form%) in the baseHTML file. Their values

# may be overridden by specifying them in the URL query string

# (e.g. "http://myhost.example.com/forms/frmservlet?form=myform&width=700")

# or by overriding them in a specific, named configuration (see below)

[default]

# System parameter: default base HTML file

baseHTML=base.htm

# System parameter: base HTML file for use with Sun's Java Plug-In

baseHTMLjpi=basejpi.htm

# System parameter: delimiter for parameters in the base HTML files

HTMLdelimiter=%

# System parameter: file setting environment variables for the Forms runtime processes

envFile=default.env

# System parameter: Forms runtime arguments

serverArgs=%escapeparams% module=%form% userid=%userid% debug=%debug% host=%host% port=%port% %otherparams%

# Forms runtime argument: whether to escape certain special characters

# in values extracted from the URL for other runtime arguments

escapeparams=true

# Forms runtime argument: which form module to run

#form=test.fmx

form=hr.fmx

# Forms runtime argument: database connection details

userid=

# Forms runtime argument: whether to run in debug mode

debug=no

# Forms runtime argument: host for debugging

# For internal use. Do not change null value.

host=

# Forms runtime argument: port for debugging

# For internal use. Do not change null value.

port=

# Forms runtime argument: BIDI digitSubstitution

digitSubstitution=context

# Other Forms runtime arguments: grouped together as one parameter.

# These settings support running and debugging a form from the Builder:

otherparams=obr=%obr% record=%record% tracegroup=%tracegroup% log=%log% term=%term% ssoProxyConnect=%ssoProxyConnect%

# Sub argument for otherparams

obr=no

# Sub argument for otherparams

record=

# Sub argument for otherparams

tracegroup=

# Sub argument for otherparams

log=

# Sub argument for otherparams

term=

# HTML page title

pageTitle=Garys - Oracle Fusion Middleware Forms Services

# HTML attributes for the BODY tag

HTMLbodyAttrs=

# HTML to add before the form

HTMLbeforeForm=

# HTML to add after the form

HTMLafterForm=

# Forms applet parameter: URL path to Forms ListenerServlet

serverURL=/forms/lservlet

# Forms applet parameter

codebase=/forms/java

# Forms applet parameter

imageBase=codebase

# Forms applet parameter: location for media files

mediaBase=codebase

# Forms applet parameter

width=750

# Forms applet parameter

height=600

# Forms applet parameter

separateFrame=false

# Forms applet parameter

splashScreen=

# Forms applet parameter

allowAlertClipboard=true

# Forms applet parameter

disableValidateClipboard=false

# Forms applet parameter

highContrast=false

# Forms applet parameter

background=

# Forms applet parameter

lookAndFeel=Oracle

# Forms applet parameter

colorScheme=swan

# Forms applet parameter to configure custom color scheme

customColorScheme=

# Forms applet parameter

logo=

# Forms applet parameter, valid range [0-3]

guiMode=0

# Forms applet parameter

restrictedURLparams=pageTitle,HTMLbodyAttrs,HTMLbeforeForm,HTMLafterForm,log

# Forms applet parameter

formsMessageListener=

# Forms applet parameter

recordFileName=

# Forms applet parameter

serverApp=

# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)

archive=frmall.jar

# Number of times client should retry if a network failure occurs.  You should

# only change this after reading the documentation.

networkRetries=0

#

# More information regarding jpi and java_version settings can be found here:

# http://docs.oracle.com/javase/8/docs/technotes/guides/jweb/applet/using_tags.html

#

# Page displayed to users to allow them to download Oracle's Java Plugin.

# This is typically used for non-Microsoft Internet Explorer clients.

jpi_download_page= http://www.oracle.com/technetwork/java/javase/downloads

# Parameter to identify the Java Plugin

jpi_classid=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93

#

# Parameter related to the version of the Java Plugin and a desired download location

#jpi_codebase=http://example.com/somewhere/jre-8u40-windows-i586.exe#Version=1,8,0,40

#

# Parameter related to the version of the Java Plugin

jpi_mimetype=application/x-java-applet

#

# Parameter used to specify which Plugin version to use

java_version=1.7+

#

# Applet parameter for Oracle's Java Plugin.

legacy_lifecycle=false

# Single Sign-On OID configuration parameter: indicates whether we allow

# dynamic resource creation if the resource is not yet created in the OID.

ssoDynamicResourceCreate=true

# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false

ssoErrorUrl=

# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.

ssoCancelUrl=

# Single Sign-On parameter: indicates whether the url is protected in which

# case mod_osso will be given control for authentication or continue in

# the FormsServlet if not. It is false by default. Set it to true in an

# application-specific section to enable Single Sign-On for that application.

ssoMode=false

# Single Sign-On parameter: indicates whether session should operate in proxy

# user support or not. Specify ssoProxyConnect=yes to enable for particular application.

ssoProxyConnect=no

# Single Sign-On parameter: indicates whether session should be logged out

# while exiting

ssoLogOut=false

# Single Sign-On parameter: Redirect URL to which the browser should be

redirected after logging out while exiting the session

ssoLogOutRedirect=

# Single Sign-On parameter: parameter to hold the name of query parameter on OAM Logout

# URL that holds the landing URL.

logoutTargetURLParamname=

# The parameter allow_debug determines whether debugging is permitted.

# Administrators should set allow_debug to "true" if servlet

# debugging is required, or to provide access to the Forms Trace Xlate utility.

# Otherwise these activities will not be allowed (for security reasons).

allow_debug=false

# Parameter which determines whether new Forms sessions are allowed.

# This is also read by the Forms EM Overview page to show the

# current Forms status.

allowNewConnections=true

# EndUserMonitoring

# EndUserMonitoringEnabled parameter

# Indicates whether EUM/Chronos integration is enabled

EndUserMonitoringEnabled=false

# EndUserMonitoringURL

# indicates where to record EUM/Chronos data

EndUserMonitoringURL=

# Config for javascript integration

applet_name=

enableJavascriptEvent=true

# Config variable that will indicate if heartbeat will

# be blocked when a javascript call is a blocking call.

# The default value if false, i.e heart beat will not be

# blocked for any javascript calls.

JavaScriptBlocksHeartBeat=false

# idleTimeout indicates how many seconds to wait

# before sending a message to the server indicating client-inactivity. Null

# or 0 means this functionality is disabled and there will be no client-idle

# notification.

idleTimeout=

#Setting separate_jvm=true is required for audio support

separate_jvm=false

# Example Named Configuration Section

# Example 1: configuration to run forms in a separate browser window with

# "generic" look and feel (include "config=sepwin" in the URL)

# You may define your own specific, named configurations (sets of parameters)

# by adding special sections as illustrated in the following examples.

# Note that you need only specify the parameters you want to change.  The

# default values (defined above) will be used for all other parameters.

# Use of a specific configuration can be requested by including the text

# "config=<your_config_name>" in the query string of the URL used to run

# a form.  For example, to use the sepwin configuration, your could issue

# a URL like "http://myhost.example.com/forms/frmservlet?config=sepwin".

[sepwin]

separateFrame=True

lookandfeel=Generic

# Example Named Configuration Section

# Example 2: configuration running the Forms ListenerServlet in debug mode

# (debug messages will be written to the servlet engine's log file).

[debug]

serverURL=/forms/lservlet/debug

# Sample configuration for deploying WebUtil. Note that WebUtil is

# only installed with the Forms Builder and is also available for download

# from OTN.

[webutil]

WebUtilArchive=frmwebutil.jar,jacob.jar

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm

archive=frmall.jar

lookAndFeel=oracle

[jnlp]

basejnlp=base.jnlp

baseHTMLjpi=basejpi_jnlp.htm

[webutil_jnlp]

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

basejnlp=webutil.jnlp

baseHTMLjpi=basejpi_jnlp.htm

lookAndFeel=oracle

[webstart]

basejnlp=base.jnlp

webstart=enabled

[webutil_webstart]

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

basejnlp=webutil.jnlp

webstart=enabled

[standaloneapp]

# Note: baseSAAfile must end with .txt

baseSAAfile=basesaa.txt

# fsalcheck parameter specifies whether to perform checksum comparison

# of Forms stand-alone app launcher or not. When it is enabled, it triggers

# the comparison at server. The checksum of FSAL at client machine will be

# compared with the checksum of FSAL archived at the server repository.

fsalcheck=true

[webutil_standaloneapp]

# Note: baseSAAfile must end with .txt

WebUtilArchive=frmwebutil.jar,jacob.jar

WebUtilLogging=off

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseSAAfile=webutilsaa.txt

fsalcheck=true

C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config\default.env:

# default.env - default Forms environment file, Windows version

#

# This file is used to set the Forms runtime environment parameters.

# If a parameter is not defined here, the value used will be that defined

# in the environment in which the WLS Managed Server was started.

#

# NOTES

#    Configuration assistant will replace all the macro's with

#    the actual values.

#

ORACLE_HOME=C:\Oracle12c\Middleware\Oracle_Home

FORMS_INSTANCE=C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\components\FORMS\instances\forms1

#

#

# TNS Entry to locate the database

#

TNS_ADMIN=C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig

#

#

# Search path for Forms applications (.fmx files, PL/SQL libraries)

#

FORMS_PATH=C:\Development\Oracle\Forms\FMX;C:\Development\Oracle\Forms\FMB;C:\Oracle12c\Middleware\Oracle_Home\forms;C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\components\FORMS\instances\forms1

#

#

# Disable/modify this variable if users need to be able to run Forms

# applications residing in a different location.

#

FORMS_MODULE_PATH=%FORMS_PATH%

#

#

# Webutil config file path

#

WEBUTIL_CONFIG=C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\components\FORMS\instances\forms1\server\webutil.cfg

#

#

# Disable/remove this variable if end-users need access to the query-where

# functionality which potentially allows them to enter arbitrary SQL

# statements when in enter-query mode.

#

FORMS_RESTRICT_ENTER_QUERY=TRUE

#

#

# Java class path

#   This is required for the Forms debugger

#   You can append your own Java code here)

#

# frmsrv.jar, frmconfig.jar and ldapjclnt11.jar are required for

# the password expiry feature to work(2213140).

#

CLASSPATH=C:\Oracle12c\Middleware\Oracle_Home\jlib\frmbipc.jar;C:\Oracle12c\Middleware\Oracle_Home\forms\j2ee\frmsrv.jar;C:\Oracle12c\Middleware\Oracle_Home\forms\provision\frmconfig.jar;C:\Oracle12c\Middleware\Oracle_Home\jlib\ldapjclnt11.jar;C:\Oracle12c\Middleware\Oracle_Home\jlib\debugger.jar;C:\Oracle12c\Middleware\Oracle_Home\oracle_common\jlib\ewt3.jar;C:\Oracle12c\Middleware\Oracle_Home\oracle_common\modules\oracle.bali.share\share.jar;C:\Oracle12c\Middleware\Oracle_Home\jlib\utj.jar;C:\Oracle12c\Middleware\Oracle_Home\jlib\zrclient.jar;C:\Oracle12c\Middleware\Oracle_Home\reports\jlib\rwrun.jar;C:\Oracle12c\Middleware\Oracle_Home\forms\java\frmwebutil.jar

#

#

# The PATH setting is required in order to pick up the JVM (jvm.dll and

# java.exe).

# Since PATH is being set, it needs to also include

# %ORACLE_HOME%\bin so relevant files are correctly found.

#

PATH=C:\Oracle12c\Middleware\Oracle_Home\bin;C:\Oracle12c\Middleware\Oracle_Home\oracle_common\jdk\jre\bin\client;C:\Oracle12c\Middleware\Oracle_Home\oracle_common\jdk\bin

#

#

# Settings for Forms tracing and logging

# -----------------------------------------------

# Note: By default tracing and logging directory is

# FORMS_INSTANCE\trace

# To change the trace directory this entry has to be uncommented and set to

# desired directory for tracing and logging

#

#

FORMS_TRACE_DIR=C:\Oracle12c\Middleware\FRS\Forms\Domain\config\fmwconfig\components\FORMS\instances\forms1\trace

#

#

# Settings for Javascript events

# -----------------------------------------------

# Note: If this variable is set to false then the triggers and

# built-ins associated with javascript events are disabled

#

#

#FORMS_ALLOW_JAVASCRIPT_EVENTS=

#

#

#

# System settings

# ---------------

# You should not normally need to modify these settings

#

FORMS=C:\Oracle12c\Middleware\Oracle_Home\forms