UPD872204_01_DMS Returns with Errors: Cannot insert duplicate key row in object 'dbo.PS_REC_GROUP_REC' (Doc ID 1400656.1)

Last updated on NOVEMBER 22, 2016

Applies to:

PeopleSoft Enterprise FIN Grants - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
Checked for relevance on 21-Jan-2014

Goal

When applying 9.1 Maintenance Pack 8 or Financial ESA 9.1 bundle #16, the UPD872204_01_DMS script errors with the following message:

Cannot insert duplicate key row in object 'dbo.PS_REC_GROUP_REC' with unique index 'PS_REC_GROUP_REC'. The duplicate key value is (GMEG_25, GM_PT_ACCESS).
Failed SQL stmt:INSERT INTO PS_REC_GROUP_REC(REC_GROUP_ID,RECNAME) VALUES('GMEG_25','GM_PT_ACCESS') (200,0)


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