Planning ODS Load Worker Failes With ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1' (Doc ID 3062241.1)

Last updated on DECEMBER 05, 2024

Applies to:

Symptoms

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

ERROR
-----------------------
03-DEC 00:55:12 : Error in PROCEDURE=[MULTIPLE PROCEDURES COULD CAUSE THE ISSUE]
03-DEC 00:55:12 : ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1'
03-DEC 00:55:12 : Procedure TRUNCATE [VARIOUS TABLES COULD BE TRUNCATED] started.
03-DEC 00:55:12 : 0 minutes elapsed.


The issue can be reproduced at will with the following steps:
1.  Advanced Supply Chain Planner > Collections > Oracle Systems > Standard Collections.
2.  Enter paramters for the Planning Data Pull and Planning ODS Load concurrent programs.
3.  Submit the request.

Cause

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