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.
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.
942 - ORA-00942: table or view does not exist T(*) FROM PSDOCJSCMADATA WHERE IB_PACKAGEID = :1 AND IB (62,16)
904 - ORA-00904: "PTRECUREVERY": invalid identifier CT TO_CHAR(CAST((LASTUPDDTTM) AS TIMESTAMP),'YYYRT, (62,16)
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.
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