My Oracle Support Banner

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 NOVEMBER 01, 2017

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.