W_MCAL_DAY_D Table Data Is Incorrect
Last updated on SEPTEMBER 03, 2017
Applies to:Oracle Retail Merchandising Analytics - Version 13.2.4 and later
Information in this document applies to any platform.
W_MCAL_DAY_D data is getting populated incorrectly.
Steps To Recreate:
1. Load time dimension data by executing the SIL batch ( SIL_TimeDimension_MCalDay )
2. Verify W_MCAL_DAY_D table data. In Calendar table, Year entries start with 2001 and there are no records found in W_MCAL_DAY_D table for the 2001 year. Entries in the W_MCAL_DAY_D table started from 2002.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms