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

 

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

 

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

 

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.

 

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

 

Step by Step Guide on Setting up  Forms Record and Playback in Oracle EBS R12.2.4

 

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 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.

 

 

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

 

 

 

 

Contact Us

Products
Support

Interface Computers © 2005-2015 All Rights Reserved