E-QR: Incorrect Left Outer Join With Language Table If User Run PS QUERY In Simplified Chinese

(Doc ID 2163908.1)

Last updated on JULY 22, 2016

Applies to:

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


Query retrieves different results between English and Simplified Chinese, Query is not retrieving data correctly. The PS QUERY is left outer join wrongly with related language records missing some of the key fields which leads to retrieve extra rows.

The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Create a new PS Query with English connection
3. Run the Query in English correctly
4. Log out and change the language to Simplified Chinese
5. Re-run the Query - incorrect output results are displayed


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