E-ORA ORA-31603: object "PS_CDM_TRANSFER_PK" of type INDEX not found in schema "SYSADM" (Doc ID 1319834.1)

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***

Symptoms

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.

ERROR
-----------------------
PeopleSoft Project Command Line
Build Project
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

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