My Oracle Support Banner

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 16, 2022

Applies to:

Oracle Retail Merchandising Insights - 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

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.