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
Release : 16.0.3
This is being investigated at Broadcom as DE67019