9.2 Upgrade - Index Errors

(Doc ID 2202697.1)

Last updated on NOVEMBER 10, 2016

Applies to:

PeopleSoft Enterprise SCM Supply Planning - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

While upgrading the system from PT 8.54 with FSCM 9.1 to PT 8.55/FSCM 9.2 encountering the following error:

Getting ORA-01452 for 4 indexes during initial pass on step, "Modifiying the Database Structure" - "Creating Indexes"
CREATE UNIQUE INDEX PS_PL_CYCLE_DTL_RQ ON PS_PL_CYCLE_DTL_RQ
 

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