My Oracle Support Banner

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 FEBRUARY 15, 2019

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.