I am building a data load process to load exchange rates into Oracle FCCS, approximately 56 currencies. The currencies are provided by the treasury department and they only provide indirect rates. How can I load indirect rates into FCCS? The application currency is USD. All the exchange rates provided will use USD as the "from" currency.
I have tried entering the rates using in the format From_USD to AUD. But the direct rate (AUD to USD) would not calculate. I also tried creating an intermediate member USDX and entering the rate in the form From_USDX to AUD and simultaneously entering From_USDX to USD as a constant of 1.0. But still could not calculate the direct rate.
The translation does not occur without the direct rate. As soon as the direct rate is entered the translation occurs as expected. With only indirect rates provided no translations occur. (Also I am executing the "Compute Rates" rule after entering each exchange rate.