E-MSS: PT 8.54.06: SQL Objects are Truncating Decimal Positions in Arithmetical Operations (Doc ID 2163275.1)

Last updated on MAY 16, 2017

Applies to:

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

Symptoms

On : 8.54 version, PeopleCode

ACTUAL BEHAVIOR
---------------
SQL objects are truncating decimal positions in arithmetical operations in PeopleTools 8.54.06

Statements Insert included into a SQL object are truncating the decimal positions when are results of arithmetical operations embedded into the statement. Example:

INSERT INTO PS_AJ_BASE0_TBL (DOCUMENT
 , WTHD_AMT
 , WTHD_AMT_BNK_BSE
 , WTHD_AMT_BSE
 , WTHD_AMT_TYPE_G
 , WTHD_AMT_TYPE_I
 , WTHD_AMT_TYPE_M )
  VALUES (:1
  ,:2
  ,:2 - 1
  ,:2 + 1
  ,:2 * -1
  ,:2 / 1
  ,1.25 * -1 )

Instead the parameter :2 is a signed number with 3 decimal positions and the fields in the table receive decimals too, application is inserting results truncated.

This happen for environments recently migrated from PeopleTools 8.52.13 to PeopleTools 8.54.06.

Attached a simple development Project tested in a Demo instance of ER 9.1 and a document that explains how to replicate the problem in a Demo environments.

EXPECTED BEHAVIOR
-----------------------
Shouldn't be truncating decimal positions in arithmetical operations

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the correct values.

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