Why does the load always fail after a certain number of records?
A. Some loads will work perfectly for relatively small loads but fail for larger loads and the error will often occur after the same number of errors on every load. When the load fails there is often a form error but other errors may be reported. This is usually caused by a bug in the particular form or the forms runtime software. That bug usually affects all data entry, i.e. both data entered manually by users and DataLoad loads, but it is only apparent with DataLoad loads because the users do not manually load such high data volumes. The solution to this problem is usually to patch or upgrade the form or forms software, or both. If possible the problem should be reproduced with a user manually entering the volume of data where the problem occurs. The issue can then be reported to Oracle Support and because it has been reproduced by a user the issue is definitely an Oracle rather than DataLoad problem.
