Warehouse Generated Calendars Configuration Overview

In the data warehouse, you can generate calendars such as 4-4-5 or 13-period calendars.

  • The table W_MCAL_WEEK_D is populated only for generated calendars (e.g., 4-4-5, 13-period).

  • For non-generated calendars (OLTP-sourced fiscal calendars), the week-related enterprise columns in W_DAY_D remain null.

  • If a non-generated calendar is selected as the Enterprise Calendar, the table W_ENT_WEEK_D will not be populated.

For 13 period calendars, there is no concept of Quarter, therefore all Quarter columns in W_MCAL_WEEK_D, W_MCAL_PERIOD_D, W_MCAL_YEAR_D will be null.

W_ENT_QTR_D will not be populated if a 13 period calendar is chosen as the Enterprise Calendar.

For Oracle E-Business Suite source calendars, no configuration entries are required

Warehouse-generated calendars must be configured using the inline dataset FILE_MCAL_CONFIG_G.

Column Details:

CALENDAR_NAME - The name of the calendar that is being configured.

CALENDAR_CLASS - Generally it will be 'Generated'

PERIOD_TYPE - The type of the calendar period that is being configured, such as 4-4-5.

CAL_ST_DT - The date from which the calendar generation begins.

CAL_END_DT - The date at which the calendar generation ends.

CAL_OFFSET - The offset which identifies the start date of the calendar. Valid Start Day and Offset values are: Monday 0 Tuesday 1 Wednesday 2 Thursday 3 Friday –3 Saturday –2 Sunday –1

WEEK_ALLOCATION_RULE - This parameter determines how weeks are allocated in the calendar that is being configured. For example, 4-4-5, 5-4-4, 4-5-4, or 13 period.

REFERENCE_DATE - The date (in MMDD format) that the fiscal year starts. For example, if an organization's fiscal year is from October to September, then the reference_date value should be 0929. The previous fiscal year must end between three days before and three days after the date specified by REFERENCE_DATE (that is, within the range (REFERENCE_DATE - 3) to (REFERENCE_DATE + 3). In other words, if a REFERENCE_DATE is 0131 for 31st January, the previous fiscal year cannot exceed 3rd February.

Other standard columns

Such as W_INSERT_DT, W_UPDATE_DT, TENANT_ID, X_CUSTOM.