FTP Conditional Assumption With Ranges Not Being Applied Correctly by FTP Engine (Doc ID 3069472.1)

Last updated on MARCH 04, 2025

Applies to:

Symptoms

You create a Transfer Pricing Rule with 5 conditional assumptions attached to it that are not being applied correctly based on the filters being used.

The conditional assumption is setup as follows:

Checking and Savings Accounts-Option Cost include range values between 3.850000 and 6.000000
Checking and Savings Accounts-Option Cost include range values between 3.400000 and 3.849999
Checking and Savings Accounts-Option Cost include range values between 2.900000 and 3.399999
Checking and Savings Accounts-Option Cost include range values between 2.400000 and 2.899990
Checking and Savings Accounts-Option Cost include range values between 0.000000 and 2.399990

For each row, a different Term Point on an Interest Rate Code (IRC) is assigned to get the rate:

COND_SEQUENCE 0 = 1M
COND_SEQUENCE 1 = 2M
COND_SEQUENCE 2 = 3M
COND_SEQUENCE 3 = 4M
COND_SEQUENCE 4 = 5M

The rate does not get assigned correctly.  The wrong value is output based on the range and term assignment.

Cause

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