My Oracle Support Banner

E-AD: Long Where Clause In Record View, Using || To Concatenate Strings, Causes Application Designer To Build SQL Script That Truncates Lines In Improper Place. (Doc ID 2330777.1)

Last updated on NOVEMBER 21, 2017

Applies to:

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


On : 8.55 version, Application Designer

When building the SQL Script File to create a Record View, using Application Designer, long lines that use || to concatenate strings are being cut-off, in the middle of a field name, with insert of a line break. Next line adds a space, thus causing the SQL to fail, if executed without proper formatting.

For example:

1- Create a Record View with the SQL Text below:


The error does not occur if the Build Script is executed directly from Application Designer 


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.