Planning Data Pull Worker Completing With ORA-12899 Error Due To Visit Name Too Large (Doc ID 1663045.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Data Collections

When attempting to run complete refresh data collections after applying VCP 12.1.3.9.1 patch, the Planning Data Pull Worker Fails.
the following error occurs.

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

05-MAR 17:07:49 : In Procedure LOAD_VISITS in IF1
05-MAR 17:07:51 : Error pulling data from MRP_AP_VISITS_V to MSC_ST_VISITS.
05-MAR 17:07:51 : ORA-12899: value too large for column "MSC"."MSC_ST_VISITS"."VISIT_NAME" (actual: 63, maximum: 60)
05-MAR 17:07:51 : ORA-12899: value too large for column "MSC"."MSC_ST_VISITS"."VISIT_NAME" (actual: 63, maximum: 60)
05-MAR 17:07:51 : Send Pipe :MSC_CL_PULL_WM1
05-MAR 17:07:51 : sucess_flag :0
05-MAR 17:07:51 : Message :-9999999
05-MAR 17:07:51 : Send Pipe :MSC_CL_PULL_ST1
05-MAR 17:07:51 : sucess_flag :0
05-MAR 17:07:51 : Message :1
05-MAR 17:07:51 : Error_Stack...
05-MAR 17:07:51 : ORA-12899: value too large for column "MSC"."MSC_ST_VISITS"."VISIT_NAME" (actual: 63, maximum: 60)

05-MAR 17:07:51 : Error_Backtrace...
05-MAR 17:07:51 : ORA-06512: at "APPS.MSC_CL_PULL", line 7039
ORA-06512: at "APPS.MSC_CL_PULL", line 1805



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Application.
2. Run Collections.
  NAV: Advanced Supply Chain Planner (R) -> Collections -> Oracle Systems -> Standard Collection
3. See that the PDP worker is failing with above error.


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