My Oracle Support Banner

FII_AR_NET_REC_BASE_MV ORA-00942: Table Or View Does Not Exist. (Doc ID 727748.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Financials Intelligence - Version 7.3 and later
Information in this document applies to any platform.

Symptoms

When running the initial load for Receivables Management and Receivables Status whith "Initial Load"
option, it fails with the following:

Start refreshing for FII_AR_NET_REC_BASE_MV, mode INIT
MV compile state : COMPILATION_ERROR.
Performing Initial loading
DB Version: 10.2.0.2.0
Atomic refresh: false
FII_AR_NET_REC_BASE_MV was altered to parallel

Error occurred:
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist

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

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