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 |