GLPPOS PERF0005: Oracle error detected in glpubr() - ORA-01652: unable to extend temp segment by ### in tablespace XXXX

(Doc ID 2150242.1)

Last updated on MARCH 13, 2018

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
GLPPOS

Symptoms

While trying to post any size journal from any application module, the following error is seen in the log:

<< glpubr.concurrency() 03-JUN-2016 10:26:43
SHRD0147: Finished processing rows
PERF0005: Oracle error detected in glpubr() - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Log does Not indicate a performance issue -
Start - Current system time is 03-JUN-2016 16:25:19
End - gluerr() 03-JUN-2016 16:32:01

Review of the TEMP table size and free space does not indicate an issue.

Changes

 Issue is occurring after migration of the application to a new Linux platform from HPUX.

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