Oracle Retail Analytics Error Table (E$_) Has Missing Column RTL_TYPE_CODE

(Doc ID 1902227.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising Insights - Version 13.3.6 to 13.3.7 [Release 13.3]
Information in this document applies to any platform.

Symptoms

Oracle Retail Analytics 13.3.x Error Table (E$_) has a missing column: RTL_TYPE_CODE.

Steps to Recreate:

  1. Run the batch slsilsil.ksh, which will invoke MASTER_SIL_RETAIL_SALESTRANSACTIONFACT.
  2. Check the steps 'Create Error Table' and 'Insert AK errors'.
  3. It can be observed that both these steps do not have RTL_TYPE_CODE, which is missing from the E$ table.

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