Setting Up Oracle Forms Record
and Playback feature.
Oracle Forms supports record and
playback feature. This feature is available in every version of
Oracle Forms. When you run Oracle Forms in record mode. Oracle
Forms Records every keystroke and mouse clicks and writes
everything in a file specified by you. When you want to
repeat the recorded activity in another system run the Oracle
Forms in Playback mode specifying the file and the forms will do
whatever is specified in the file.
For Example if you enter a
Purchase Order in order entry system while in record mode. If
you want to re-enter this purchase order in another system, just
playback that file in another system and then that purchase
order is loaded into second system.
The following steps shows how to
enable record and playback feature in Oracle Forms.
Configuring Oracle
Forms to run in Record and Play Mode
For Oracle Apps Release
12i
For Oracle Apps Release
11.5.9 to 11.5.10
For Oracle Apps Release
11.5.1 to 11.5.8
If you are using
Oracle Apps Release 12i then do the following
Step 1.
To enable Forms for
recording you have to make changes to the Forms
Configuration file
appsweb.cfg located in
$OA_HTML/bin
directory. Make a backup of the file before editing it.
For example if the mount
point of APPS_TIER is
/u02/applmgr then the
appsweb.cfg
file will be located in
/u02/applmgr/PROD/apps/apps_st/comn/webapps/oacore/html/bin
Open the Forms
Configuration file (appsweb.cfg) and enter the
following code at the end of the file in Customizations
Section as shown below

If
$OA_HTML/bin/appsweb_{$ORACLE_SID}_{$HOSTNAME}.cfg
also exist then edit this file also and make the same
changes as you have done in
appsweb.cfg. It is always
better to make a backup before editing the file.
After making the changes
save the file.
Step 2.
Next, you have to edit
the ICX:Forms Launcher Profile setting.
To do this login as sysadmin and navigate to
/Profiles/System menu and then select the profile
ICX:Forms Launcher and username, for whom you want to
turn on recording, and click OK. Then you will get a
window showing this profile setting at Site Level,
Responsibility Level, Application Level and User Level.
The Site Level Profile option will
already contain a value which is used to launch forms.
Now to turn on recording at user level copy this value
from Site Level Profile option to User Level profile
option and append the "record=" option at the end of
the value as shown below
If Forms Server is running
in Unix:
Before Edit:
http://host.domainname:port/forms/frmservlet
After Edit
http://host.domainname:port/forms/frmservlet?record=myrecord.fdl
This will make forms
record all the keystrokes in the file "myrecord.fdl"
in the default location {$INST_TOP/logs/ora/[FORMS
Version Number]/forms}
directory. For example if the mount point of APPS_TIER
is /u02/applmgr then the recorded files will be located
in the following directory
/u02/applmgr/PROD/inst/apps/PROD_[hostname]/logs/ora/10.1.2/forms
Important Note :
Edit the profile setting
at Site Level or Application Level or User Level
depending upon which level you want to enable
recording. We recommend to turn on recording at user
level for the user who will be running the load.
It is
recommended that you create special user accounts for
recording and playback for example you create user
account with appropriate responsibilities like this
SAMRECORD
: For recording purpose
SAMPLAY : For Playback
purpose
Then you edit the
ICX:Forms Launcher
Profile option with "record="
at SAMRECORD user level and "play="
option at SAMPLAY user level. Instead of setting the
record and playback option at site level.
For Playback
Edit the Profile Option as below
Oracle
Forms can Record and Playback at the same time. This is
good for knowing how much data Oracle forms has
processed while playing the file. Remember always
mention different filenames for recording and playback
otherwise, Oracle Forms will overwrite the play file and
the load will get struck
For Record and
Playback in Unix
http://host.domain:port/forms/frmservlet?record=rec.fdl%20play=myplay.fdl
In the above oracle will
record in file
rec.fdl and the file
it will play is
myplay.fdl
That's it, now oracle
forms will record all keystrokes and mouse clicks
whenever you log in to a user account for whom you
mention on record= option in profile setting.
If you are using
Oracle Apps Release 11.5.9 / 11.5.10 then do the following
Step 1.
To enable Forms for
recording you have to make changes to the Forms
Configuration file
appsweb.cfg located in
$OA_HTML/bin
directory. Make a backup of the file before editing it.
Open the Forms
Configuration file (appsweb.cfg) and enter the
following code at the end of the file in Customizations
Section as shown below

