Tables Present in Both RDE_DM Schema As Well As RADM Schema, but Not Used in RDE ODI Interfaces (Doc ID 2166080.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Goal

In Oracle Retail Merchandising Insights (RMI), there are tables present in both RDE_DM schema as well as RADM schema that are not used in the Retail Data Extractor (RDE) ODI interfaces:

W_RTL_MARKET_PROD_BRAND_DS_TL
W_RTL_PROD_HIER_IMAGE_DS

There is INTERFACE in Retail Insights which is picking data from these tables, but there is no interface in RDE which feeds these tables.  If users run the universal adapter batch to generate a .dat file, it throws an exeption saying W_RTL_PROD_HIER_IMAGE_DS/W_RTL_MARKET_PROD_BRAND_DS_TL are not mentioned in C_ODI_PARAM table.

 

Also, the ./rtluasde.ksh W_RTL_SLSPR_TX_IT_LC_DY_FS program fails in putty and throws an error also saying "not defined in C_ODI_PARAM" when checked in ODI operator.
 

Solution

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