How To Resolve the Error "ORA-01400: cannot insert NULL into ("SYSADM"."PS_MIN_TASK_OPTION"."MIN_DL_DFLT_CART")" which Is Issued by the 'UPD870829_SYSDATA.DMS' Script when Installing the FSCM 9.1 Maintenance Pack 10 (Doc ID 1506347.1)

Last updated on FEBRUARY 04, 2016

Applies to:

PeopleSoft Enterprise SCM Mobile Inventory Management - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Goal

The below error is issued by Change Assistant when executing the 'UPD870829_SYSDATA.DMS' script which is delivered with FSCM 9.1 Maintenance Pack 10:

<Patch 14062936> (FSCM 9.1 Maintenance Pack 10 Delta) (Update ID 881856)
<Patch 14063034> (FSCM 9.1 Maintenance Pack 10 Cumulative) (Update ID 881857)

SQL Error. Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_MIN_TASK_OPTION"."MIN_DL_DFLT_CART")
INSERT INTO PS_MIN_TASK_OPTION (MIN_TASK_FLOW, DISPLAY_ROWS, MIN_CE_MAIN_SORT, MIN_CE_MAIN_GROUP, MIN_CE_INITDISPLAY, MIN_CE_ALL_ITEM, MIN_CE_STS_1, MIN_CE_STS_2, MIN_CE_STS_3, MIN_CE_STS_4, MIN_CE_PRELOAD_SER, MIN_EXPERT_MODE, MIN_PROMPTS, MIN_DESCRPT, MIN_COLLAPSE_HDR, MIN_SHOW_FILTER, MIN_SHOW_LAST, MIN_CMPRT_SUPP, DFLT_UOM_STOCK, MIN_SHOW_HIDE_TBL, MIN_ITEM_DISPLAY, MIN_PRNT_DELRPT, MIN_DL_DFLT_DEL_TO, MIN_DL_PRF_DELSORT, MIN_DL_SEL_ITMSORT, MIN_SET_SELECT, MIN_DC_ADD_ITMSORT, MIN_DC_CRT_ITMSORT, MIN_CNT_UOM_ENABLE, MIN_AII_OPT, GET_ALL_ALT, MIN_EXPAND_CMNTS, MIN_AUTO_ADD_SRCH, MIN_DL_SAV_DLV_DOC) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34)
Error: Unable to insert row 1
Error: SQL execute error for MIN_TASK_OPTION

How to resolve it?

Solution

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