My Oracle Support Banner

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.

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)

The issue can be reproduced at will with the following steps:
1. Run "Task 7-2-11: Updating PeopleTools Database Objects"




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

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