5.11.2.13 Executing LEDGER_STAT Load Procedure for MULTI CURRENCIES

The data for the Ledger can have more than one currency at a time that is multi currencies input.

To execute multi currencies, you need to enable the flag using the following statement:

update fsi_db_info f1 set f1.multi_currency_enabled_flg =1;

commit;

Note:

FTP supports the following two scenarios for Ledger Migration:

• If multi-currency is not used:

  FSI_DB_INFO

  Multi_currency_enabled_flg = 0

  Currency_type_enabled_flg = 0

  Functional_currency_cd = same as iso_currency_cd in ledger and instrument data

  Ledger Data (FE 100 and FE 140) must exist in LS and must only be in Functional currency (iso_currency_cd = functional currency and currency_type_cd = 2)

• If multi-currency is used:

  FSI_DB_INFO

  Multi_currency_enabled_flg = 1

  Currency_type_enabled_flg = 1

  Functional_currency_cd = same as iso_currency_cd in ledger and instrument data

  Instrument Data can be in multiple currencies Ledger Data (FE 100 and FE 140) must exist in LS and must only be in Functional currency (iso_currency_cd = functional currency and currency_type_cd = 2). Exchange rate data should be present in Exchange Rate Direct Access table for converting entered currency to functional currency.