SAP Replication Server and Replication Agent impose some constraints on the Oracle NUMBER datatype.
See the SAP Replication Server Options Release Bulletin for the latest information on datatype restrictions.
The corresponding SAP int datatype has a smaller absolute maximum value.
The Oracle NUMBER absolute maximum value is 38 digits of precision, between 9.9 x 10125 and 1 x 10-130. The SAP int value is between 231 - 1 and -231 (2,147,483,647 and -2,147,483,648), inclusive.
Oracle NUMBER values greater than the SAP int maximum are rejected by SAP Replication Server.
The precision of the floating point representation has the same range limitation as the integer representation.
If the floating point value is outside the SAP range of 231 - 1 and -231 (2,147,483,647 and -2,147,483,648), Replication Agent for Oracle converts the number into exponential format to make it compatible with SAP Replication Server. No loss of precision or scale occurs.
SAP Replication Server and Replication Agent impose these constraints on the Oracle TIMESTAMP WITH [LOCAL] TIME ZONE datatype.
When a TIMESTAMP WITH TIME ZONE datatype is replicated, the time zone information is used to resolve the timestamp value to the “local” time zone and then the resolved value is replicated. The time zone information itself is not replicated.
For example, if a TIMESTAMP WITH TIME ZONE datatype is recorded in Oracle as “01-JAN-05 09:00:00.000000 AM -8:00” and the “local” time zone is -6:00, the replicated value is “01-JAN-05 11:00:00.000000”. The timestamp value is adjusted for the difference between the recorded time zone of -8:00 and the local time zone of -6:00, and the adjusted value is replicated.