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 11.5.10.2 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

Symptoms

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.

Changes

Upgraded database from 9i to 10G.

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