My Oracle Support Banner

E-QRY: Composite Query Returning ORA-00904 Invalid Identifier Error With 4 or More Joins After Upgrade to 8.59.07 (Doc ID 2923861.1)

Last updated on JANUARY 30, 2023

Applies to:

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

Symptoms

Composite Queries with 4 or more joins no longer working after upgrade to PeopleTools 8.59.07. SQL generated is incomplete and causing a SQL error when trying to 'Run/Preview'. The SQL generated for the composite query is incomplete and does not include all the joins resulting in an invalid query.

Page error when clicking on 'Run/Preview':

A SQL error occurred. Please consult your system log for
details.

Related error showing in Application Server log file:

Error Position: 2435 Return: 904 - ORA-00904:
"<Record Name>"."<Field Name>": invalid identifier


The issue can be reproduced with the following steps:

1. Login to PIA
2. Navigate to composite query manager
3. Create new composite query with more than 4 or 5 joins.
4. Click on Run/Preview
5. Observe reported error
 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.