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 DECEMBER 19, 2022
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
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
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 |