EPY: TAX504 Error = [Microsoft][SQL Server Native Client 11.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding. (Doc ID 2100448.1)

Last updated on AUGUST 24, 2016

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Year-End

When running TAX504.SQR on a SQL Server environment the following error is generated:

ERROR
-------------
d:\ps9\pshrprd\sqr\tax504.sqr: TAX504 - SQL Statement =
Insert-New-Fed-Row,Insert into PS_FED_TAX_DATA
SQL Status = 0, SQL Error = [Microsoft][SQL Server Native Client 11.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.
 

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