My Oracle Support Banner

E-AD: Additional Trailing Spaces Per Line of Sql in Application Designer (Doc ID 2747374.1)

Last updated on JANUARY 31, 2021

Applies to:

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


In Tools 8.58 differing number of trailing spaces can be seen per line of SQL in SQL Editor in Application Designer, which affects the Compare Reports.

Open a SQL View in SQL Editor from Application Designer, initially all the SQL rows will have only one trailing space.

Then make any small change and run the ‘Validate Syntax’ (green check mark), then it can be seen that 3 trailing spaces get added to each line (except for the last line).

In the earlier Tools versions, each line in the SQL had only 1 trailing space.




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

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