Pages

Thursday 15 November 2012

Extending Oracle BI Applications Calendars

The end of fiscal year is near, and it is a good time to extend Oracle BI Applications (OBIA) calendars.

The system that I'm going to describe in this post is an OBIA 7.9.6.1 which is integrated with Oracle EBS 12.1.1 source system. The current 2013 fiscal year ends on 03/02/2013. The fiscal calendars (both source and generated) should be extended till the end of 2016 fiscal year which will be on 31/01/2016. The Gregorian calendar should be extended till the 31/12/2016 accordingly.

The OBIA supports Enterprise or Global calendar (cross-functional reporting calendar, can be fiscal or Gregorian), Fiscal calendar (can be accounting or financial), Gregorian calendar, 4-4-5 and 13 period calendars. The Time Dimension that represents those calendars uses the following tables from Oracle Business Analytics Warehouse (OBAW):

Gregorian Calendar
  • W_DAY_D
  • W_WEEK_D
  • W_MONTH_D
  • W_QTR_D
  • W_YEAR_D
Multiple Fiscal Calendars (both source and generated)
  • W_MCAL_DAY_D
  • W_MCAL_WEEK_D
  • W_MCAL_PERIOD_D
  • W_MCAL_QTR_D
  • W_MCAL_YEAR_D
Enterprise Calendar
  • W_ENT_WEEK_D
  • W_ENT_PERIOD_D
  • W_ENT_QTR_D
  • W_ENT_YEAR_D