E-INST: Copy Project PPLTLS84CUR errors with ORA-00904: "IB_PURGE_DATA": invalid identifier CAST. (Doc ID 2303015.1)

Last updated on AUGUST 31, 2017

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"

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