My Oracle Support Banner

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

Last updated on MAY 03, 2018

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

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


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.