ORACLE error 1400 in FDPSTP during Collections (Doc ID 1056114.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

Error during the Collections Run.   Versions 11 and 12.

Master Request Log:
+---------------------------------------------------------------------------+
Advanced Supply Chain Planning: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

MSCPDC module: Planning ODS Load
.
.
.
24-JAN 18:41:11 : Request 512015 has completed in error.


Child Request Log (512015)


MSCITTK module: Generate Items and Category Sets Keys
+---------------------------------------------------------------------------+

Current system time is 24-JAN-2010 18:40:29

+---------------------------------------------------------------------------+

**Starts**24-JAN-2010 18:40:30
ORACLE error 1400 in FDPSTP

Cause: FDPSTP failed due to ORA-01400: cannot insert NULL into ("MSC"."MSC_ITEMS"."ITEM_NAME")
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 39140
ORA-06512: at line 1
.

The SQL statement being executed at the time of the error
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
24-JAN 18:40:30 : ========================================
24-JAN 18:40:30 : Error in PROCEDURE=GENERATE_ITEM_KEYS, TABLE=MSC_ITEMS
24-JAN 18:40:30 : COLUMN=ITEM_NAME, VALUE=
24-JAN 18:40:30 : ORA-01400: cannot insert NULL into ("MSC"."MSC_ITEMS"."ITEM_NAME")
24-JAN 18:40:30 : ORA-01400: cannot insert NULL into ("MSC"."MSC_ITEMS"."ITEM_NAME")

 

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