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.
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
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
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