OBIA 11g: SDE_PSFT_90_ADAPTOR_SDE_PSFT_SIASCHOLARDIMENSION Failed With "ORA-12899: Value Too Large For Column" (Doc ID 2379847.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
SDE_PSFT_90_ADAPTOR_SDE_PSFT_SIASCHOLARDIMENSION failed with following error.

Error
=================================
Caused By: java.sql.SQLException: ORA-12899: value too large for column
"OBIA_DW"."W_SIA_SCHOLAR_DS"."GENDER_CODE" (actual: 14, maximum: 1)

Column length
=================================

"OBIA_DW"."W_SIA_SCHOLAR_DS"."GENDER_CODE" is Varchar2(1)

Code needs to be corrected.
=================================
The source have 1 character. The problem is in the source query assigning
'_UNASSIGNED_' to null character causing the field to be bigger than 1.

This is where the problem is. Is replacing '__UNASSIGNED__' to where the
data is null that's why is greater than one character.

COALESCE(RTRIM(SQ_PERSONAL_DATA.SEX),'__UNASSIGNED__') C6_GENDER_CODE,

Changes

Cause

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