E-UPG: ORA-00904: "PTPRJCURCOUNT": invalid identifier During Reviewing PeopleTools Objects Step of Upgrade (Doc ID 2120118.1)

Last updated on MARCH 30, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, Compare Reports

While upgrading to PeopleTools 8.55. During this Tools Upgrade process, step Reviewing PeopleTools Objects ran into the following error with below message:

 
ERROR
-----------------------
(File: E:\pt85501c-retail\peopletools\src\pssys\cmputil.cppSQL error. Stmt #: 214 Error Position: 238 Return: 904 - ORA-00904: "PTPRJCURCOUNT": invalid identifier
Failed SQL stmt: INSERT INTO PSCOMPSESSION (PTSESSIONTYPE, PROJECTNAME, SRCDBNAME, TGTDBNAME, RUNDTTM, PTPRJFILEDTTM, PTSESSIONID, DESCR, SRCOPRID, TGTOPRID, SRCSERVERNAME, TGTSERVERNAME, PTLASTACTDTTM, PTREPNAME, PTAREANAME, PTPRJSTATE, PTPRJTOTALCOUNT, PTPRJCURCOUNT) VALUES (:1,:2,:3,:4,TO_TIMESTAMP(:5,'YYYY-MM-DD-HH24.MI.SS.FF'),NULL, :6,:7,:8,:9,:10,:11,NULL, ' ', ' ', ' ',0,0)



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. open application, goto compare from file option.
2. Load the project and click on compare.


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