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’. (Doc ID 1599835.1)

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.

Symptoms

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

http://docs.oracle.com/cd/E39332_01/psft/acrobat/pt853tpsq-b0213.pdf

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.

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