ORACLE error 1400 in FDPSTP during Collections
(Doc ID 1056114.1)
Last updated on OCTOBER 07, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 11.5.10 and laterInformation 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")
+---------------------------------------------------------------------------+
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
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 |