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 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.

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


Receive one of the following errors while running concurrent program Initial Load for Opportunities Reports.
ORA-24323: value not allowed
Error accessing package DBMS_APPLICATION_INFO
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
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


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