OBIA 11g: SDE_ORAR122_ADAPTOR_SDE_ORA_PROJECTCLASSIFICATION Fails with 'ORA-12899: value too large for column "DW"."W_PROJ_CLASSIFICATION_DS"."INTEGRATION_ID" '

(Doc ID 2158811.1)

Last updated on MAY 01, 2018

Applies to:

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

Symptoms

On OBIA 11.1.1.10.1 Load Plan Fails for SDE_ORAR122_ADAPTOR_SDE_ORA_PROJECTCLASSIFICATION

The integration_id column is defined as 80 characters in the DB, but the concatenated string is larger, and the code is pulling from a combination of fields that are 105 characters total without any substring.

 

Changes

 

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