Oracle GL – update existing GL rates (Spot, Corporate & Month-end)

We use a fixed rate currency (EBR) which has been a static rate for each of our currencies for around 5 years.  Before the start of the new financial year (Oct) the next year’s EBR rates are uploaded using the currency rates manager and ADI.  As the rates are static the upload consists of ‘start of month’ to ‘end of month’ for both Spot and Corporate and ‘last day of the month’ for the month-end rate.  We have 149 currencies using this rate, which equates to around 110k entries each year.

The business has now indicated they want to update the rate for EBR to a different static number for each currency (from the start of this financial year).