My Oracle Support Banner

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 FEBRUARY 22, 2018

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 22-Feb-2018


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




To view full details, 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 a vibrant support community of peers and Oracle experts.