R12: GLELIM Intercompany Eliminations Program Ends in ORA-01652: Unable to Extend Temp Segment by 128 in Tablespace

(Doc ID 732497.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version to 12.0.6 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.
***Checked for relevance on 07-Dec-2012***
GLELIM module: Intercompany Eliminations Program


GLELIM Intercompany Eliminations Program is completing with the following error:

SHRD0181: glemst() - sqlstmtbuf(len) = 3374
SHRD0180: glemst() - Performing action >> exec_ins_gl_elimination_int_stmt...
SHRD0026: Current system time is: 14-AUG-2008 17:20:32
PERF0005: Oracle error detected in glemst() - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Increasing the TEMP tablespace does not resolve the issue.

Alternatively, increasing the TEMP tablespace causes the issue to get resolved, but a performance degradation is observed for this program.


Upgraded database from 9i to 10G.


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