My Oracle Support Banner

E-QR: Download Query to Excel Adds Line Feeds And Line Breaks (Doc ID 2775330.1)

Last updated on MAY 10, 2021

Applies to:

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

Symptoms

When downloading query data to Excel, data for a specific column is shown on multiple lines as line feeds and line breaks are added.

In order to replicate the issue, follow the below steps:
1. Log into PIA.
2. Navigate to Reporting Tools > Query > Query Manager.
3. Search for QUERY: FIN0010_GL_ACCOUNTS (FSCM 9.2).
4. Run it to Excel using Parameters.
5. On the generated Excel output file, line feeds and line breaks are added.
It should have all data for a specific columns shown in 1 row.

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.