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.
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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms