How To Use BigDecimal Output Data Type in Mathematical Operations (Doc ID 2423927.1)

Last updated on JULY 17, 2018

Applies to:

Goal

On : 11.12.1.0.0 version, Opportunities

I am attempting to use the groovy script function 'adf.util.getCurrencyRate()' in an object function.

The return type is BigDecimal.

However, I am unable to perform any math operations on the resulting variable, even when it is interacting with a variable of type java.math.BigDecimal.

Upon validating the script, the following message is returned:

Warning(14,32) : Cannot find matching method java.math.BigDecimal#multiply(BigDecimal). Please check if the declared type is right and if the method exists.

Code:

def current_val = new BigDecimal(0)
def top_currency = CurrencyCode
java.sql.Date top_date = new java.sql.Date(CreationDate.getTime())
def conversionrate = adf.util.getCurrencyRate(row_currency,top_currency,top_date)
def additional_val = row_val * conversionrate

current_val = current_val.add(additional_val)

Changing row 14 to 'def additional_val = row_val.multiply(conversionrate)' has the same result
 

Solution

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