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 laterInformation 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:
- Create a change package from PUM 26 for all maintenance not applied;
- Using Change Assistant, apply the change package to a non production environment;
- The Create Index step fails to complete;
- 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 |