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

Last updated on APRIL 26, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

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

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