Currency exchange rate update in RMS

Good morning,

     I need some clarification in RMS Currency exchange rate. One of our client initially loaded the exchange rate to CURRENCY and CURRENCY_RATES tables during conversion. Now business wants to update the exchange rate of an existing currency code, say monthly once. But the existing Oracle forms does not allow to edit the exchange rate based on some program logic.

     But when we try to update the exchange rate from backend, we are able to update and the same gets reflected in the front end screen. Is there a best way to handle this scenario?

     Also I am not sure, updating the exchange rate from backend will create impact on other functionalities as I could see the exchange_rate field is been used in many tables.