E-ORA ORA-31603: object "PS_CDM_TRANSFER_PK" of type INDEX not found in schema "SYSADM"
Last updated on OCTOBER 02, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.
*** Checked for relevance on 23-OCT-2012 ***
***Checked for relevance on 16-Jun-2014***
***Checked for relevance on 5-Jan-2016***
On : 8.51 version, Upgrade
Upgrading HRMS 9.0 / PT 8.49.15 to HRMS 9.0 / PT 8.51.08. When starting the build for the PPLTLS84CUR project, the following error occurs.
PeopleSoft Project Command Line
Project Name: PPLTLS84CUR
Tools Release: 8.51.08
2011-05-04 : 22.30.10
-CT Source Database Type = ORACLE
-CS Source Database Server =
-CD Source Database Name = SATUPG1
-CO Source Database Operator = PS
System Error : File: E:\pt85108b-retail\peopletools\src\psbld\bldcreat.cppSQL error. Stmt #: 2196 Error Position: 0 Return: 31603 - ORA-31603: object "PS_CDM_TRANSFER_PK" of type INDEX not found in schema "SYSADM"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2806
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
Failed SQL stmt:SELECT DBMS_METADATA.GET_DDL('INDEX',:1) from dual
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