ORMA Calendar Gets Set Up Only Until 31-DEC-2012 (Doc ID 2074371.1)

Last updated on NOVEMBER 05, 2015

Applies to:

Oracle Retail Merchandising Analytics - Version 14.0 and later
Information in this document applies to any platform.

Symptoms

After Oracle Retail Merchandising Analytics (RMA) calendar installation, the MCAL_DAY_DT column of the W_MCAL_DAY_D table has a maximum value set to 31-DEC-12.

Pre-requisites:
   a. refreshODIvariables.ksh
   b. etlrefreshgensde.ksh

Calendar Batches:
Execute mcalperiodsde.ksh, gregcaldaysil.ksh, gregcalmthsil.ksh, gregcalqtrsil.ksh, gregcalyearsil.ksh, gregcalweeksil.ksh, mcalcfgsil.ksh (this is expected to be run only during installation), mcalsil.ksh (this too is expected to be run only during installation), mcalperiodsil.ksh, mcaldaysil.ksh, mcalqtrsil.ksh, mcalwk454sil.ksh, mcalyrsil.ksh, timedaysil.ksh, and timeminutedaysil.ksh.

 

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