My Oracle Support Banner

Planning Data Pull Worker fails with Error pulling data from MRP_AP_REPT_ITEM_SUPPLIES_V to MSC_ST_SUPPLIES (Doc ID 2265277.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

Running the data collection process. the Planning Data Pull Worker (MSCPDPW) completes with the following status.

10-MAY 09:07:54 : Error pulling data from MRP_AP_REPT_ITEM_SUPPLIES_V to MSC_ST_SUPPLIES.
10-MAY 09:07:54 : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
10-MAY 09:07:54 : ORA-06502: PL/SQL: numeric or value error: character string buffer too small
10-MAY 09:07:54 : Enqueued msg -9999999to - Queue
10-MAY 09:07:54 : Enqueued msg 1to - Queue
10-MAY 09:07:54 : Error_Stack...
10-MAY 09:07:54 : ORA-06502: PL/SQL: numeric or value error: character string buffer too small

10-MAY 09:07:54 : Error_Backtrace...
10-MAY 09:07:54 : ORA-06512: at "APPS.MSC_CL_PULL", line 7028
ORA-06512: at "APPS.MSC_CL_PULL", line 1815

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
Cause
Solution


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