FTP Process with Conditional Assumptions Returns Same Transfer Rate for Different Data Filters (Doc ID 2513717.1)

Last updated on MAY 07, 2023

Applies to:

Symptoms

In Oracle Financial Services Funds Transfer Pricing (FTP) 6.1.1.1, when processing a Common COA-based Transfer Pricing Rule containing Conditional Assumptions that filter on PRODUCT_ID values, the same Transfer Rate is being assigned to all PRODUCT_ID values within a Common COA.  The PRODUCT_ID conditional assumption filters are ignored.

For example, the following Conditional Assumption definition is created for COMMON_COA_ID = 12345:

1 - If PRODUCT_ID = 10101, using Moving Average method with IRC = 101 (Rate = 1.959105)
2 - If PRODUCT_ID = 10102, using Moving Average method with IRC = 107 (Rate = 1.980836)
3 - If PRODUCT_ID = 10103, using Moving Average method with IRC = 110 (Rate = 2.860109)
4 - If PRODUCT_ID = 10104, using Moving Average method with IRC = 111 (Rate = 2.241605)
0 - If PRODUCT_ID = 10105, using Moving Average method with IRC = 115 (Rate = 2.023585)

However, checking results for this combination, all products have the same Transfer Rate:

All PRODUCT_ID values get the Transfer Rate generated by the 1st conditional assumption row.

You expect each PRODUCT_ID to get a different TRANSFER_RATE based on the conditional assumption.

Changes

Cause

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