My Oracle Support Banner

E-QR: Query Export To Excel Shows Only One Row when Query Contains A Field Of Data Type TIME. (Doc ID 2970344.1)

Last updated on AUGUST 31, 2023

Applies to:

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

Symptoms

When attempting to run a PS Query to Excel only one row is returned if the Query definition contains a TIME field.
It is working as expected when using the old PS Query technology.

The issue can be reproduced at will with the following steps:
1. Navigate to Reporting Tools > Query > Query Manager.
2. Create a new query when using an underlying Record View in the PeopleSoft Query which contains a TIME field.
3. In this particular example, Users are trying to return duplicate rows for the same EMPLID, EMPL_RCD and DUR.
4. Open Application Designer and Create a new Record View based upon TL_RAPID_TIME
5. Create a new Record and Add the fields
6. Save record as XX_TL_SAMPLE_VW
7. Switch to Record Type <TAB>
8. Change Record Type to SQL View and Click To Open SQL Editor
9. Paste in the following SQL

13. Create the PS Query
14. In the PeopleSoft Application, add the new record, XX_TL_SAMPLE_VW, to an appropriate Query Tree.
- Navigation: People Tools > Security > Query Security > Query Access Manager
- Open the Query_TREE_PT
- Add the XX_TL_SAMPLE_VW view to this Query Tree
15. Navigate to Query Manager and create a new Query, XX_TL_RAPID_TIME
16. Run the Query to HTML - 211 rows are displayed
17. Download the PS Query results to Excel
18. Only one row is displayed either for Local Time Zone: US Pacific time or Green Which Mean Time.

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.