[DataDirect][ODBC Oracle Wire Protocol driver]Fractional truncation. Error in parameter <number>.
The database driver issues a warning message if a replication task replicates all Salesforce objects and tries to write a null value to a numeric field of an Oracle database.
An error message appears while configuring the target for the replication task.
You cannot configure multiple replication tasks to replicate the same source object to the same target object.
For example, you cannot configure two replication tasks to write Salesforce Account data to the SF_ACCOUNT Oracle database table. An error appears when you select the same target connection and target object that is used by another replication task.
If you replicate specific objects for the source connection, the following error appears: Duplicate replication task for <object name> object with a target prefix of <target prefix>.
An error occurs when you run two replication tasks to replicate two objects whose target prefixed name is the same. You must change the target connection, enter a different target prefix or remove the object from the task.
To write data from sources with the same name to different target objects in the same target connection, you must configure different target prefixes.
If you replicate all objects for the source connection, the following error appears: Duplicate replication task.
An error occurs when you run two replication tasks to replicate the same object from the same source to the same target with the same target prefix. You must change the target or enter a different target prefix.
Numeric data is loaded incorrectly when you run a replication task that writes Oracle data to a flat file.
When a replication task writes Oracle data with the Number data type to a flat file with the scale as 0, the number is rounded with a precision of 15. The replication application converts the Number data type to Double (15).
To prevent rounding, specify a scale other than 0 for the source data type. When you specify a non-zero scale, rounding will not occur because the replication application converts the Number data type to Decimal.