If
$OA_HTML/bin/appsweb_{$ORACLE_SID}_{$HOSTNAME}.cfg
also exist then edit this file also and make the same
changes as you have done in
appsweb.cfg. It is always
better to make a backup before editing the file.
After making the changes
save the file.
Step 2.
Next, you have to edit
the ICX:Forms Launcher Profile setting.
To do this login as sysadmin and navigate to
/Profiles/System menu and then select the profile
ICX:Forms Launcher and username, for whom you want to
turn on recording, and click OK. Then you will get a
window showing this profile setting at Site Level,
Responsibility Level, Application Level and User Level.
The Site Level Profile option will
already contain a value which is used to launch forms.
Now to turn on recording at user level copy this value
from Site Level Profile option to User Level profile
option and append the "record=" option at the end of
the value as shown below
If Forms Server is running
in Unix:
Before Edit:
http://host.domainname:port/dev60cgi/f60cgi
After Edit
http://host.domainname:port/dev60cgi/f60cgi?record=myrecord.fdl
If Forms Server is running
in Windows:
Before Edit:
http://host.domainname:port/dev60cgi/ifcgi60.exe
After Edit
http://host.domain:port/dev60cgi/ifcgi60.exe?record=myrecord.fdl
This will make forms
record all the keystrokes in the file "myrecord.fdl"
in the default location {$8.0.6_HOME}/forms60/log}
directory in Unix and {$8.0.6_HOME/forms60/bin}
directory in Windows.
Important Note :
Edit the profile setting
at Site Level or Application Level or User Level
depending upon which level you want to enable
recording. We recommend to turn on recording at user
level for the user who will be running the load.
It is
recommended that you create special user accounts for
recording and playback for example you create user
account with appropriate responsibilities like this
SAMRECORD
: For recording purpose
SAMPLAY : For Playback
purpose
Then you edit the
ICX:Forms Launcher
Profile option with "record="
at SAMRECORD user level and "play="
option at SAMPLAY user level. Instead of setting the
record and playback option at site level.
For Playback
Edit the Profile Option as below
Oracle
Forms can Record and Playback at the same time. This is
good for knowing how much data Oracle forms has
processed while playing the file. Remember always
mention different filenames for recording and playback
otherwise, Oracle Forms will overwrite the play file and
the load will get struck
For Record and
Playback in Unix
http://host.domain:port/dev60cgi/f60cgi?record=rec.fdl%20play=myplay.fdl
For Record and
Playback in Windows
http://host.domain:port/dev60cgi/ifcgi60.exe?record=rec.fdl%20play=myplay.fdl
In the above oracle will
record in file
rec.fdl and the file
it will play is
myplay.fdl
That's it, now oracle
forms will record all keystrokes and mouse clicks
whenever you log in to a user account for whom you
mention on record= option in profile setting.
If you are using
Oracle Apps Release 11.5.1 to 11.5.8 then do the following
Edit
the ICX:Forms Launcher Profile setting.
To do this login as sysadmin and navigate to
/Profiles/System menu and then select the profile ICX:Forms
Launcher and username, for whom you want to turn on
recording, and click OK.
Then you will get a window
showing this profile setting at Site Level, Responsibility
Level, Application Level and User Level. The Site Level
Profile option will
already contain a value which is used to launch forms.
Now to turn on recording at
user level copy this value from Site Level Profile option to
User Level profile option and append the "record=" option at the end of
the value as shown below
If Forms Server is running
in Unix:
Before Edit:
http://host.domainname:port/dev60cgi/f60cgi
After Edit
http://host.domainname:port/dev60cgi/f60cgi?record=myrecord.fdl
If Forms Server is running
in Windows:
Before Edit:
http://host.domainname:port/dev60cgi/ifcgi60.exe
After Edit
http://host.domain:port/dev60cgi/ifcgi60.exe?record=myrecord.fdl
This will make forms
record all the keystrokes in the file "myrecord.fdl"
in the default location {$8.0.6_HOME}/forms60/log}
directory in Unix and {$8.0.6_HOME/forms60/bin}
directory in Windows.
Important Note :
Edit the profile setting
at Site Level or Application Level or User Level
depending upon which level you want to enable
recording. We recommend to turn on recording at user
level for the user who will be running the load.
We recommend
that you create special user accounts for recording and
playback for example you create user account with
appropriate responsibilities like this
SAMRECORD :
For recording purpose
SAMPLAY : For Playback purpose
Then
you edit the
ICX:Forms Launcher
Profile option with "record="
at SAMRECORD user level and "play="
option at SAMPLAY user level. Instead of setting the record
and playback option at site level.
For Playback Edit
the Profile Option as below
Oracle Forms can Record and
Playback at the same time. This is good for knowing how much
data Oracle forms has processed while playing the file.
Remember always mention different filenames for recording
and playback otherwise, Oracle Forms will overwrite the play
file and the load will get struck
For Record and Playback in
Unix
http://host.domain:port/
dev60cgi/f60cgi?record=rec.fdl
20play=myplay.fdl&code=oracle.forms.engine.MainRT
The above must be typed in
one line without any spaces and last part of the line should
look like
...f60cgi?record=rec.fdl%20play=myplay.fdl&code=oracle.forms.engine.MainRT
For Record and Playback in
Windows
http://host.domain:port
/dev60cgi/ifcgi60.exe?record=rec.fdl%20
play=myplay.fdl&code=oracle.forms.engine.MainRT
The above must be typed in
one line without any spaces and last part of the line should
look like
...ifcgi60.exe?record=rec.fdl%20play=myplay.fdl&code=oracle.forms.engine.MainRT
In the above oracle will
record in file
rec.fdl and the file it
will play is
myplay.fdl
That's it, now oracle forms
will record all keystrokes and mouse clicks whenever you log
in to a user account for whom you mention on record= option
in profile setting.
Note:
If you can
directly open forms without going through sign-on pages then
you can type the record and play file in the address itself
like for example
In
UNIX:
http://host.domain:port/dev60cgi/f60cgi?record=rec.fdl%20play=myplay.fdl
In
Windows
http://host.domain:port/dev60cgi/ifcgi60.exe?record=rec.fdl%20play=myplay.fdl