CS 9.0 Bundle 36 UPD915103_11.DMS Fails with ORA-00001: Unique Constraint Violated Error (Doc ID 1965003.1)

Last updated on AUGUST 09, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
PeopleSoft Enterprise CS Student Administration - Version 9 and later
Information in this document applies to any platform.

Symptoms

When applying Patch 19906038: CS 9 Bundle #36 an error is returned when UPD915103_11.DMS is run:

ERROR
-----------------------
SQL Error. Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_SCC_ENT_VW_PROP) violated
INSERT INTO PS_SCC_ENT_VW_PROP (SCC_ENT_VIEW_ID, SCC_PROP_NAME, SCC_SHOW_TO_XML, SCC_PARSE_FROM_XML, SCC_SHOW_LOV_DESCR, SCC_ORDER_NBR) VALUES (:1, :2, :3, :4, :5, :6)
SQL Error. Error Position: 0 Return: 0 -
Error: SQL unable to commit transaction for SCC_ENT_VW_PROP
Ended: Tue Jan 27 10:55:37 2015
Unsuccessful completion



Please also visit these valuable Campus Solutions sites: Community  Newsletters  Information_Centers  Maintenance_Advisor 

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