OBIA 7.9.6.4: Column CAL_WEEK in Table W_DAY_D Is Populated as "Week0" instead of "Week53" for Last European Calendar Week

(Doc ID 2207576.1)

Last updated on JULY 03, 2018

Applies to:

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

Symptoms

On Oracle Business Intelligence Application Consumer (OBIA) 7.9.6.4 version,

For task SIL_DayDimension, Column 'CAL_WEEK' in table W_DAY_D is populated as "Week0" instead of "Week53" for the last Week in European Calendar.

 

Environment Details:

Calendar Used for populating W_DAY_D: European Calendar
OBIA version: Oracle Business Intelligence Application 7.9.6.4
Informatica Version: 9.1.0
DAC Version: 11g
Source System : EBS R12

Cause

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