D.2 Functional Currency

At the time of installation, OFSAA Rate Management requires that you designate a functional, or primary, the currency for your organization. A Swiss multinational bank, for example, would designate the Swiss franc as its functional currency. The functional currency is always active. After you have assigned your functional currency, it cannot be changed. To assign your functional currency, manually update FSI_DB_INFO.FUNCTIONAL_CURRENCY_CD with your selected currency.

Note:

This one-row configuration table also contains your fiscal year definition; for more information, see Fiscal Year Information.

Most customers need only one functional currency, but if you require multiple functional currencies and/or multiple fiscal year definitions, you may establish ledger-specific selections of functional currency and fiscal year by manually updating LEDGER_CCY_AND_FISCAL_YR_INFO (one row per defined Management Ledger table).

Processes operating against a Management Ledger table generally determine Functional Currency and Fiscal Year by consulting LEDGER_CCY_AND_FISCAL_YR_INFO. However, any process operating against a Management Ledger table for which no row has been set up in LEDGER_CCY_AND_FISCAL_YR_INFO determines its Functional Currency and Fiscal Year. This is done by consulting FSI_DB_INFO (that is, FSI_DB_INFO serves as a fallback if you have not set up ledger-specific currencies and calendars in LEDGER_CCY_AND_FISCAL_YR_INFO).

Note:

This one-row configuration table also contains your fiscal year definition; for more information, see Fiscal Year Information.

The designation of functional currency is stored as an ISO currency code in FSI_DB_INFO.FUNCTIONAL_CURRENCY_CD / LEDGER_CCY_AND_FISCAL_YR_INFO.FUNCTIONAL_CURRENCY, as applicable.

Profitability Management allocations can read and write in multiple currencies. However, Profitability Management allocations perform internal calculations in the functional currency.

When multi-currency is disabled, all ISO Currency Code values are written in the Functional Currency.