My Oracle Support Banner

E-COMP: Compare Reports Failing With Errors ORA-00942 and ORA-00904 After PeopleTools Upgrade. (Doc ID 2588584.1)

Last updated on SEPTEMBER 18, 2019

Applies to:

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

Symptoms

On : 8.56 version, Compare Reports

When attempting to perform a database to database compare based on a combined project of PPLTOOLS, PPLTLS84CUR, and PATCH857, the following error occurs.

ERROR
-----------------------
942 - ORA-00942: table or view does not exist T(*) FROM PSDOCJSCMADATA WHERE IB_PACKAGEID = :1 AND IB (62,16)

and

904 - ORA-00904: "PTRECUREVERY": invalid identifier CT TO_CHAR(CAST((LASTUPDDTTM) AS TIMESTAMP),'YYYRT, (62,16)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade the PeopleTools version of Database 1 with Change Assistant
2. Use the rel scripts to rel up Database 2 to PT 8.57.
3. Combine the PPLTOOLS, PPLTLS84CUR, and PATCH857 projects into one project.
4. Run project compare from one database to the other.
5. Error occurs.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.