E-SQR: SQR Fails in MSSQL 2012 when it Encounters NULL for a Date Field
Last updated on DECEMBER 27, 2017
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