E-QR: Error Managing Related Language Records In Queries After Upgrade To PeopleTools 8.54 (Doc ID 1966664.1)

Last updated on DECEMBER 15, 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

The management of related language records (RLR) in Queries doesn’t work correctly under some scenarios after upgrading to PeopleTools 8.54.

Some added left joins for RLR are not correct if only part of the key is selected as output.

Steps:
---------
1. Go to Query Manager.
2. Create a query that uses a table that has an associated RLR joined without bringing the full key.
3. Save the query.
4. Log In another language.
5. Access it in another language and look at the SQL.
6. Notice the missing conditions.
 
Business Impact:
-------------------------
Incorrect number of rows in the query and wrong data brought to the query.

Query unusable in language different than the base language.

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