E-QR: “Error In Running Query because of SQL Error, Code=933, Message = ORA-00933” Only For Records Aliases Defined With Reserved Words Like ‘AS’ And ‘TO’.
Last updated on SEPTEMBER 30, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.
When attempting to create queries with multiple records, the logic behind PS Query is to assign aliases as described in PeopleBooks:
PeopleTools 8.53: PeopleSoft Query, Adding Fields to Query Content, p. 26
Note: You can select and add up to 676 records for each query. The record alias goes from A to Z for record number 1 to record number 26. When you add record number 27 and after, the record alias starts at AA and follows the pattern AB, AC, AD, and so on, ending with ZX, ZY, ZZ.
The query records that are defined with ‘AS’ alias are failing with the following error:
“A SQL error occurred. Please consult your system log for details.
Error in running query because of SQL Error, Code=933, Message=ORA-00933”
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Create a new query using 40+ records, PS Query assigns alias like ‘AS’ and ‘TO’ by default logic
4. Run the Query
5. The error occurs.
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