My Oracle Support Banner

OBIA 11g:FA13-1901: value too large for column "<SDS_FUSION_11_SCHEMA>"."FSC_PR_STNDRDDSTRBBTNPV92047"."PRCHSNGDCMNTLNVNDRPRD535168123" (actual: 39, maximum: 25) (Doc ID 2507370.1)

Last updated on AUGUST 16, 2019

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

Multiple fails in ETL (due to issues with column sizes on OOB ERR )

value too large for column "<SDS_FUSION_11_SCHEMA>"."FSC_PR_STNDRDDSTRBBTNPV92047"."PRCHSNGDCMNTLNVNDRPRD535168123" (actual: 39, maximum: 25)

ODI-1227: Task
FTS_FUSION_FscmTopModelAM.PrcPorPublicViewAM.RequisitionDistributionP1 (Integration) fails on the source ORACLE connection SDS_FUSION_10.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "<SDS_FUSION_10_SCHEMA>"."FSC_PR_RQSTNDSTRBTBTNP1594761"."PRCHSNGDCMNTLNVNDRPRD5
35168123" (actual: 214, maximum: 200)

ODI-1227: Task
FTS_FUSION_FscmTopModelAM.PrcPoPublicViewAM.StandardDistributionPVO (Integration) fails on the source ORACLE connection SDS_FUSION_10.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "<SDS_FUSION_10_SCHEMA>"."FSC_PR_STNDRDDSTRBBTNPV92047"."PRCHSNGDCMNTLNVNDRPRD53
5168123" (actual: 214, maximum: 200)

ODI-1227: Task
FTS_FUSION_FscmTopModelAM.PrcPorPublicViewAM.RequisitionDistributionP1 (Integration) fails on the source ORACLE connection SDS_FUSION_10.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "<SDS_FUSION_10_SCHEMA>"."FSC_PR_RQSTNDSTRBTBTNP1594761"."PRCHSNGDCMNTLNVNDRPRD5
35168123" (actual: 214, maximum: 200)

ODI-1227: Task FTS_FUSION_FscmTopModelAM.PrcPorPublicViewAM.RequisitionLineP1 (Integration) fails on the source ORACLE connection SDS_FUSION_10.
Caused By: java.sql.SQLException: ORA-12899: value too large for column "<SDS_FUSION_10_SCHEMA>"."FSC_PR_REQUISITIONLINEP1743890"."PRCHSNGDCMNTLNVNDRPRD
535168123" (actual: 214, maximum: 200)

 

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References

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