E-QR: PSQuery Ends In Error Due To Related Language Record 'OR' Alias (Doc ID 2025146.1)

Last updated on AUGUST 10, 2015

Applies to:

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

Symptoms

PS Queries will fail with a 'SQL Error' if the query definition contains a record with the alias 'O', which also has a related language record.
The related language record alias is always composed of the main record alias ('O' in this case) and the 'R' letter.

In some situations, the combination 'OR' will occur in the FROM part of the SQL statement, causing the query to end in 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