'ORA-30088 Datetime/Interval Precision is Out of Range' Error while Loading Excel Datetime to Oracle Date in an ODI Interface (Doc ID 741294.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

When running an ODI Integration Interface that populates for example, an Oracle Date column with the value from an Excel Datetime column, the following message is signaled:

Cause

	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

Symptoms

Cause

Solution

Verify the Column attributes of target table

Verify the Column Converted to tab

Verify the Converted from tab

References

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

'ORA-30088 Datetime/Interval Precision is Out of Range' Error while Loading Excel Datetime to Oracle Date in an ODI Interface (Doc ID 741294.1)

Applies to:

Symptoms

Cause

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

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