E-PC: DB Field Rounded When An Update Statement Sum Bind Variable Values With Different Precision
Last updated on MARCH 05, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
On : 8.55 version, PeopleCode
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.
The data shouldn't be rounded.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms