My Oracle Support Banner

PostgreSQL Columns of Data Type "Time" Show no Data in ODI (Doc ID 2707104.1)

Last updated on SEPTEMBER 02, 2020

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


After following Document 424012.1 "How Can I Define (New) Datatypes in ODI Topology", and adding the data type "time" in PostgreSQL technology the PostgreSQL columns with data type "time" are reverse engineered properly in Oracle Data Integrator (ODI) 12c.

However, when trying to view the content of PostgreSQL tables in ODI, the columns with data type "time" show no data, even though at PostgreSQL database level there are data in these columns.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.