ORA-12899: value too large for column "MSC"."MSC_ST_VISITS"."VISIT_DESC" error running Planning Data Pull when collecting CMRO data.

(Doc ID 2133166.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Data Collections fails during Planning Data Pull with error:

ERROR
-----------------------
19-APR 11:52:31 : Error_Stack...
19-APR 11:52:31 : ORA-12899: value too large for column "MSC"."MSC_ST_VISITS"."VISIT_DESC" (actual: 256, maximum: 240)

19-APR 11:52:31 : Error_Backtrace...
19-APR 11:52:31 : ORA-06512: at "APPS.MSC_CL_PULL", line 7028
ORA-06512: at "APPS.MSC_CL_PULL", line 1815




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