My Oracle Support Banner

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

Last updated on APRIL 06, 2021

Applies to:

Oracle Territory Management - Version 12.1.3 and later
Information 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


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