|
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 R12
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 R12 then
do the following
Step 1.
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 "Find". 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%20play=dummy.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
Note: In R12 we have to
specify the play=dummy.fdl option otherwise Oracle Forms will
not record any data.
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=recplay.fdl%20play=play.fdl
In the
above oracle will record in file
recplay.fdl
and the file it will play is
play.fdl
Step 2.
Create dummy.fdl
file (required in R12 only, not required in 11.5.10 or 11.5.9)
Go to {$INST_TOP/logs/ora/[FORMS Version Number]/forms}
directory and open the new file dummy.fdl in any text editor and write the following line
WINDOW FNDSCSGN
SIGNON_WINDOW ACTIVATE 1
For example if the mount point of
APPS_TIER is /u02/applmgr then
$cd /u02/applmgr/PROD/inst/apps/PROD_[hostname]/logs/ora/10.1.2/forms
$vi dummy.fdl
and write
the following line and save the file
WINDOW FNDSCSGN
SIGNON_WINDOW ACTIVATE 1
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.
A detail Step by Step Guide for enabling
Forms Record and Playback feature in R12
is also available
here
Step by Step Guide for loading data in
Oracle Apps R12
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
[playback]
code=oracle.forms.engine.MainRT
;# ********************
;# End customizations
;# ********************
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.
If you
are not seeing the recorded file in {$8.0.6_HOME}/forms60/log}
directory then please check the
following directory
$COMMON_TOP/admin/log/[Context_Name]
also, because sometimes Oracle will
create the recorded files here.
If you
are having problems in recording please
check the
Frequently Asked Questions section
for troubleshooting.
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
From Oracle Apps Ver. 11.5.10 by default
you cannot directly open forms without
going through sign-on pages. Oracle has done
this for more security however, If
you want to open forms directly then
please follow the given steps
1. Open the Application Context File $APPL_TOP/admin/<SID>_<hostname>.xml
2. Change the Context Variable
s_appserverid_authentication
from
SECURE
to
OFF
3. Run AutoConfig
|
