E-PC: DB Field Rounded When An Update Statement Sum Bind Variable Values With Different Precision

(Doc ID 2336510.1)

Last updated on DECEMBER 06, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : 8.55 version, PeopleCode

ACTUAL BEHAVIOR
---------------
DB Field rounded when an update statement sum bind variable values with different precision

After a PeopleTools Upgrade, from 8.51.18 (SQL Server 2008) to 8.55.16 (SQL Server 2016 SP1), on a HCM 9.1 suite, the customer detected an error on UPDATE statement that sum decimal numbers using bind variables with different decimal precisión.

Stmt= UPDATE PS_ANYTABLE SET DURATION_DAYS= (:1 + :2 )
  Bind 1 value=1
  Bind 2 value 2.5

After the update, the DURATION_DAYS value was:
3.500 on PT 8.51 and 4.000 on 8.55.

The result was rounded on 8.55, so something is working different on the new PT /SQL Server version combination.



EXPECTED BEHAVIOR
-----------------------
The data shouldn't be rounded.

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