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

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