Unable to retrieve Average exchange rate from Fusion GL to FCCS using direct integration

Summary:

The integrated exchange rate import process in FCCS brings only Closing rate, while trying to retrieve closing rate & average rate from Fusion GL to FCCS

Content (please ensure you mask any confidential information):

Fusion GL contains corporate rate on daily basis. When we retrieve the exchange rate data to FCCS for 31 Dec 2023 the system brings the corporate rate
available on 31st Dec 2023 and no other rates imported during the data load process even though filter applied for Corporate, Spot rate.
The expected result is the import process should bring both Ending rate (Corporate) and Average rate (Spot)

Ideally, the Average rate should be calculated based on the formula (sum of corporate rate / 31 ) for the month of Dec 2023.