1. Administration Guide
  2. Enabling Fiscal Calendars

Enabling Fiscal Calendars

In order to enable fiscal calendars in the business intelligence applications, you must populate data in the AD_TIME table. Populate the AD_TIME table as follows:

  • FISCAL_YEAR VARCHAR2(50)
  • FISCAL_QUARTER_ID VARCHAR2(50)
  • FISCAL_MONTH_ID VARCHAR2(50)
  • FISCAL_WEEK_ID VARCHAR2(50)
  • FISCAL_DAY VARCHAR2(50)

These columns correlate the calendar dates to fiscal dates. This data can be loaded using CSV files. For more details, see the Using the CSV Utility help.