DataLoad
Background
Overview
Setup
Create a Load - 1
Create a Load - 2
The "Rules"
Editing a Load
Running the Load
Testing the Load
Character Sets

User Guide Home
DataLoad Home

 

Oracle Forms Playback Advanced Setup

This page provides additional setup details for more advanced aspects of Oracle Forms Playback configuration.

Changing the Default Directory with Forms 6.0.8.25.2+

These steps must be performed by an Oracle Applications DBA or someone with a similar level of technical knowledge and server access.

Oracle Forms version 6.0.8.25.2 and higher will only record to and play from a single directory. By default that is one of the following locations on the application server:

$ORACLE_HOME/forms60/log (This is the 8.0.6 Oracle Home).

$COMMON_TOP/admin/log/[Context Name]

The directory used will depend on the patch level of Oracle E-Business Suite.

If the following environment variable is set Oracle will use the directory set in this variable for forms playback files instead of the default location:

$FORMS60_TRACE_PATH

Oracle Applications systems with high enough patch levels of AutoConfig template files can control this variable through AutoConfig. The following value should be edited in the system's XML context file to set the FORMS60_TRACE_PATH value to the directory you wish to use for forms playback files:

forms_trace_path

After changing this value in the context file you must run AutoConfig and restart the forms server for this change to take effect.

Changing the Default Directory with R12

These steps must be performed by an Oracle Applications DBA or someone with a similar level of technical knowledge and server access.

Oracle E-Business R12 will only record to and play from a single directory. By default that is the following location on the application server:

$INST_TOP/logs/ora/[Oracle Forms Version]/forms

The following environment variable controls the directory Oracle uses for forms playback files:

$FORMS_TRACE_DIR

You may change this variable and hence the location used for record and playback files through E-Business AutoConfig. The E-Business system's XML context file must be edited to set the FORMS_TRACE_DIR value to the directory you wish to use for forms playback files. This XML file will be named and located as follows:

$INST_TOP/appl/admin/[SERVER_SID].xml

The value of the following entry should be changed to hold the directory path to be used for forms playback files:

forms_trace_dir

After changing this value in the context file you must run AutoConfig and restart the forms server for this change to take effect.

Alternatives for Controlling Record & Playback Sessions

The instructions for configuring forms playback with the ICX: Forms Launcher profile option recommends the use of two dedicated Oracle Applications users, one which will start a recording session and another which starts a playback session. Each user who need to use forms playback could have their own record and playback logins or generic record/playback logins can be used and shared among multiple users. Shared, generic record and playback Oracle users provide the simplest way to control record and playback but accountability is lost - as with any generic login - and multiple users must co-ordinate their use of a generic login to ensure two users do not record to or play from the same file at the same time.

The ICX: Forms Launcher profile option value can be set at various levels. An an alterative to setting this level for each user it can be set at Responsibility level. A recording or playback Responsibility can be created and assigned the appropriate ICX: Forms Launcher profile option value. The drawback of this option is that only one user should use a particular recording or playback Responsibility at one time otherwise multiple users will record to or play from the same file.

Another option is to use a single Oracle user with an ICX: Forms Launcher profile option value that is configured for record and playback. The forms behaviour is controlled by changing files on the application server. The following is an example of a playback value for ICX: Forms Launcher (11.5.10 syntax):

http://host.domain:port/dev60cgi/f60cgi?record=record.fld%20play=play.fld&config=playback

Normally this value would be used for the Oracle user configured for playback. However, if the play.fld file on the server doesn't exist, or is empty, then the Oracle behaviour changes. There are 3 options:

play.fld doesn't exist - No playback will occur (obviously) and no file will be recorded. Oracle will behave "normally".
play.fld is empty - Where play.fld exists, but is an empty file, no playback will occur but the Oracle session will be recorded to record.fld.
play.fld is a normal playback file - Playback will occur.

Thus whether play.fld doesn't exist, exists but is empty, or is a valid playback file controls whether recording, playback or neither occurs. An Oracle user can have a playback value in ICX: Forms Launcher and control whether their Oracle session is a "normal", recording or playback session through the play.fld file, so no additional record/playback users or Responsibilities are required. This is a useful technique but only appropriate for users confident to switch between different play.fld files as required.

If the alternatives for using the ICX: Forms Launcher profile are not suitable, launching Oracle Forms directly should be investigated because this does not require multiple Oracle users (or Responsibilities) and the record and playback behaviour is changed through URL parameters.

Forms Playback and Load Balanced Systems

An Oracle environment that uses multiple load balanced application servers presents additional issues for forms playback users. This is because it is impossible to know which server a file will be recorded to or to which server a playback file should be copied for playback. That is because the user's Oracle Forms session could run on any of the application servers. There are two common ways to handle load balanced application servers.

By-pass Load Balancing The easiest option is to by-pass load balancing altogether. The way to do this will depend on how load balancing had been implemented, but the objective is to directly access one of the application servers to guarantee that application server will be used. The user will then known on which server the forms playback file will be created and to which server the playback file should be copied.

Shared Disk Location This is the more elegant solution because it works with load balancing. A shared disk location must be setup that can be accessed from every application server, EG via NFS. Furthermore, the directory path to this shared area must be the same on every server. For example, each application server could have a directory called "/home/oracle/dataload" that points to a common disk area. With this setup the user can be sure Oracle will record form playback files to this common area and playback files should be copied to this location. When a playback session is started it will access the common disk area and find the playback file, regardless of which sever is hosting the user's Oracle session.