GLPPOS After DB Upgrade to 11.2.0.4.0 or 12.1.0.1 or 12.1.0.2 Posting Program Has Poor Performance Stuck in Glpubr Module (Doc ID 1602141.1)

Last updated on NOVEMBER 24, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 to 12.2.2 [Release 11.5.10 to 12.2]
Oracle Database - Standard Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Executable: GLPPOS - Posting
Executable: GLPPOSS module: Posting: Single Ledger

Symptoms

GLPPOS Posting program gets stuck on glpubr.concurrency() after the database has been upgraded to RDBMS 11.2.0.4 or 12.1.0.1 or 12.1.0.2.
Journal Posting runs slowly and appears to hang in >> glpubr.

General Ledger: Version : 11.5.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLPPOS module: Posting
+---------------------------------------------------------------------------+
>> glpubr() 19-AUG-2015 15:58:58
<< glpubr() 19-AUG-2015 16:42:38

General Ledger: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
GLPPOSS module: Posting: Single Ledger
+---------------------------------------------------------------------------
>> glpubr.concurrency() 03-JUN-2016 16:25:20
<< glpubr.concurrency() 03-JUN-2016 16:25:20
SHRD0147: Finished processing rows
SHRD0180: glpubr() - Performing action >> update_gl_balances...
PERF0005: Oracle error detected in glpubr() - ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
<x glpubr() 03-JUN-2016 16:32:01
>> gluerr() 03-JUN-2016 16:32:01

The PERF0005 message error can be also as below:
PERF0005: Oracle error detected in glpubr() - ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
or PERF0005: Oracle error detected in glpubr() - ORA-1652: unable to extend temp segment by 256 in tablespace TEMP
Also, PERF0005 message error may not be present in the logs, but can observe performance for glpubr() process.

Changes

Database upgraded to 11.2.0.4 or 12.1.0.1 or 12.1.0.2

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