DataLoad
Background
Overview
Setup
Create a Load - 1
Create a Load - 2
The "Rules"
Editing a Load
Running the Load
Testing the Load
Character Sets

User Guide Home
DataLoad Home

 

DataLoad User Guide
Please read and apply the relevant instructions before using forms playback.
This page is regularly updated, please check the web site version for latest changes.

Oracle Forms Playback - Setup

Before Oracle E-Business Suite sessions can be recorded or the DataLoad file played back, some setup is required.

For legacy instructions relating to Oracle E-Business 10.7/11.0.x please click here, otherwise continue with the instructions below.

Oracle E-Business Suite 11i & R12 Setup

These instructions assume you access Oracle E-Business Suite using the "E-Business Suite Home page". That is the method most users are familiar with and also makes controlling record and playback easier. If you do access Oracle Forms directly, i.e. by-passing the E-Business Suite Home Page, the URL you use to launch forms must be changed to start a recording or playback session. That method of launching E-Business Suite is described here. Accessing forms directly is also useful for scheduling a playback or launching it from a batch file.

The easiest way to control the recording or playback of a Forms Playback load is with a standard Oracle E-Business Suite profile option called 'ICX: Forms launcher'. By default, this profile only has a value at Site level and that value does not enable recording or playback. The profile option value is changed to turn on either recording or playback.

The profile option should not be changed at Site level because then all sessions will record to or playback from the same file. The best approach is to set this profile at User level so the forms playback activity can be easily controlled. A user will record, playback or do neither in their E-Business Suite session depending on how this profile value is set for that user. The value for a user could be changed as required, however if a user will regularly record to and/or playback from files then it may be worth setting up extra logins specifically for recording and playback and leaving the profile option set appropriately. That means the profile option does not need to be changed when the user wants to playback, record or do neither.

For example, a user 'John Smith', whose login name is 'jsmith', may want to regularly run record or playback sessions. To achieve this the following logins could be used:-

jsmith - Normal login with no recording or playback. Profile option should not be changed from the current, default value.
jsmithrec - Login that will cause a file to be recorded. Set the ICX: Forms Launcher profile option at user level to to record a file.
jsmithplay - Login that will cause playback to occur. Set the ICX: Forms Launcher profile option at user level for forms playback.

Now whenever John Smith wants to record or play a file he can make this happen by logging in to Oracle with the appropriate sign-on. Some organisations do not allow users to have multiple accounts. In that case it may be appropriate to change the ICX: Forms Launcher profile option value for that user whenever they wish to record or playback a file. DataLoad Support can provide more assistance about controlling record and playback if that is required.

Profile option values are cached in Oracle E-Business Suite, which means changing the value might not take immediate effect. In 11i it is sufficient to logoff and logon again to activate a profile value change. In R12 it may be necessary to clear the profile option cache and this should be done whenever you change the profile value. This is especially important if your profile values are frequently changed, for example if you use a single user account for record, playback and your normal work. The cache may be cleared in the "Functional Administrator" Responsibility by navigating to the following form:

Core Services -> Caching Framework -> Tuning

In that form you should query back and select the cache object called PROFILE_OPTION_VALUE_CACHE and click the Clear Cache button.

Using the ICX: Forms Launcher profile option is just one method for controlling record and playback; alternative options for controlling record and playback are documented on the advanced setup page.

Before using Forms Playback you should also check that the DataLoad character set is compatible with the character set used in your Oracle database. Click here to setup the character set.

Setup Details

The setup requirements differ between different versions of Oracle E-Business Suite and Oracle Forms. Please select the link below which is appropriate for your system. To identify the version of Oracle E-Business Suite and Oracle Forms select "About Oracle Applications " from the Oracle E-Business "Help" menu or ask your Oracle DBA. If your Oracle system uses load balanced application servers you should also review the load balanced section on the advanced setup page in addition to the setup instructions specific to your system.

Oracle E-Business 11.5.1 to 11.5.8 with Oracle Forms prior to 6.0.8.25.2

Oracle E-Business 11.5.1 to 11.5.8 with Oracle Forms 6.0.8.25.2 or higher

Oracle E-Business 11.5.9 with Oracle Forms prior to 6.0.8.25.2

Oracle E-Business 11.5.9 with Oracle Forms 6.0.8.25.2 or higher

Oracle E-Business 11.5.10

Oracle E-Business R12