My Oracle Support Banner

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

Last updated on AUGUST 16, 2022

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(Alternate Key) errors'.
  3. It can be observed that both these steps do not have RTL_TYPE_CODE, which is missing from the E$ table.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.