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.
- Example of GLPPOS log:
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
- Example of GLPPOSS log:
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