My Oracle Support Banner

E-QR: Query Run To XML Shows Incorrect Results In the Query Manager Search Page (Doc ID 2506128.1)

Last updated on DECEMBER 15, 2020

Applies to:

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

Symptoms

When attempting to run a PS Query to XML from Query Manager search page, the output data do not reflect the correct number of rows that should be retrieved, they are limited at 65k rows.
The same issue does not occur for all other formats (HTML, Excel etc).
The correct Query To XML output results are displayed from Run tab, Run to XML.

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 PS Query (SB_XML_TEST)
4. View Query SQL

SELECT A.EMPLID
 FROM (SELECT TA.EMPLID
 FROM PS_JOB TA,PS_EMPLMT_SRCH_QRY A1 WHERE TA.EMPLID = A1.EMPLID AND TA.EMPL_RCD = A1.EMPL_RCD AND A1.OPRID = 'PS' ) A, (SELECT TB.EMPLID
 FROM PS_JOB TB,PS_EMPLMT_SRCH_QRY B1 WHERE TB.EMPLID = B1.EMPLID AND TB.EMPL_RCD = B1.EMPL_RCD AND B1.OPRID = 'PS' ) B
 WHERE ( ( A.EMPLID = B.EMPLID(+) ))

5. Run the query from Run tab - it retrieves 109688
6. Run to XML from Query Manager search page - it displays only 65535

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.