QuercusPlus 8.0 Installation Guide<>

Appendix 3 — Quercus 8 embedded forms configuration

What are embedded forms?​

Embedded forms in the QuercusPlus Menu are one of the new features introduced in Quercus 8.

The feature allows you to configure forms to run in the same browser frame as the QuercusPlus Menu.

You can also configure a single sign-on — so that users do not have to enter credentials when they connect to the Classic Interface.

Configuration

QuercusLive Control Centre

There are three parameters in the Control Centre that determine how the embedded functionality works.

Parameter

Description

FORMS.INTEGRATION_ENABLED

This determines whether or not the QuercusPlus 8.0 Classic Interface will run in standalone or embedded mode.

FORMS.INTEGRATION_ENABLED = TRUE — will run in embedded mode

FORMS.INTEGRATION_ENABLED = FALSE — will run in standalone mode

FORMS.LAUNCH_URL

The URL used to launch QuercusPlus 8.0 Classic Interface.

If the application is hosted on a different server to the QuercusPlus installation you must enter the full URL (beginning http://)

The URL syntax is shown below:

http://<hostname>:<port>/forms/frmservlet?config=#CONFIG#&userid=#KEY_NAME#/#KEY_SECRET#@<database>

This is the standard URL to launch the Classic Interface application with the following substitution strings:

#CONFIG#

#KEY_NAME#

#KEY_SECRET#

For this to work individual users must enter their Classic Interface username and password in the MyProfile section in QuercusPlus Menu.

Example URL

http://cit-test11g-as:8090/forms/frmservlet?config=quercusplus&userid=#KEY_NAME#/#KEY_SECRET#@srslive

Notes

Their username and password are stored in the table QUERCUS.PERSON_KEY. The password is encrypted for security reasons. The username is passed as the #KEY_NAME# and the password is passed as the #KEY_SECRET# into the forms URL.

It is possible to have a combination of items 1 and 2 above whereby you have SSO enabled and integration disabled or vice versa.

FORMS.SSO_ENABLED

This determines whether or not single sign-on is enabled for QuercusPlus 8.0 Classic Interface. If single sign-on is enabled you can enter your sign-on credentials (user name and password) for forms using the SET CLASSIC CREDENTIALS option accessible through the My Profile link. Once you have done this, you will not have to re-enter your credentials each time you launch Classic Interface.

FORMS.SSO_ENABLED = TRUE — single sign-on is enabled

FORMS.SSO_ENABLED = FALSE — single sign-on is not enabled

Application server

A specific web forms configuration is required for the embedded forms. It is necessary to create a new environment in the file formsweb.cfg which can be found in $ORACLE_INSTANCE_HOME\config\FormsComponent\forms\html

Add the following to the end of the file:

[qp8_menu]

Can be named anything you want

baseHTML=webutilbase.htm

Required

baseHTMLjpi=webutiljpi.htm

Required

WebUtilArchive=frmwebutil.jar

Required

envfile=<environment_file>.env

Must be an existing environment file

form=quercusplus1_8.fmx

Must be a fmx used in QuercusPlus. In this example the menu form is used.

separateframe=false

width=900

Must be set to 900

height=700

Must be set to 700

splashScreen=http://<hostname>:<port>/forms/html/qp_splash.gif

Required

logo=http://<hostname>:<port>/forms/html/1px.gif

Required

colorscheme=blue

optional

Single sign-on for end-user

You can configure QuercusPlus 8.0 so that you do not need to enter your username and password each time you open Classic Interface — this is known as single sign-on.

If the parameter for single sign-on has been enabled then any QuercusPlus Menu user who has access to the Classic Interface has to update their profile adding their Classic Interface username and password. They can do this by logging into QuercusPlus Menu and going to My Profile.

To enable single sign-on

1Change the FORMS.SSO_ENABLED parameter to TRUE,

2Click the My Profile link at the top of the Quercus 8 page.

3In the TASKS links on the right of the page click SET CLASSIC CREDENTIALS.

4Enter your user name and password for Classic Interface and click Save.

Your Classic Interface credentials are encrypted and saved to the database in the table QUERCUS.KEY_STORE.

Smart Link

The Classic Interface is called through a Smart Link. By default the Classic Interface Smart Link is configured on the Home Page of the QuercusPlus Menu however you may want to configure extra Smart Links to bring up individual forms (separate configurations will be required in the formsweb.cfg file for separate forms). When creating the Smart Links it is important that you use the following URL format – watch out for typos!

f?p=QUERCUS:CLASSIC:&APP_SESSION.::::P20_CONFIG,P20_TITLE:<config_name>,QuercusPlus

Example

f?p=QUERCUS:CLASSIC:&APP_SESSION.::::P20_CONFIG,P20_TITLE:qp8_menu,QuercusPlus