My Oracle Support Banner

Initial Load For Leads Error ORA-00942 table or view does not exist (Doc ID 412600.1)

Last updated on AUGUST 21, 2019

Applies to:

Oracle Sales Online - Version 11.5.9 to 11.5.10.2 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.

Symptoms

Running Initial Load for Leads reports for Sales Online but the request fails with error:

Selecting JTF tablespaces and username

APPS_TS_TX_DATA APPS_TS_TX_IDX JTF

Creating table ASF_LEADS_TOP_MV_TEMP
as select * from ASF_LEADS_TOP_MV
*
ERROR at line 4:
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.