Error "Cannot insert NULL ("SYSADM"."PS_INSTALLATIO_MIN"."ROLENAME")" when Running DMS Script File UPD860191_SYSDATA DMS (Doc ID 1323582.1)

Last updated on AUGUST 04, 2016

Applies to:

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

Symptoms

The Data Mover DMS script file UPD860191_SYSDATA.DMS fails with the following error:

SQL Error. Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_INSTALLATIO_MIN"."ROLENAME")
INSERT INTO PS_INSTALLATIO_MIN (MIN_KEY_SEPARATOR, MIN_ENABLE_GTIN) VALUES (:1, :2)

Changes

Apply:

* <Patch 11649267> (Update ID 860191) (Fix DD and SYS Audit errors and add 2 DMS Scripts) or its translation <Patch 11649267> (Update ID 860621)
or
* <Patch 12383228> (FSCM 9.1 Maintenance Pack 6 (Cumulative)) (Update ID 865093)
* <Patch 12351110> (FSCM 9.1 Maintenance Pack 6 (Delta)) (Update ID 864644)

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