FTP Process with Conditional Assumptions Returns Same Transfer Rate for Different Data Filters
(Doc ID 2513717.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 220.127.116.11 to 18.104.22.168 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Funds Transfer Pricing (FTP) 22.214.171.124, 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.
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