My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

Applies to:

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


On : 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?


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

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