Planning ODS Load Worker Fails with ORA-12801 and ORA-01652 on PROCEDURE=LOAD_BOM_COMPONENTS, TABLE=MSC_BOM_COMPONENTS (Doc ID 1340498.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

In Advance Supply Chain Planning, on a Decentralized Configuration having a 12.1.3 Destination Instance and a 11.5.10.2 Source Instance:

When attempting to run a Complete Refresh of Planning Data Collections, MSCPDCW module: Planning ODS Load Worker fails with the following error messages:

Error in PROCEDURE=LOAD_BOM_COMPONENTS, TABLE=MSC_BOM_COMPONENTS
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP2
ORA-12801: error signaled in parallel query server P000
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1
ORA-12801: error signaled in parallel query server P000
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1


We incrementally increased the temp tablespace and re-ran collections each time.  Collections continued to fail.

STEPS:
1. Submit Planning Data Collections (Standard Collections)
2. Note the error in the Planning ODS Load Worker log file

Cause

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 hundreds of Community platforms