My Oracle Support Banner

Running the Initial Build of Opportunity and Leads Bins Concurrent Request Receives ORA-12801, ORA-01652 (Doc ID 302059.1)

Last updated on AUGUST 28, 2023

Applies to:

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

Symptoms

You are running the Initial Build of Opportunity and Leads Bins concurrent request and the process is ending in error:

Creating materialized view ASF_ROLLUP_MGR_MV
Snapshot created.
Elapsed: 00:00:00.45
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
Inserting into ASF_SC_BIN_MV
and scd.decision_date = asp.period_Day
*
ERROR at line 68:
ORA-12801: error signaled in parallel query server P003
ORA-01652: unable to extend temp segment by 1280 in tablespace OSMD

Responsibility: Oracle Sales Administrator
Navigate: Concurrent Requests, Run, single request, Initial Build of Opportunity and Leads Bins
Parameters: No of processes (tried several options)
Extent size S, M L (have tried all 3)

Changes

 

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.