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