My Oracle Support Banner

Discrete MFG ECC V11 - Discrete Jobs 1st Load Fails With ORA-01652 (Doc ID 3037699.1)

Last updated on NOVEMBER 27, 2024

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.4 and later
Oracle Work in Process - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Applicable for WIP - Work in Process ECC (Enterprise Command Center) Discrete Manufacturing v11 to v14.


After the ECC - Enterprise Command Center upgrade from V9 to V11 we are not able to load WIP data (WIP ECC Data load) due to 2 data set (wip-wodelaydetails, wip-ospdetails2) with the following error:


WIP_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO with dataset wip-ospdetails2 for job <xxxxxxx> ORA-01652: unable to extend temp segment by 32 in tablespace TEMP
WIP-WODELAYDETAILS Data Set Key wip-wodelaydetails - There are 0 documents processed successfully and <yyyyyyy> documents failed to be processed.


The issue can be reproduced at will with the following steps:

1. Work in Process responsibility
2. Navigate to WIP > Reports
3. Run WIP Data (WIP ECC Data) load report for all sets and full load mode.
4. Check the logs.



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!


In this Document
Symptoms
Changes
Cause
Solution
References


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