OPM/ASCP Standard Collection fails with Error ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind (Doc ID 2125844.1)

Last updated on APRIL 13, 2016

Applies to:

Oracle Process Manufacturing Process Planning - Version 12.2.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Data Collections

MSCPDPW:Error in department/Res Group Insert; ORA-06512: at "APPS.MSC_CL_PULL in ASCP R12.2.5

ASCP Collection in Complete Refresh mode fails on the process MSCPDPW: Planning Data Pull Worker
with number of errors:

05-APR 13:39:12 : Procedure MSC_CL_BOM_PULL.LOAD_RESOURCE started.
Error in department/Res Group Insert: 21
ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
05-APR 13:39:15 : Error in Routine GMP_CALENDAR_PKG.RSRC_EXTRACT.
05-APR 13:39:15 : User-Defined Exception
05-APR 13:39:15 : User-Defined Exception
05-APR 13:39:15 : Error_Stack...
05-APR 13:39:15 : ORA-06510: PL/SQL: unhandled user-defined exception

05-APR 13:39:15 : Error_Backtrace...
05-APR 13:39:15 : Error in department/Res Group Insert, line 7028
ORA-06512: at "APPS.MSC_CL_PULL", line 1815


There is no workaround for the problem.




ERROR
-----------------------
Error in department/Res Group Insert, ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind, ORA-06510: PL/SQL: unhandled user-defined exception, ORA-06512: at "APPS.MSC_CL_PULL", line 1815




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(N) Advanced Supply Chain Planning> Collections>Oracle Systems>Standard Collection
Expected result is due Collection execution in a Complete Refresh mode.

 

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