Setting Up Oracle Forms Record and Playback

Oracle Apps Release R12

1Edit the ICX:Forms Launcher Profile

Login as Sysadmin and navigate to Profiles > System, then select the profile ICX:Forms Launcher and the username for whom you want to turn on recording, and click "Find". You'll see this profile setting at Site Level, Responsibility Level, Application Level, and User Level. The Site Level Profile option already contains a value used to launch forms. To turn on recording at the user level, copy this value from the Site Level Profile option to the User Level profile option and append the "record=" option at the end, as shown below.

If Forms Server is running in Unix:

Before Edit:

After Edit:

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. For example, if the mount point of APPS_TIER is /u02/applmgr, the recorded files will be located at:

In Oracle EBS R12.2.3 / R12.2.4 the files will be located at:

Note: In R12 you have to specify the play=dummy.fdl option, otherwise Oracle Forms will not record any data.

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

In the above, Oracle will record in the file recplay.fdl and the file it will play is play.fdl.

2Create dummy.fdl File (R12 only — not required in 11.5.9 / 11.5.10)

Go to the $INST_TOP/logs/ora/[FORMS Version Number]/forms directory and open a new file dummy.fdl in any text editor, and write the following line:

For example, if the mount point of APPS_TIER is /u02/applmgr:

Write the following line and save the file:

In Oracle EBS R12.2.3 / R12.2.4 the dummy.fdl should be located here (assuming /u02/applmgr is the mount point):

That's it — now Oracle Forms will record all keystrokes and mouse clicks whenever you log in to a user account for whom you specified the record= option in the profile setting.

A detailed step by step guide for enabling Forms Record and Playback 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

Oracle Apps Release 11.5.9 / 11.5.10

1Edit the Forms Configuration File

To enable Forms for recording, you have to make changes to the Forms Configuration file appsweb.cfg, located in the $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 the Customizations section, as shown below:

If $OA_HTML/bin/appsweb_{$ORACLE_SID}_{$HOSTNAME}.cfg also exists, edit this file too and make the same changes as in appsweb.cfg. It's always better to make a backup before editing.

After making the changes, save the file.

2Edit the ICX:Forms Launcher Profile

Login as sysadmin and navigate to Profiles > System, then select the profile ICX:Forms Launcher and the username for whom you want to turn on recording, and click OK. You'll see this profile setting at Site Level, Responsibility Level, Application Level, and User Level. The Site Level Profile option already contains a value used to launch forms. To turn on recording at the user level, copy this value from Site Level to User Level and append "record=" at the end, as shown below.

If Forms Server is running in Unix:

Before Edit:

After Edit:

If Forms Server is running in Windows:

Before Edit:

After Edit:

This will make Forms record all 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 in Windows.

If you don't see the recorded file in that location, also check $COMMON_TOP/admin/log/[Context_Name] — Oracle sometimes creates recorded files there.

If you're having problems recording, please check the Frequently Asked Questions section for troubleshooting.

For Playback, Edit the Profile Option as Below

Oracle Forms can record and playback at the same time. Always use 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

For Record and Playback in Windows

In the above, Oracle will record in the 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 mentioned the record= option in the profile setting.