2018485 - After Oracle "DATE" replicates to HANA "TIMESTAMP" the time is incorrect in HANA. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2018485 - After Oracle "DATE" replicates to HANA "TIMESTAMP" the time is incorrect in HANA.

Symptom

Oracle "DATE" datatypes  that are replicated to HANA "timestamp" datatypes are not showing the correct time in HANA. In the replication definition the "DATE" column is defined as an "rs_oracle_datetime" datatype.

For example: From Oracle when "May 5, 2014 10:34:12" is replicated to HANA,  the datetime value changed to "May 5, 2014 12:00:00".


Read more...

Environment

  • SAP Replication Server RS 15.7.1 SP100 and UP
  • SAP Replication Server Option for Oracle 15.7 and UP

Product

SAP Replication Server 15.7 ; SAP Replication Server, heterogeneous edition all versions

Keywords

 HANA timestamp, Oracle date, ExpressConnect for SAP HANA Database(ech) , KBA , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.