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 APRIL 04, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

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,

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