My Oracle Support Banner

Create Index Step in Change Assistant Fails With Error 'ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found' When Applying Change Package from PUM 26 (Doc ID 2904941.1)

Last updated on JANUARY 25, 2024

Applies to:

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

Symptoms

Applying a change package of all maintenance delivered in Campus Solutions 9.2 PUM 26 to a target environment, Change Assistant fails at the Create Index step on table PS_SCC_SFP_MV_TMP.  This temporary table, in one example, contained more than 144,000 rows of data.



The issue can be reproduced at will with the following steps:

  1. Create a change package from PUM 26 for all maintenance not applied;
  2. Using Change Assistant, apply the change package to a non production environment;
  3. The Create Index step fails to complete;
  4. Note the error in the Change Assistant log.


Changes

A POC (Proof of Concept) fix for SFP processing had been provided which introduced PS_SCC_SFP_MV_TMP record.  T

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
Changes
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.