PS Financials 9.2 Upgrade - Unique Constraint On PSPROJECTITEM When Running UPG_CRW_DEFN

(Doc ID 1596268.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
---------------
On "Task 4-4-2: Preserving Crystal Process Definitions" having this unique constraint error on UPG_CRW_DEFN
  
ERROR
---------------
"File: pt85304c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPROJECTITEM) violated
Failed SQL stmt: INSERT INTO PSPROJECTITEM ( PROJECTNAME ,OBJECTTYPE ,OBJECTVALUE1 ,OBJECTID1 ,OBJECTVALUE2 ,OBJECTID2 , OBJECTVALUE3 ,OBJECTID3 ,OBJECTVALUE4 ,OBJECTID4 ,NODETYPE ,SOURCESTATUS ,TARGETSTATUS ,UPGRADEACTION , TAKEACTION ,COPYDONE) SELECT DISTINCT 'UPGCUST' ,20 ,PRCSTYPE ,29 ,PRCSNAME ,28 , ' ' ,0 ,' ' ,0 ,0 ,0 ,0 ,0 ,1 ,0 FROM PS_PRCSDEFN WHERE PRCSTYPE IN ('Crystal','Crystal Check','Crw Online')
 Message Set Number: 200
 Message Number: 0
 Message Reason: File:\pt85304c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPROJECTITEM) violated "
  


ENVIRONMENT
---------------
DB Platform : Linux x86-64
Tools Version: 8.53.04
Application & Version: FSCM 9.0 to 9.2
System Name: n/a
Production/Development/Test: DEV

STEPS
---------------
The issue can be reproduced with the following steps:
1. After Task 4-4: Running New Release Compare Reports, Task 4-4-2: Preserving Crystal Process Definitions on failing on UPG_CRW_DEFN

IMPACT
---------------
Cannot continue upgrade. Loss of service is important. Application in PROD works ok.

Cause

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