E-INST: Copy Project PPLTLS84CUR errors with ORA-00904: "IB_PURGE_DATA": invalid identifier CAST.
(Doc ID 2303015.1)
Last updated on FEBRUARY 03, 2022
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.56 to 8.56 [Release 8.4]Information in this document applies to any platform.
Symptoms
On : 8.56 version, Install and Packaging
When attempting to run "Task 7-2-11: Updating PeopleTools Database Objects" during Fin Demo PT8.56 installation ,
the following error occurs.
ERROR
-----------------------
IB Queues Application Upgrade Copy started: 2017-08-29-11.24.05 (62,6)
System Error : File: E:\pt85601b-retail\peopletools\src\psmgr\mgrgensql.cppSQL error. Stmt #: 2161 Error Position: 150 Return: 904 - ORA-00904: "IB_PURGE_DATA": invalid identifier CAST((LASTUPDDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'QU= (62,16)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run "Task 7-2-11: Updating PeopleTools Database Objects"
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 |