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.
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.
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.
Incorrect number of rows in the query and wrong data brought to the query.
Query unusable in language different than the base language.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms