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
Million Knowledge Articles and hundreds of Community platforms