Consolidated Detail Exchange Rates for FEs 1710,1715,1716 Incorrect when Liquidity Time Bucket Not Equal Income Simulation
Last updated on DECEMBER 11, 2017
Applies to:Oracle Financial Services Asset Liability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 8.0.4 version, Calculation Engine
Consolidated Details, CONS_DTL, Exchange Rates for Financial Elements (FE) 1710,1715,1716 are incorrect when Liquidity (LR) Time Bucket not equal Income Simulation (IS) Time Bucket. The Exchange Rates used are not from the correct bucket.
Steps to Replicate:
1. Income Simulation Bucket is defined as monthly.
2. Liquidity Time Bucket is defined as daily.
3. Exchange Rates applied for Liquidity Gap financial elements below are incorrect.
1710 Liquidity Gap Present Value of Cash Flows
1715 Liquidity Gap Present Value of Principal Cash Flows
1716 Liquidity Gap Present Value of Interest Cash Flows
For FE 430 Interest Cash Flow and 1672 Liquidity Gap Interest Cash Flow Net the engine behaves like expected and exchange rates are correct.
For FE 1672 the first cash flow appears in bucket 86 under LR bucket 25-Oct-2017 - 25-Oct-2017.
The exchange rate used is the correct one from bucket 01-Oct-2017 - 31-Oct-2017 from fsi_exchange_rates_audit.
However for FEs 1710 (Liquidity Gap Present Value of Cash Flows) and 1716 (Liquidity Gap Present Value of Interest Cash Flows) that have output in the same LR bucket 25-Oct-2017 - 25-Oct-2017 (bucket 88), the exchange rate used is from the last bucket 01-Aug-2036 - 31-Jul-2037 from fsi_exchange_rates_audit. It maintains the same exchange rate for the next 2 buckets as well, but from bucket 108 under LR bucket 31-Mar-2019 - 29-Apr-2019 it starts using the exchange rate from the first bucket 01-Aug-2017 - 31-Aug-2017 from fsi_exchange_rates_audit.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms