'Invalid column type' Displayed When Attempting To Load Files Containing Signed Packed Decimal Data Type In ODI (Doc ID 1968690.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.6.3 to 11.1.1.9.99 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When the below data-type columns are used in the flat files to load the data from the file to the oracle database in an interface an error occurs.

  1. UNSIGNED ZONED DECIMAL(Value 1234,12345678)
  2. SIGNED PACKED DECIMAL(Value 1234,12345678) 
  3. SIGNED ZONED DECIMAL(Value 1234,12345678) 

Used KMS:

LKM::LKM FILE to SQL 

IKM::IKM SQL CONTROL APPEND

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms