Oracle Retail Analytics Error Table (E$_) Has Missing Column RTL_TYPE_CODE
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.
Oracle Retail Analytics 13.3.x Error Table (E$_) has a missing column: RTL_TYPE_CODE.
Steps to Recreate:
- Run the batch slsilsil.ksh, which will invoke MASTER_SIL_RETAIL_SALESTRANSACTIONFACT.
- Check the steps 'Create Error Table' and 'Insert AK errors'.
- It can be observed that both these steps do not have RTL_TYPE_CODE, which is missing from the E$ table.
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