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.
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
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
In Oracle EBS R12.2.3 / R12.2.4 the files will be located in the following directory
/u02/applmgr/VIS/fs1/inst/apps/VIS_[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
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
In Oracle EBS R12.2.3 / R12.2.4 the dummy.fdl should be located in the following directory, assuming "/u02/applmgr" is mount point
/u02/applmgr/VIS/fs1/inst/apps/VIS_[hostname]/logs/ora/10.1.2/forms
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.
Step by Step Guide for loading data in Oracle Apps R12
Step by Step Guide on Setting up Forms Record and Playback in Oracle EBS R12.2.4
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.
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 stuck
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.
Note: In Oracle Apps Rel 11.5.10.2 you must have to specify record option along with play option for playing a file. Otherwise no playback will occur.
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
© Interface Computers All Rights Reserved