JDE to VCP - 'ORA-12899: value too large for column' Error When Running Collect Planning Data Concurrent Request (Doc ID 2044826.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.1 and later
Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 11.1 or later PIP version,

JDE to VCP Issue With Special Characters in Customer.xml

When running Collect Planning Data the following error is returned:

ERROR
-----------------------

23-JUN 18:46:05 : ODI Scenario : LOADE1LOCASSOCIATIONDATATOAPSPKG FAILED. Session #: 1035003
23-JUN 18:46:05 : Error Message: ODI-1226: Step LocationAssociationsCustInterface fails after 1 attempt(s).
ODI-1240: Flow LocationAssociationsCustInterface fails while performing a Export operation. This flow loads target table MSC_ST_LOCATION_ASSOCIATIONS.
ODI-1228: Task LocationAssociationsCustInterface (Export) fails on the target ORACLE connection ASCPDS.
Caused By: java.sql.BatchUpdateException: ORA-12899: value too large for column "MSC"."C$_MSC_ST_LOCATION_ASSOCIATION"."TP_SITE_CODE" (actual: 32, maximum: 30)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
at oracle.odi.runtime.agent.execution.sql.BatchSQLCommand.execute(BatchSQLCommand.java:44)
at oracle.odi.runtime.agent.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot collect JDE data into VCP

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