Planning ODS Load Program Is Failing With ORA-01659 (Doc ID 2394784.1)

Last updated on JULY 25, 2023

Applies to:

Symptoms

When attempting to run the Data Collections, the following error occurs in the Planning ODS Load/Worker (MSCPDC/MSCPDCW)...

ERROR
-----------------------
30-APR 06:12:40 : ORA-12801: error signaled in parallel query server P00H, instance avedq01db02.ae.ge.com:evnapsq12 (2)
ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace APPS_XL_TX_IDX
ORA-12801: error signaled in parallel query server P00C, instance avedq01db02.ae.ge.com:evnapsq12 (2)
ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace APPS_XL_TX_IDX
30-APR 06:12:40 : NONUNIQUE index creation on temporary table BOM_COMPONENTS_AP1 has completed with ERROR.
30-APR 06:12:40 : User-Defined Exception
30-APR 06:12:40 : User-Defined Exception
30-APR 06:12:40 : User-Defined Exception
30-APR 06:12:40 : Sending message :
            -9999999 to monitor.
30-APR 06:12:40 : Error_Stack...
30-APR 06:12:40 : ORA-06510: PL/SQL: unhandled user-defined exception

30-APR 06:12:40 : Error_Backtrace...
30-APR 06:12:40 : ORA-06512: at "APPS.MSC_CL_COLLECTION", line 2341
ORA-06512: at "APPS.MSC_CL_COLLECTION", line 3848

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Data Collections

Cause

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