Multiple Exchange Rates Per Day Not Being Applied Properly By FCT_ExchangeRate Module (Doc ID 2250675.1)

Last updated on MAY 10, 2024

Applies to:

Goal

On : 7.5.0.0.0 version, Pipeline Manager


When  multiple exchange rates are configured for the same day with "valid from" precision hours, minutes and seconds the event is being rated with the first exchange rate loaded for that day.

Steps to reproduce:
1. Load two exchange rates for the same date, but different times, for same fields "from currency" and "to currency" combination, for example:
1.1 USD to CRC
1.2 Valid From value 2017-02-20 00:30:00, exchange rate 500
1.3 Valid From value 2017-02-20 15:00:00, exchange rate 600
1.4 Send semaphore to rating pipeline, in order to reload module DAT_ExchangeRate (or re-start pipeline).
2. Rate an event for which exchange rate must be applied and event start timestamp is 20170220160000 (2017-02-20 16:00:00).
3. Exchange rate applied is 500.

The expected result is that event was rated with exchange rate 600.

Could you confirm how the modules DAT_ExchangeRate and FCT_ExchangeRate works for this kind of scenarios?
 

Solution

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