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 to Import Data" help topic.