My Oracle Support Banner

Applying Campus Solutions 9.0 Bundle 54 or Campus Solutions 9.2 PUM 14 Results in Error 'CREATE UNIQUE INDEX PS_SSR_TSRQST_PRNT on PS_SSR_TSRQST_PRNT ERROR at line 1: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found' (Doc ID 2584426.1)

Last updated on SEPTEMBER 03, 2019

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise CS Student Records - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Applying Campus Solutions 9.2 PUM 14 maintenance or Campus Solutions 9.0 Bundle #54 (Patchset 29757777),  an error occurs in Change Assistant at the Create Index step when applying the change package. The error occurs on table PS_SSR_TSRQST_PRNT

The error received is:


CREATE UNIQUE INDEX PS_SSR_TSRQST_PRNT on PS_SSR_TSRQST_PRNT
*
ERROR at line 1:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.