EOPC: Page Composer Generates SQL Error On MS SQL Server Database (Doc ID 2218673.1)

Last updated on MAY 19, 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.

Symptoms

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
---------------
Error as seen in the log:


WHAT WORKS
---------------
The same works in Oracle database

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