Foreign Exchange Module Issues
search cancel

Foreign Exchange Module Issues

book

Article ID: 252045

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

SUMMARY: Creating second foreign exchange rate with same currencies adds random erroneous todate

Steps to Reproduce: 
1- Classic  - Administration - Finance - Setup  - Foreign Exchange Rate
2- Start with an exchange rate not in the system yet, for example KES to RUR
3- Create new foreign exchange rate
From Currency: KES
To Currency: RUR
Conversion Rate: 0.752931
Rate Calculation Method:  End of Month
Effective Date:  4/1/2022

4- Create a second foreign exchange rate but with a different start date
From Currency: KES
To Currency: RUR
Conversion Rate: 0.766931
Rate Calculation Method:  End of Month
Effective Date:  3/1/2022

5- Query the database:
select ID, from_currency_code, TO_CURRENCY_CODE, TO_CHAR(FROM_DATE, 'MM/DD/YYYY') FROMDATE,
TO_CHAR(TO_DATE, 'MM/DD/YYYY') TODATE, RATE_TYPE, CALCULATION_METHOD
from cmn_exchange_rates cer 
where FROM_CURRENCY_CODE = 'KES' and TO_CURRENCY_CODE = 'RUR'

Results show a random todate was added to the first rate created
For example:  02/28/2022


Expected Results: Todate has an expected not random value of empty or something logical

Actual Results:  Random date is added to todate column

Environment

Release : 16.0.3

Resolution

This is being investigated at Broadcom as DE67019