My Oracle Support Banner

R12 Journal Entries Report (XLAJELINESRPT) Has Performance Issue Or Fails With Error: "java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1" (Doc ID 1141673.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Receivables - Version 12.0.0 to 12.1 [Release 12.0 to 12.1]
Oracle Cost Management - Version 12.0.0 to 12.1.1 [Release 12 to 12.1]
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Subledger Accounting - Version 12.0.0 and later
Oracle General Ledger - Version 12.0.0 to 12.1 [Release 12.0 to 12.1]
Information in this document applies to any platform.
XLAJELINESRPT



Symptoms

On : 12.0.6 version, Standard Reports & Inquiries
XLAJELINESRPT module: Journal Entries Report is either taking a number of hours to complete or fails with the error "java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1"

EXPECTED BEHAVIOR
-----------------------
To complete successfully and in a "reasonable" time


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to publish report and utilize the information for administration.

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
Cause
Solution
 Still Have Questions?
References


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