In An EText Template The SUM Function Does Not Calculate Properly (Doc ID 2010122.1)

Last updated on MAY 15, 2015

Applies to:

BI Publisher (formerly XML Publisher) - Version 10.1.3.4.0 to 11.1.1.7.x [Release 10.1 to 11.1]
Information in this document applies to any platform.

Symptoms

In BI Publisher 10g or 11g:

Using the SUM function in an eText template does not calculate properly.

In other words, this works:
((SUBSTR(ACCOUNT_NUMBER,5,2) * DEPOSIT_AMOUNT) + (SUBSTR(ACCOUNT_NUMBER,7,2) * DEPOSIT_AMOUNT) + (SUBSTR(ACCOUNT_NUMBER,9,2) * DEPOSIT_AMOUNT))* 100

But this does not work:
SUM(((SUBSTR(ACCOUNT_NUMBER,5,2) * DEPOSIT_AMOUNT) + (SUBSTR(ACCOUNT_NUMBER,7,2) * DEPOSIT_AMOUNT) + (SUBSTR(ACCOUNT_NUMBER,9,2) * DEPOSIT_AMOUNT))* 100)

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