Synchronize Territory Assignment Rules Error ORA-01652 (Doc ID 1496165.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Territory Management - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Jul-2017***

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

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