Teradata Decimal Datatype Has Incorrect Length in ODI 12c Causing "Numeric Overflow" Error
(Doc ID 2907808.1)
Last updated on NOVEMBER 09, 2022
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
After migrating from Oracle Data Integrator (ODI) 11g to ODI 184.108.40.206, some mappings which had no issues in 11g fail during execution with the following error:
The issue occurs on Teradata data stores if receiving numeric data larger than DECIMAL(18,10)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!