My Oracle Support Banner

E-BI/XMLP: BI Publisher Report Using SUM() Automatically Rounding Up The Number When 17 or More Digits Used. (Doc ID 2827597.1)

Last updated on DECEMBER 31, 2021

Applies to:

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

Symptoms

In BI Publisher RTF template, when using a form field to sum a number with 17 digits or more, the number gets rounded up.

 The issue can be reproduced with the following steps:

1. Submit report that sums a number having 17 digits (i.e. '999999999999999.99')

2. Observe resulting report output where number has been rounded up (i.e '1,000,000,000,000,000.00')

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
Cause
Solution
References


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