EOPC: Page Composer Generates SQL Error On MS SQL Server Database

(Doc ID 2218673.1)

Last updated on DECEMBER 08, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


Application & Versions affected: PT 8.55.12/FSCM 9.2 PUM 22 and HCM 9.2 PUM 20, CS 9.2
Microsoft SQL Server 2012

When accessing this navigation page: Enterprise Components > Page Composer > Page Composer, a SQL error is issued on a Microsoft SQL Server platform

Error as seen in the log:

The same works in Oracle database


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