Error MSC_DL_TASK_START_PARTIAL (PROCEDURE=MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY) When Run ASCP Collection (Doc ID 1545898.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run collections
the following error occurs.

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

MSCPDCW module: Planning ODS Load Worker
+---------------------------------------------------------------------------+

************************************************************
11-APR 00:02:43 : MSC_DL_TASK_START_PARTIAL (PROCEDURE=MSC_CL_ITEM_ODS_LOAD.LOAD_CATEGORY)
11-APR 00:04:42 : ========================================
11-APR 00:04:42 : Error in PROCEDURE=LOAD_CATEGORY, TABLE=MSC_ITEM_CATEGORIES
11-APR 00:04:42 : ORA-01400: cannot insert NULL into ("MSC"."ITEM_CATEGORIES_100"."CATEGORY_NAME")
11-APR 00:04:42 : ORA-01400: cannot insert NULL into ("MSC"."ITEM_CATEGORIES_100"."CATEGORY_NAME")
11-APR 00:04:42 : ORA-01400: cannot insert NULL into ("MSC"."ITEM_CATEGORIES_100"."CATEGORY_NAME")
11-APR 00:04:42 : Sending message :-9999999 to monitor.
11-APR 00:04:42 : Error_Stack...
11-APR 00:04:42 : ORA-01400: cannot insert NULL into ("MSC"."ITEM_CATEGORIES_100"."CATEGORY_NAME")

11-APR 00:04:42 : Error_Backtrace...
11-APR 00:04:42 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3371
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3590


Steps:
Advanced supply chain planner, run collections for items



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