E.1 Configuring a Fiscal Year

Fiscal year configuration data is held in FSI_FISCAL_YEAR_INFO, a special one-row, two-column table. The table is seeded with values corresponding to a standard 12-month, January to December calendar year. For a Management Ledger setup, Fiscal year configuration data is held in 'LEDGER_CCY_AND_FISCAL_YR_INFO'. If the Users fail to populate the previously mentioned table but do populate the FSI_FISCAL_YEAR_INFO, this table acts as a fallback source for the Management Ledger table.

Table E-1 FSI_FISCAL_YEAR_INFO / LEDGER_CCY_AND_FISCAL_YR_INFO table

FISCAL_PERIOD	START_MONTH
12	1

If your organization operates on a fiscal year basis, the values in this table need to be updated at the time OFSAA is installed. In the FSI_FISCAL_YEAR_INFO / LEDGER_CCY_AND_FISCAL_YR_INFO table, the values in the Fiscal Period and Start-Month columns determine the duration and beginning month of your financial year, respectively. All application processes that insert into or delete from the Management Ledger table read the configuration data in FSI_FISCAL_YEAR_INFO / LEDGER_CCY_AND_FISCAL_YR_INFO.

Fiscal-Period Column: This column holds a value that represents the financial year in months. For a calendar year, this value is always 12 months. For a fiscal year, this value is typically 12 but it may have a different value. Fiscal year configurations give you the flexibility to set shorter financial periods within a 12-month period. For example, if your organization has two 6-month fiscal periods over a 12-month span, then the value in this column would be 6.

For Oracle Financial Services Analytical Applications, the default setting is a calendar year and the value in the fiscal period column is 12. If you set your fiscal period to any value other than 12, the system automatically treats this setting as a fiscal year configuration. Valid fiscal periods include 1, 2, 3, 4, 6, or 12 months. Note that fiscal period values of other than 1, 2, 3, 4, 6, or 12 months are not supported and will cause application runtime errors.

Start-Month Column: This column holds a value that represents the first month of your financial year. Calendar years, which always begin in January, have a Start Month value of 1. Start month would have a value of 3 if your fiscal year were to begin in March and a value of 7 if your fiscal year were to begin in July.

For Oracle Financial Services Analytical Applications, the default setting is a calendar year so the starting month value is 1. Note that starting month values of less than 1 or greater than 12 are not supported and will cause application runtime errors.