EBS-SCP Cloud: While Running Data Extraction For Cloud, Data Extraction Preprocessor Fails With ORA-1400 Error When Running For Specific Category Set
(Doc ID 3040280.1)
Last updated on AUGUST 09, 2024
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run data extraction for cloud with filter on category set, Data extraction Pre-processor fails.
NAV: Advanced Planning Administrator (R) -> View /Requests /Submit a New Request - choose Extract Data for Oracle Supply Chain Planning Cloud
The following error could be seen in the log file
[24-JUL-2024 05:28:52]: **Starts**
[24-JUL-2024 05:31:16]: **Ends**
ORA-01400: cannot insert NULL into ("MSC"."MSC_EBS_FUSION_COLL_FILTERS"."ITEM_NAME#1")
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
24-JUL 05:28:52 : Procedure TRUNCATE_MSC_TABLE:MSC.MSC_EBS_FUSION_COLL_FILTERS started.
24-JUL 05:28:52 : 0 minutes elapsed.
************************************************************
Bad sqls for this session
------------------------------------------------------------
************************************************************
MSC_APCL_UTIL.FRAMEWORK_PRE_PROCESS Error:ORA-01400: cannot insert NULL into ("MSC"."MSC_EBS_FUSION_COLL_FILTERS"."ITEM_NAME#1")
MSC_APCL_UTIL.FRAMEWORK_PRE_PROCESS Error:ORA-01400: cannot insert NULL into ("MSC"."MSC_EBS_FUSION_COLL_FILTERS"."ITEM_NAME#1")
MSC_APCL_UTIL.FRAMEWORK_PRE_PROCESS Error:ORA-06512: at "APPS.MSC_APCL_UTIL", line 494
Program completes successfully when there are no filters on category set.
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 |
| References |