ORA-00922 OR Memory Exhausted Tablespace Errors Running Initial Load For Opportunities Request In Sales Administrator In Release 11i (Doc ID 453339.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Sales Foundation - Version 11.5.9 to 11.5.10.0 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
ASF_OPP_TOP_MV_TEMP
ASF_OPP_CHN_FRCST_MV_TEMP

Checked for relevance on 10-Dec-2009
Checked for relevance on 13-Feb-2013


Symptoms

Receive one of the following errors while running concurrent program Initial Load for Opportunities Reports.
Error
ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-03114: not connected to ORACLE
memory exhausted
Program exited with status 1
Concurrent Manager encountered an error while running SQL*Plus for your concurrent request
OR
Creating ASF_OPP_TOP_MV_TEMP table 
Enter value for nop: EXEC FND_CONC_STAT.COLLECT;
tablespace SHD pctfree 0 parallel EXEC FND_CONC_STAT.COLLECT;
ERROR at line 3:
ORA-00922: missing or invalid option
 
Steps To Reproduce:
  • (R) Oracle Sales Administrator
  • (N) Concurrent Requests  
  • Run Single Request Initial Load for opportunities
  • Program completes with 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