Initial Data Loading Into Oracle Retail Analytics (RA): Missing Tables W_MCAL_DAY_DM and C_ODI_LOAD (Doc ID 2054284.1)

Last updated on SEPTEMBER 14, 2015

Applies to:

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


What are the batches/programs that should be executed to get initial data into the W_MCAL_DAY_DM and C_ODI_LOAD tables in Oracle Retail Analytics (RS)?    The RA Operations Guide [ra-140-og.pdf, page 43], states that the tables W_MCAL_DAY_DM and C_ODI_LOAD should be available in the RA database. 


If the program runs successfully, the following results:

  ■ Table W_MCAL_DAY_DM is updated assuming that the current business date is the previous MCAL_NUM ( MCAL_TYPE equal to 'DT') plus one.
  ■ The status table C_ODI_LOAD table is updated. The status is updated to 'ready' for programs with  a 'complete' status.


Can you provide a list of all pre-requisite and mandatory tables that should be present in the RA database before the data load begins? 


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