My Oracle Support Banner

GLPPOS Posting Huge Journals Errors with ORA-01652 Unable To Extend Temp Segment By 128 in Tablespace TEMP (Doc ID 1291522.1)

Last updated on JULY 31, 2023

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:GLPPOS - Posting
ORA-01652

Symptoms

On : 12.1.3 version, Posting

When attempting to post large journals the following error occurs in the log file:
Other journals can post fine. The issue is only with journals that are huge.

Error
------
SHRD0043: ERROR: ORA-01652: unable to extend temp segment by 128 in table space TEMP

The issue can be reproduced at will with the following steps:
1. Journals > Enter > Post
2. Try to post the journal
3. Check the log file for the error

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.