E-SQR: SQR Fails in MSSQL 2012 when it Encounters NULL for a Date Field

(Doc ID 2230359.1)

Last updated on JANUARY 26, 2018

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.55 [Release 8.4]
PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.


In environments using Microsoft SQL Server 2012, some SQR reports are going to error.

This is specific to using a MSSQL database and when SQR encounters a NULL in a date field that is part of a SELECT clause in Begin-Select.

Some delivered reports encountering this error include GLS7011, GLS7009, BILDG01, FIN2001, FIN2005 and the Lettergen process CCLTRGEN.sqr.


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