Synchronize Territory Assignment Rules Error ORA-01652
(Doc ID 1496165.1)
Last updated on SEPTEMBER 16, 2019
Applies to:
Oracle Territory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
In 12.1.3, after upgrading from 11i no territories are getting assigned therefore run STAR program in Total mode for Service fails:
Process failed with error:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
We had 10GB of TEMP space and increased to 14 GB. The process still fails.
+---------------------------------------------------------------------------+
CRM Foundation: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
JTY_STAR module: Synchronize Territory Assignment Rules
+---------------------------------------------------------------------------+
Current system time is 09-AUG-2012 14:12:01
+---------------------------------------------------------------------------+
**Starts**09-AUG-2012 14:12:01
**Ends**09-AUG-2012 15:26:25
-1652 : ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
0
Finished executing request completion options.
+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Synchronize Territory Assignment Rules" has completed with error.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 09-AUG-2012 17:02:41
+---------------------------------------------------------------------------+
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 |
Cause |
Solution |
References |