How do you configure Multiple Calendars In OBIA Version 7.9.6.4 for Source system EBS Ora R12.1.3 (Doc ID 1674746.1)

Last updated on JULY 04, 2014

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Goal

On : 7.9.6.4 version, DataWarehouse

Issue with Multiple calendars in OBIA version 7.9.6.4, Ora R12.1.3

During Upgrade to 7.9.6.4 from 7.9.6.3, W_MCAL_WEEK_D and W_ENT_WEEK_D tables are not getting populated if we use the Oracle EBS Fiscal calendar as the Enterprise Calender. We were recommended to use the generated calendar of 5-4-4. This year, the corporate calendar has changed, and this is resulting in a non 5-4-4 format, and it doesn't fit the 13 period calender either. If we switch to the Oracle EBS calender, how can we get the Week level data ?

Is there a Oracle patch that we can apply? Also, what would be the risk and the appropriate plan to move to the Oracle EBS calender from the generated calendar without impacting the financial / sales data.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms