Common Problems
DataLoad has been tested on many different forms with varying sizes of data
loads. Thousands of records have been loaded in Oracle Applications in a single
load using this tool so it can be done!
This section documents a number of common problems, first with the Copy and
Paste functionality, then with the forms loading. If this doesn't help you
please look at the following next:
Frequently Asked Questions
Getting Support
Copy & Paste
- The most common problems encountered are usually resolved by changing or
adding delays. If spurious
errors occur, or keystrokes are being missed, insert or increase a delay,
using either a predefined DataLoad delay or *SLN in the data sheet.
Start with a large delay to determine if a pause helps. If it does,
gradually reduce the delay to the minimum that works. Delays have helped
when saving records, navigating into fields with pop lists, or when
activating a menu.
- When navigating into certain flexfields using DataLoad, the cursor may
skip the first field. This can be worked around, but test any scripts
thoroughly before running them with large amounts of data.
- Be careful when filling in a field with text that is shorter in length
than a default on the Oracle screen. For example, if the default is Expense
and you overwrite with Asset, the process might input Assetse. To avoid
this, append 2 spaces after the word Asset or use the *ST command before
sending the text.
- Navigating into a field containing a picklist in 10SC caused any entry in
that field to be highlighted. This does not happen in NCA, and a new command
has been added to help with this - '*ST'. *ST highlights the text in a
field, so that any input overwrites existing text rather than adding to it.
Forms Record and Playback
Forms record and playback is more dependent on Oracle software than is the
copy and paste functionality. This is because while DataLoad prepares the
playback file it is the Oracle Forms runtime than loads the file. The following
issues with the Oracle Forms runtime have been experienced:
- Forms 6i, 6.0.8.8 or 6.0.8.14.2, Applications 11.5.1. When playback
finishes the server process terminates, the client session disappears and
there maybe a FRM=92100 error in the Java console. The full text of the
error in the Java Console is a follows:
FRM-92100: Your connection to the server was
interrupted.
java.io.EOFException
at java.io.DataInputStream.readUnsignedByte(Compiled Code)
at oracle.forms.engine.Message.readDetails(Compiled Code)
at oracle.forms.engine.Message.readDetails(Compiled Code)
at oracle.forms.net.StreamMessageReader.run(Compiled Code)
This issue is fixed by recording the forms session at the same time as
running the playback. See the Setup
page for information on using the record and play parameters at the same time.
- Forms 6i, patch 5a, 6.0.8.14.2, Applications 11.5.1. If there is a resize
command for the Navigator window then a playback will stop at that point
with the following error message - "FRM-41096 Cannot resize view:
Invalid Size". Commands such as the following cause this error and
should be manually removed from the forms load file:
WINDOW FNDSCSGN NAVIGATOR RESIZE 5900 4500 1
- Forms 4.5, Patch 16. The record functionality does not work correctly in
patch 16. The file produced is missing the first keyword on each line, thus
rendering the file useless. This behaviour has been seen on Windows NT and
2000 servers, but may affect other platforms.