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.

Symptoms

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 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms