E-CA: Modifying Database Definition in CA for new Process Scheduler Results in " ORA-00904 XXX invalid identifier " Error. (Doc ID 2056297.1)

Last updated on SEPTEMBER 15, 2015

Applies to:

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


On : 8.54 version, Upgrade, (test) Move to Production pass

When attempting to configure the Application Server and Batch Server in Change Assistant,
an error similar to the following occurs.

File: E:\pt85409c-retail\peopletools\src\psjca\psjsp.cppSQL error. Stmt #: 2457 Error Position: 7 Return: 904 - ORA-00904: "GPS": invalid identifier
Failed SQL stmt: select GPS from PS_INSTALLATION

The issue can be reproduced at will with the following steps:
1. Applied Required for upgrade fixes and tax updates.
2. Performed the upgrade up to the step of configuring the servers.

This error did not occur when the database was originally defined before the upgrade began.



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