My Oracle Support Banner

'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.