R12: GLELIM Intercompany Eliminations Program Ends in ORA-01652: Unable to Extend Temp Segment by 128 in Tablespace
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle General Ledger - Version 220.127.116.11 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
Million Knowledge Articles and hundreds of Community platforms