My Oracle Support Banner

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:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.1.1 to 6.1.1.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

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:

COMMON_COA_ID PRODUCT_ID TRANSFER_RATE
12345 10101 1.959105
12345 10102 1.959105
12345 10103 1.959105
12345 10104 1.959105
12345 10105 1.959105

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

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
Changes
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.