FDI ERP prerequisite- Exchange Rates setup

FDI_USER

If there is no Exchange rate set up done in ERP as the only currency which will be used for accounting is USD. How this scenario can be handled as there is a prerequisite steps Exchange Rates setup for Analytics Currency and also, we have to set Pipeline parameters as well where Exchange Rate type needs to be selected.

Sushil Dhoot-Oracle

Yogesh - Thanks for using idea labs for your query.

In this scenario, you would need to select USD as Analytics Currency in Pipeline Parameters assuming that is the currency in which Analytics Currency metrics would be required to be populated. You can select any of the available rate types to complete the configuration.

From usage perspective, Analytics currency metrics would have same value as Ledger Currency if both the currencies are same. No conversion rates would apply in this case in FDI.

FDI_USER

@Sushil Dhoot-Oracle Thanks for your answer. Currently, Exchange rate set up has been done in ERP environment and we need to populate data accordingly in FDI. What should be selected in pipeline setting → Global Parameters→ Use Fusion Default Exchange rate type → Yes or No ? Should we go for full load after updating pipeline settings by selecting Exchange rate or a Data warehouse refresh is required ?

Additionally , i would like to know the currency types-

In GL balance sheet SA, we have 3 different type of currency.

Analytics Currency

Legder Currency

Statistical Currency

but in GL Detail transaction we have Document currency.

Is Document currency → Entered Currency ? and Ledger Currency is Accounted Currency ?

If yes, is there any plan to bring Document Currency in GL Balance Sheet SA ?