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

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