EPY: TAX909NY.SQR Not Handling Date Format Correctly
(Doc ID 2327740.1)
Last updated on NOVEMBER 23, 2019
Applies to:
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
TAX909NY.SQR is not handling the date format correctly.
If the SETENV.sqc has Year4 set to a value of "0" (2-digit year), the issue occurs.
In tax909ny.sqr, format-datetime is called as follows:
let $Date_Field = '01/01/' || $BALANCE_YEAR
do Format-DateTime($Date_Field, $jan, {DEFDATE},'','native')
let $Date_Field = '12/31/' || $BALANCE_YEAR
do Format-DateTime($Date_Field, $dec, {DEFDATE},'','native')
$BALANCE_YEAR is four bytes long. Because we are using 2-byte dates, 01/01/2017 gets converted to 01/01/2020 at the end of the call to the format-date-time function. This causes incorrect data to be selected.
This SQR should be changed to be made aware of the $Year4 setting in setenv.sqc and set the date accordingly.
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |