My Oracle Support Banner

French Characters Causing Length Issues (Doc ID 2403342.1)

Last updated on AUGUST 16, 2018

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.0.3 and later
Information in this document applies to any platform.

Symptoms

 When data with French characters is loaded into a mapping table to table throws an error that the length exceeds maximum value although the data is less than maximum value

Changes

Data was loaded into the TPARM_DERI_DSC_TRX mapping table via excel upload. The maximum length of column VAL_CORR_CIBL_1 in the excel upload file was 96 (using french characters). When the batch is executed the connector fails with error ORA-12899: value too large for column "ATOMIC"."C$_3I_6817_FILTER"."VAL_CORR_CIBL_1" (actual: 101, maximum: 100). If I load a record with the same length of 96 with no french characters I do not get the error

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!


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