On MS SQL 2012 Version SQR Reports Selecting DATETIME NULL Values Fail (Error: "(SQR 1915) Year cannot be zero.")

We are doing application upgrade of HCM application from 9.1 to 9.2 on SQL server Database. Development team is doing the retrofitting of SQR reports and those going to ERROR during the Testing.

When attempting to run SQR Reports with date time NULL values the following error occurs:

Error:  "(SQR 1915) Year cannot be zero."

The issue is caused by a code failure - "SELECTING NULL DATETIME VALUE FROM MS SQL SERVER 2012 ERRORS OUT SQR" Reported in PeopleTools 8.54.03, when running SQR reports with null datetime values, the sqr reports are erroring out.

There are 2 solutions to fix the above error:

Solution 1:

The customers would need to upgrade the tools version to 8.55

 Solution 2:



According to Oracle Support confirmation the fix was included in 8.54.09 patch. Therefore, to resolve this issue, download either the minimum patch 8.54.09 or the latest Generally Available 8.54.xx patch available.

Update instructions:
****************
In order to apply the fix please implement the following update steps in a test environment:

 1. Download and review the instructions and requisites for PT 8.54.09/PT 8.54.xx, on the Patches&Updates:

2. Apply the Update/Bundle according to the instructions.

3. Retest the issue.

4. Migrate the Update/Bundle as appropriate to the other environments.