My Oracle Support Banner

E-SQR: SQR Fails in MSSQL 2012 when it Encounters NULL for a Date Field (Doc ID 2230359.1)

Last updated on AUGUST 04, 2018

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
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.56 [Release 8.4]
Information in this document applies to any platform.

Symptoms

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.

In more recent Tools releases experiencing this issue, the following error messages have been reported:

(SQR 1915) Year cannot be zero

(SQR 1925) Month must be between 1 and 12

(SQR 1928) Hour must be between 0 to 23

 

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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.