EPY: TAX909NY.SQR Not Handling Date Format Correctly (Doc ID 2327740.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.