E-QR: Issue With The Bind Variables in PS Query (Doc ID 2072693.1)

Last updated on NOVEMBER 23, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

When a user is running a query in PS Query the following error occurs:

ERROR
---------
"SQL Error 8080 - An invalid bind variable number was specified (SQLSTATE PS080)"


STEPS
-------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Run a query
4. Notice the error


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