My Oracle Support Banner

Got error ORA-00001: unique constraint (SYSADM.PS_REC_GROUP_REC) when running UPD828373_01.dms after applying Maintenance Pact (MP) (Doc ID 1561968.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Grants - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Goal

Error when installing MP10 via change assistant.

Problem Description
---------------------------------------------------
Trying to install MP10. Step is failing in change assistant at "UPD828373_01.dms".

SET LOG UPD828373_01.LOG;
SET INPUT C:\pspatch\stage\softwareupdateFSCM910_MP10{2b0a5478-d364-11e2-b862-e113a1ba38df}\scripts\MAINT\UPD828373_01.DAT;
IMPORT *;
INSERT INTO PS_SET_CNTRL_REC (SETCNTRLVALUE, REC_GROUP_ID, RECNAME, SETID) SELECT SETCNTRLVALUE, REC_GROUP_ID,'GM_ADD_INFO',SETID FROM PS_SET_CNTRL_GROUP WHERE REC_GROUP_ID = 'GMEG_03';

Error Codes
---------------------------------------------------
File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_REC_GROUP_REC) violated Failed SQL stmt: INSERT INTO PS_REC_GROUP_REC (REC_GROUP_ID, RECNAME) VALUES (:1, :2)

What should be done?
 

Solution

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
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.