Table V_W_RTL_ITEM_D_TMP Is Invalid; View for This Table Thus Produces "ORA-04063" Error (Doc ID 2037958.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

After installation of Retail Analytics (RA) 14.0, we note that view V_W_RTL_ITEM_D_TMP is invalid due to missing table W_RTL_ITEM_D_TMP.


Steps to Reproduce:

  1. Perform query:  select count(*) from V_W_RTL_ITEM_D_TMP
  2. The following error occurs:  "ERROR at line 1: ORA-04063: view "RARMSUSER.V_W_RTL_ITEM_D_TMP" has error"

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